| id | int(11) |
|
|
|
| sale_id | int(11) |
|
|
|
| product_id | int(11) |
|
|
|
| product_name | varchar(100) |
|
|
|
| quantity | int(11) |
|
|
|
| price | decimal(16,2) |
|
|
|
| unit_cogs | decimal(18,6) |
|
|
|
| unit_overhead | decimal(16,2) |
|
|
0.00
|
| subtotal | decimal(16,2) |
|
|
|
| discount | decimal(16,2) |
|
|
0.00
|
| created_at | timestamp |
|
|
current_timestamp()
|
| updated_at | timestamp |
|
|
current_timestamp()
|