Workshop

Tables (3)

Items (items)

  • Item_id (item_id) — INT — Primary key — NOT NULL
  • Item_name (item_name) — TEXT
  • Created_at (created_at) — DATE
  • Dead_line (dead_line) — DATE

StockManagement (stockmanagement)

  • Stock_id (stock_id) — INT — Primary key — NOT NULL
  • Store_id (store_id) — INT — Foreign key → Stores.Store_id — NOT NULL
  • Item_id (item_id) — INT — Foreign key → Items.Item_id — NOT NULL
  • Stock (stock) — INT
  • Receving_date (receving_date) — DATE
  • Price (price) — INT

Stores (stores)

  • Store_id (store_id) — INT — Primary key — NOT NULL
  • Address (address) — TEXT