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