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 | 4 months ago | ||
product_id | int(11) | YES | 4 months ago | |||
transaction_type | enum('Purchase','Sale','Return') | NO | 4 months ago | |||
quantity | int(11) | NO | 4 months ago | |||
transaction_date | date | NO | 4 months ago |