| id |
int(11)
|
|
|
|
| asset_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| serial_number |
int(11)
|
|
|
|
| category_id |
int(11)
|
|
|
|
| name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| description |
text
|
utf8mb4_unicode_ci
|
|
|
| addition_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| added_date |
date
|
|
|
|
| quantity |
int(11)
|
|
|
|
| unit_price |
decimal(14,2)
|
|
|
|
| total_value |
decimal(16,2)
|
|
|
|
| depreciation_rate |
decimal(5,2)
|
|
|
|
| warehouse_id |
int(11)
|
|
|
 浏览不相关的值
|
| space_id |
int(11)
|
|
|
|
| current_location |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| supplier |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| supplier_id |
int(11)
|
|
|
浏览不相关的值
|
| warranty_expiry |
date
|
|
|
|
| status |
enum('active', 'under_maintenance', 'disposed', 'damaged')
|
utf8mb4_unicode_ci
|
|
|
| image |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| depreciation_method |
enum('straight_line', 'declining')
|
utf8mb4_unicode_ci
|
|
|
| useful_life_years |
int(11)
|
|
|
|
| salvage_value |
decimal(14,2)
|
|
|
|
| accumulated_depreciation |
decimal(14,2)
|
|
|
|
| last_depreciation_date |
date
|
|
|
|
| journal_entry_id |
int(11)
|
|
|
|
