smoofi-erd
Tables (11)
CateGory
- category_id — varchar(20) — Primary key — NOT NULL
- category_name — varchar(20) — NOT NULL
- parent_id — varchar(20) — Foreign key → CateGory.category_id — NOT NULL
- level — tinyint
CostMaster
- cost_id — varchar(20) — Primary key — NOT NULL
- cost_name — varchar(30) — NOT NULL
- cost — int — NOT NULL
ExpenditureDetail
- expenditure_id — varchar(20) — Primary key — NOT NULL
- warehouse_id — varchar(20) — Foreign key → Warehouse.warehouse_id — NOT NULL
- expenditure_date — datetime — NOT NULL
- expenditure_charge — int — NOT NULL
- expenditure_category — varchar(30) — NOT NULL
- note — varchar(100) — NOT NULL
- expenditure_history — varchar(50) — NOT NULL
Product
- product_id — varchar(10) — Primary key — NOT NULL
- product_lotno — varchar(20) — Primary key — NOT NULL
- category_id — varchar(20) — Foreign key → CateGory.category_id — NOT NULL
- price — int — NOT NULL
- brand — varchar(30) — NOT NULL
- product_width — int — NOT NULL
- product_length — int — NOT NULL
- product_height — int — NOT NULL
- product_weight — int — NOT NULL
- product_name — varchar(30) — NOT NULL
- expiration_period — datetime — NOT NULL
RevenueDetail
- revenue_id — varchar(20) — Primary key — NOT NULL
- warehouse_id — varchar(20) — Foreign key → Warehouse.warehouse_id — NOT NULL
- revenue_date — daatetime — NOT NULL
- revenue_charge — int — NOT NULL
- revenue_category — varchar(30) — NOT NULL
- note — varchar(100)
- revenue_history — varchar(50)
Section
- section_id — varchar(20) — Primary key — NOT NULL
- warehouse_id — varchar(20) — Foreign key → Warehouse.warehouse_id — NOT NULL
- section_width — int — NOT NULL
- section_length — int — NOT NULL
- section_height — int — NOT NULL
- section_weight — int — NOT NULL
Stock
- stock_id — varchar(20) — Primary key — NOT NULL
- warehouse_id — varchar(20) — Foreign key → Warehouse.warehouse_id — NOT NULL
- product_name — varchar(30) — NOT NULL
- unit — varchar(50)
- total — int — NOT NULL
- product_id — varchar(10) — Foreign key → Product.product_id — NOT NULL
- product_lotno — varchar(20) — Foreign key → Product.product_lotno — NOT NULL
- expiration_period — datetime — NOT NULL
StockHistory
- stock_id — varchar(20) — Foreign key → Stock.stock_id — NOT NULL
- assortment — enum — NOT NULL
- product_name — varchar(30) — NOT NULL
- before_amount — int — NOT NULL
- amount — int — NOT NULL
- after_amount — int — NOT NULL
- history_date — datetime — NOT NULL
StockTaking
- stocktaking_id — varchar(20) — Primary key — NOT NULL
- warehouse_id — varchar(20) — NOT NULL
- product_id — varchar(30) — NOT NULL
- product_name — varchar(30) — NOT NULL
- total — int — NOT NULL
- lotno — varchar(30) — NOT NULL
- unit — varchar(10)
- computerized_stock — int — NOT NULL
- physical_stock — int — NOT NULL
- difference_quantity — int — NOT NULL
- note — varchar(100)
Warehouse
- warehouse_id — varchar(20) — Primary key — NOT NULL
- warehouse_name — varchar(30) — NOT NULL
- warehouse_location — varchar(50) — NOT NULL
- warehouse_contact — varchar(13) — NOT NULL
- manager — varchar(20) — NOT NULL
counting
- stock_id — varchar(20) — Foreign key → Stock.stock_id — NOT NULL
- stocktaking_id — varchar(20) — Foreign key → StockTaking.stocktaking_id — NOT NULL