|
id
|
int(11)
|
|
|
|
|
name
|
varchar(180)
|
|
|
|
|
scientific_name
|
varchar(180)
|
|
|
|
|
form
|
varchar(60)
|
|
|
|
|
strength
|
varchar(60)
|
|
|
|
|
unit
|
varchar(40)
|
|
|
|
|
manufacturer
|
varchar(150)
|
|
|
|
|
barcode
|
varchar(80)
|
|
|
|
|
cost_price
|
decimal(12,2)
|
|
|
0.00
|
|
sale_price
|
decimal(12,2)
|
|
|
0.00
|
|
tax
|
decimal(5,2)
|
|
|
0.00
|
|
needs_prescription
|
tinyint(4)
|
|
|
0
|
|
status
|
tinyint(4)
|
|
|
1
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|