편의점

테이블 (4)

category (Untitled)

  • category_id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • section (Field2)

product (Untitled2)

  • product_id (Key) — 기본 키 — NOT NULL
  • category_id (Key2) — 외래 키 → category.category_id — NOT NULL
  • name (Field)
  • price (Field2)

store (Untitled4)

  • store_id (Key) — 기본 키 — NOT NULL
  • category_id (Key2) — 외래 키 → category.category_id — NOT NULL
  • worker_id (Key3) — 외래 키 → worker.worker_id — NOT NULL
  • product_id (Key4) — 외래 키 → product.product_id — NOT NULL
  • category_id (Key22) — 외래 키 → product.category_id — NOT NULL
  • location (Field)
  • sales (Field3)

worker (Untitled3)

  • worker_id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • age (Field2)
  • working hour (Field3)
  • account (Field4)
  • wage (Field5)