편의점
테이블 (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)