| id |
int(11)
|
|
|
|
| img |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| model |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| brand |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| serial_number |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| serial |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| quantity |
int(11)
|
|
|
|
| category_id |
int(11)
|
|
|
|
| description |
text
|
utf8mb4_general_ci
|
|
|
| status |
enum('available', 'in_use', 'maintenance', 'damaged')
|
utf8mb4_general_ci
|
|
|
| condition_status |
enum('good', 'fair', 'needs_repair', 'broken')
|
utf8mb4_general_ci
|
|
|
| location |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| purchase_date |
date
|
|
|
|
| purchase_price |
decimal(10,2)
|
|
|
|
| warranty_expiry |
date
|
|
|
|
| last_maintenance |
date
|
|
|
|
| image_path |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|