convenience store

Tables (5)

branch (CopyOfUntitled)

  • store_id (Key) — int — Primary key — NOT NULL
  • location (Key2) — int — Primary key — NOT NULL
  • manager (Field) — text
  • revenue (Field2) — int
  • open_at (Field3) — date

location (Untitled3)

  • seoul (Field) — int
  • busan (Field2) — int
  • daejeon (Field3) — int
  • gwangyang (Field4) — int
  • location (Key) — int — Foreign key → branch.store_id — NOT NULL

order (Untitled4)

  • order_id (Key) — int — Primary key — NOT NULL
  • product_id (Key2) — int — Foreign key → products.product_id — NOT NULL
  • order_num (Field) — int
  • delivery_date (Field2) — date
  • total (Field3) — int
  • store_id (Key3) — int — Foreign key → branch.store_id — NOT NULL

products (Untitled2)

  • product_id (Key) — int — Primary key — NOT NULL
  • name (Field) — text
  • inventory (Field2) — int
  • expire_date (Field3) — date
  • manufacturer (Field4) — text

staff (Untitled)

  • staff_id (Key2) — int — Primary key — NOT NULL
  • store_id (Key) — int — Foreign key → branch.store_id — NOT NULL
  • name (Field) — text
  • start_at (Field2) — date
  • salary (Field3) — int