Convinience_Store

Tables (4)

items

  • item id (item_id) — INT() — Primary key — NOT NULL
  • type id (type_id) — INT() — Foreign key → types.type id — NOT NULL
  • item name (item_name) — VARCHAR(50)
  • item price (item_price) — INT()

stocks (store_stocks)

  • 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 count (stock_count) — INT()

stores

  • store id (store_id) — INT() — Primary key — NOT NULL
  • store name (store_name) — VARCHAR(20)

types

  • type id (type_id) — INT() — Primary key
  • type name (type_name) — VARCHAR(20)