| id |
int(10)
|
|
|
|
| asset_tag |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| type |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| brand |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| model |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| serial_number |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| hostname |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('active', 'maintenance', 'loaned', 'retired', 'lost')
|
utf8mb4_unicode_ci
|
|
|
| condition_status |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| location_id |
int(10)
|
|
|
|
| assigned_employee_id |
int(10)
|
|
|
|
| purchase_date |
date
|
|
|
|
| purchase_value |
decimal(14,2)
|
|
|
|
| supplier |
varchar(140)
|
utf8mb4_unicode_ci
|
|
|
| invoice |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| warranty_until |
date
|
|
|
|
| ip_address |
varchar(45)
|
utf8mb4_unicode_ci
|
|
|
| mac_address |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| operating_system |
varchar(160)
|
utf8mb4_unicode_ci
|
|
|
| processor |
varchar(160)
|
utf8mb4_unicode_ci
|
|
|
| ram_gb |
decimal(8,2)
|
|
|
|
| storage_info |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(10)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
