|
id
|
int(11)
|
|
|
|
|
name
|
varchar(255)
|
|
|
|
|
unit
|
varchar(20)
|
|
|
|
|
stock
|
decimal(10,2)
|
|
|
0.00
|
|
cost_price
|
decimal(10,2)
|
|
|
0.00
|
|
min_stock
|
decimal(10,2)
|
|
|
10.00
|
|
barcode
|
varchar(100)
|
|
|
|
|
is_weighable
|
tinyint(1)
|
|
|
0
|
|
price_per_pound
|
decimal(10,2)
|
|
|
0.00
|
|
selling_price
|
decimal(10,2)
|
|
|
0.00
|
|
low_stock_threshold
|
decimal(10,2)
|
|
|
5.00
|
|
brand
|
varchar(100)
|
|
|
|
|
units_per_package
|
decimal(10,2)
|
|
|
1.00
|
|
package_price
|
decimal(12,2)
|
|
|
0.00
|