또티클

테이블 (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