음주 미식회 1차 ERD
테이블 (19)
alcohol_recom
- alcohol_recom_id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → mebmer.member_id — NOT NULL
- food — varchar(15)
- body — text
- created_at — datetime(6)
- updated_at — datetime(6)
alcohol_recom_feeling
- recom_weather_id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- alcohol_recom_id — bigint — 외래 키 → alcohol_recom.alcohol_recom_id — NOT NULL
- feeling_id — bigint — 외래 키 → feeling.feeling_id — NOT NULL
alcohol_recom_image
- recom_weather_id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- alcohol_recom_id — bigint — 외래 키 → alcohol_recom.alcohol_recom_id — NOT NULL
- recom_image_id — bigint — 외래 키 → recom_image.recom_image_id — NOT NULL
alcohol_recom_weather
- recom_weather_id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- alcohol_recom_id — bigint — 외래 키 → alcohol_recom.alcohol_recom_id — NOT NULL
- weather_id (weather_id2) — bigint — 외래 키 → weather.weather_id — NOT NULL
feeling
- feeling_id — bigint — 기본 키 — NOT NULL
- name — varchar(15)
- created_at — datetime(6)
- updated_at — datetime(6)
food_category
- food_category_id — bigint — 기본 키 — NOT NULL
- name — varchar(10)
- created_at — datetime(6)
- updated_at — datetime(6)
food_product_category
- product_category_id — bigint — 기본 키 — NOT NULL
- product_id — bigint — 외래 키 → product.product_id — NOT NULL
- food_category_id — bigint — 외래 키 → food_category.food_category_id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
food_recipe_category
- recipe_category_id — bigint — 기본 키 — NOT NULL
- recipe_id — bigint — 외래 키 → recipe.recipe_id — NOT NULL
- food_category_id — bigint — 외래 키 → food_category.food_category_id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
like
- like_id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → mebmer.member_id — NOT NULL
- recommend_id — bigint — 외래 키 → recipe.recipe_id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
mebmer (member)
- member_id — bigint — 기본 키 — NOT NULL
- name — varchar(10)
- nickname — varchar(15)
- gender — varchar(20)
- phone — varchar(15)
- email — varchar(50)
- profile — text
- social_type — varchar(10)
- status — varchar(15)
- inactive_date — datetime(6)
- created_at — datetime(6)
- updated_at — datetime(6)
member_agree
- member_agree_id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → mebmer.member_id — NOT NULL
- term_id — bigint — 외래 키 → term.term_id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
product
- product_id — bigint — 기본 키 — NOT NULL
- name — varchar(10)
- price — Integer
- product_image_url
- created_at — datetime(6)
- updated_at — datetime(6)
qna
- qna_id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → mebmer.member_id — NOT NULL
- title — varchar(20)
- body — text
- is_confirmed — boolean
- created_at — datetime(6)
- updated_at — datetime(6)
qna_image
- qna_image_id — bigint — 기본 키 — NOT NULL
- qna_id — bigint — 외래 키 → qna.qna_id — NOT NULL
- image_url — text
- created_at — datetime(6)
- updated_at — datetime(6)
recipe
- recipe_id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → mebmer.member_id — NOT NULL
- title — varchar(20)
- body — text
- cook_time (cook_tiem) — Integer
- calorie — float
- created_at — datetime(6)
- updated_at — datetime(6)
recipe_image
- recipe_image_id — bigint — 기본 키 — NOT NULL
- recipe_id — bigint — 외래 키 → recipe.recipe_id — NOT NULL
- image_url — text
- created_at — datetime(6)
- updated_at — datetime(6)
recom_image
- recom_image_id — bigint — 기본 키 — NOT NULL
- image_url — text
- created_at — datetime(6)
- updated_at — datetime(6)
term
- term_id — bigint — 기본 키 — NOT NULL
- title — varchar(20)
- body — text
- optional — boolean
- created_at — datetime(6)
- updated_at — datetime(6)
weather
- weather_id — bigint — 기본 키 — NOT NULL
- name — varchar(15)
- created_at — datetime(6)
- updated_at — datetime(6)