mukpick

테이블 (21)

동행 (with_pick)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (img) — image
  • Field (name) — varchar(50)

디저트음료픽 (desert_beverage_pick)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (img) — image
  • Field (name) — varchar(50)

디저트픽 (dessert_pick)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (img) — image
  • Field (name) — varchar(50)

디저트픽_디저트음료픽 (rel_dessert_dessert_beverage)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (dessert_pick) — int — 외래 키 → 디저트픽.Key — NOT NULL
  • Key (dessert_beverage_pick) — int — 외래 키 → 디저트음료픽.Key — NOT NULL

먹픽 (food_pick)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (img) — image
  • Field (name) — varchar(50)

먹픽_음료픽 (rel_food_beverage)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (food_pick) — int — 외래 키 → 먹픽.Key — NOT NULL
  • Key (beverage_pick) — int — 외래 키 → 음료픽.Key — NOT NULL

먹픽_주류픽 (rel_food_liquor)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (food_pick) — int — 외래 키 → 먹픽.Key — NOT NULL
  • Key (liquor_pick) — int — 외래 키 → 주류픽.Key — NOT NULL

무비레이팅 (movie_rating)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (rating) — Rating
  • Key (movie) — int — 외래 키 → 무비픽.Key — NOT NULL

무비픽 (movie_pick)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (img) — image
  • Field (korName) — varchar(50)
  • Field (engName) — varchar(50)
  • Field (year) — date
  • Field (director) — varchar(50)
  • Field (actors) — varchar(200)
  • Field (genre) — varchar(200)
  • Field (filmRating) — enum, varchar(10) — 상영등급
  • Field (country) — varchar(20)
  • Field (screeningTime) — varchar(30)

안주픽 (snack_pick)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (img) — image
  • Field (name) — varchar(50)

안주픽_주류픽 (rel_snack_liquor)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (liquor_pick) — int — 외래 키 → 주류픽.Key — NOT NULL
  • Key (snack_pick) — int — 외래 키 → 안주픽.Key — NOT NULL

여행픽 (travel_pick)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (img) — image
  • Field (name) — varchar(50)

여행픽_동행픽_이동수단픽 (rel_travel_with_transport)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (travel_pick) — int — 외래 키 → 여행픽.Key — NOT NULL
  • Key (with_pick) — int — 외래 키 → 동행.Key — NOT NULL
  • Key (transport_pick) — int — 외래 키 → 이동수단.Key — NOT NULL

음료픽 (beverage_pick)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (img) — image
  • Field (name) — varchar(50)

이동수단 (transport_pick)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (img) — image
  • Field (name) — varchar(50)

주류픽 (liquor_pick)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (img) — image
  • Field (name) — varchar(50)

히트_디저트픽_디저트음료픽 (hit_dessert_dessert_beverage)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (dessert_dessert_beverage) — int — 외래 키 → 디저트픽_디저트음료픽.Key — NOT NULL
  • Field (hitCount) — int
  • Field (hitDate) — date

히트_먹픽_음료픽 (hit_food_beverage)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (food_beverage) — int — 외래 키 → 먹픽_음료픽.Key — NOT NULL
  • Field (hitCount) — int
  • Field (hitDate) — date

히트_먹픽_주류픽 (hit_food_liquor)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (food_liquor) — int — 외래 키 → 먹픽_주류픽.Key — NOT NULL
  • Field (hitCount) — int
  • Field (hitDate) — date

히트_안주픽_주류픽 (hit_snack_liquor)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (snack_liquor) — int — 외래 키 → 안주픽_주류픽.Key — NOT NULL
  • Field (hitCount) — int
  • Field (hitDate) — date

히트_여행픽_동행픽_이동수단픽 (hit_travel_with_transport)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (travel_with_transport) — int — 외래 키 → 여행픽_동행픽_이동수단픽.Key — NOT NULL
  • Field (hitCount) — int
  • Field (hitDate) — date