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