|
id
|
int(11)
|
|
|
|
|
purchase_id
|
int(11)
|
|
|
|
|
item_type
|
enum
|
-- |
|
ingredient
|
|
item_id
|
int(11)
|
|
|
|
|
quantity
|
decimal(10,2)
|
|
|
1.00
|
|
unit_cost
|
decimal(12,2)
|
|
|
0.00
|
|
subtotal
|
decimal(12,2)
|
|
|
0.00
|
|
ingredient_id
|
int(11)
|
|
|
|
|
description
|
varchar(255)
|
|
|
|
|
price
|
decimal(12,2)
|
|
|
0.00
|
|
selling_price
|
decimal(12,2)
|
|
|
|
|
discount_percent
|
decimal(5,2)
|
|
|
0.00
|
|
tax_percent
|
decimal(5,2)
|
|
|
0.00
|
|
total
|
decimal(12,2)
|
|
|
0.00
|
|
package_units
|
decimal(10,2)
|
|
|
1.00
|
|
package_cost
|
decimal(12,2)
|
|
|
0.00
|
|
package_qty
|
decimal(10,2)
|
|
|
1.00
|