|
id
|
int(11)
|
|
|
|
|
order_id
|
int(11)
|
|
|
|
|
product_id
|
int(11)
|
|
|
|
|
quantity
|
int(11)
|
|
|
|
|
price
|
decimal(10,2)
|
|
|
|
|
subtotal
|
decimal(10,2)
|
|
|
|
|
notes
|
text
|
|
|
|
|
selections
|
longtext
|
|
|
|
|
printed
|
tinyint(1)
|
|
|
0
|
|
cost_price
|
decimal(10,2)
|
|
|
0.00
|
|
discount_amount
|
decimal(10,2)
|
|
|
0.00
|
|
discount_percent
|
decimal(5,2)
|
|
|
0.00
|
|
kitchen_acknowledged
|
tinyint(1)
|
|
|
0
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|