음주 미식회 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)