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