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