InventoryTransactions (Inventory Transactions)
Description
This table records all inventory movements, including additions and subtractions.
Columns
| Name | Title | Datatype | Nullable | Other | Description | Last edit |
|---|---|---|---|---|---|---|
| transaction_id | int(11) | NO | auto_increment | 6 months ago | ||
| product_id | int(11) | YES | 6 months ago | |||
| transaction_type | enum('Purchase','Sale','Return') | NO | 6 months ago | |||
| quantity | int(11) | NO | 6 months ago | |||
| transaction_date | date | NO | 6 months ago |