또티클
테이블 (11)
Untitled (Snack)
- Key — INT — 기본 키 — NOT NULL
- Key (shop_id) — INT — 외래 키 → 지점.Key — NOT NULL
- Field (chip) — CHAR
- Field2 (sweets) — CHAR
- Field (gum) — CHAR
Untitled (Food)
- Key — INT — 기본 키 — NOT NULL
- Key (shop_id) — INT — 외래 키 → 지점.Key — NOT NULL
- Field (instant_food) — CHAR
- Field (food_name) — CHAR
Untitled (Alcohol)
- Key — INT — 기본 키 — NOT NULL
- Field (spirits) — CHAR
- Field (beer) — CHAR
- Key (alcohol_line_id) — INT — 외래 키 → 음료.Key — NOT NULL
Untitled (Soda)
- Key — INT — 기본 키 — NOT NULL
- Field (korea) — CHAR
- Field (abroad) — CHAR
- Key (soda_line_id) — INT — 외래 키 → 음료.Key — NOT NULL
Untitled (Milk)
- Key — INT — 기본 키 — NOT NULL
- Field (cheese) — CHAR
- Field (milk) — CHAR
- Key (milk_product_id) — INT — 외래 키 → 음료.Key — NOT NULL
- Key (shop_id) — INT — 외래 키 → 음료.Key — NOT NULL
Untitled (Ramen)
- Key — INT — 기본 키 — NOT NULL
- Field (cup_ramen) — CHAR
- Field (bj_ramen) — CHAR
- Key (instant_food_id) — INT — 외래 키 → Untitled.Key — NOT NULL
Untitled (Frozen)
- Key — INT — 기본 키 — NOT NULL
- Field (mandu) — CHAR
- Field (icecream) — CHAR
- Key (instant_food_id) — INT — 외래 키 → Untitled.Key — NOT NULL
Untitled (UnFrozen)
- Key — INT — 기본 키 — NOT NULL
- Field (name) — CHAR
- Key (instant_food_id) — INT — 외래 키 → Untitled.Key — NOT NULL
음료 (Drinks)
- Key — INT — 기본 키 — NOT NULL
- Key (shop_id) — INT — 외래 키 → 지점.Key — NOT NULL
- Field (alcohol_line) — CHAR
- Field (soda_line) — CHAR
- Field (milk_product) — CHAR
- Field (health_care) — CHAR
지역 (Location)
- Key (KEY) — INT — 기본 키 — NOT NULL
- 이름 (city) — CHAR — NOT NULL
지점 (Shop)
- Key — INT — 기본 키 — NOT NULL
- 지점명 (name) — CHAR — NOT NULL
- Field
- Key (location_id) — INT — 외래 키 → 지역.Key — NOT NULL