|
id
|
int(11)
|
|
|
|
|
equipment_code
|
varchar(50)
|
|
|
|
|
equipment_name
|
varchar(255)
|
|
|
|
|
equipment_type
|
varchar(100)
|
|
|
|
|
brand
|
varchar(100)
|
|
|
|
|
model
|
varchar(100)
|
|
|
|
|
serial_number
|
varchar(100)
|
|
|
|
|
size
|
varchar(100)
|
|
|
|
|
location
|
varchar(200)
|
|
|
|
|
status
|
enum
|
-- |
|
AVAILABLE
|
|
stock_quantity
|
int(11)
|
|
|
0
|
|
min_quantity
|
int(11)
|
|
|
0
|
|
image_path
|
varchar(255)
|
|
|
|
|
notes
|
text
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|
|
last_stock_update
|
timestamp
|
|
|
current_timestamp()
|