|
id
|
int(11)
|
|
|
|
|
img
|
varchar(255)
|
|
|
|
|
name
|
varchar(255)
|
|
|
|
|
model
|
varchar(100)
|
|
|
|
|
brand
|
varchar(100)
|
|
|
|
|
serial_number
|
varchar(255)
|
|
|
|
|
serial
|
varchar(100)
|
|
|
|
|
quantity
|
int(11)
|
|
|
1
|
|
category_id
|
int(11)
|
|
|
|
|
description
|
text
|
|
|
|
|
status
|
enum
|
-- |
|
available
|
|
condition_status
|
enum
|
-- |
|
good
|
|
location
|
varchar(255)
|
|
|
|
|
purchase_date
|
date
|
|
|
|
|
purchase_price
|
decimal(10,2)
|
|
|
|
|
warranty_expiry
|
date
|
|
|
|
|
last_maintenance
|
date
|
|
|
|
|
image_path
|
varchar(500)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|