최종프로젝트 ERD

테이블 (24)

board

  • board_id — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • title — varchar(200) — NOT NULL
  • content — text — NOT NULL
  • view_count — int
  • status — varchar(20)
  • created_date — datetime
  • updated_date — datetime
  • recipe_id — bigint — 외래 키 → recipe.recipe_id — NOT NULL
  • img_id — int — 외래 키 → img.img_id
  • board_type — varchar(20) — NOT NULL

bookmark

  • bookmark_id — bigint — 기본 키 — NOT NULL
  • recipe_id — bigint — 외래 키 → recipe.recipe_id — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • created_date — datetime

category

  • category_id — int — 기본 키 — NOT NULL
  • category_name — varchar(50) — NOT NULL
  • sub_category_name — varchar(50) — NOT NULL
  • sort_order — int

chatbot

  • id — int — 기본 키 — NOT NULL
  • parent_id — int — 외래 키 → chatbot.id
  • question — varchar(255) — NOT NULL
  • answer — text
  • depth — int — NOT NULL
  • sort_order — int
  • use_yn — char(1)

comment

  • comment_id — bigint — 기본 키 — NOT NULL
  • recipe_id — bigint — 외래 키 → recipe.recipe_id
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • content — text — NOT NULL
  • rating — float
  • status — varchar(20)
  • created_date — datetime
  • board_id — bigint — 외래 키 → board.board_id

content_view

  • content_type — varchar(20) — 기본 키 — NOT NULL
  • content_id — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 기본 키 — NOT NULL
  • viewed_date — datetime — NOT NULL

cook_order

  • cook_order_id — bigint — 기본 키 — NOT NULL
  • cook_order — bigint
  • cook_image — varchar(255)
  • description — varchar(255)
  • recipe_id — bigint — 외래 키 → recipe.recipe_id — NOT NULL

food

  • food_id — bigint — 기본 키 — NOT NULL
  • food_name — varchar(255) — NOT NULL
  • category_id — int — 외래 키 → category.category_id — NOT NULL
  • thumbnail — varchar(255) — 대표 이미지

fridge_item

  • fridge_id — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • ingredient_name — varchar(100) — NOT NULL
  • quantity — varchar(50)
  • expire_date — date
  • created_date — datetime
  • freezer — tinyint(1)

guide

  • guide_id — bigint — 기본 키 — NOT NULL
  • title — varchar(255) — NOT NULL
  • sub_title — varchar(255)
  • image — varchar(255) — NOT NULL
  • tab — varchar(20) — NOT NULL — storage:보관법, trim:손질법, tip:요리꿀팁, etc:기타정보

guide_step

  • step_id — bigint — 기본 키 — NOT NULL
  • guide_id — bigint — 외래 키 → guide.guide_id — NOT NULL
  • step_num — int — NOT NULL
  • step_image — varchar(255)
  • step_content — longtext — NOT NULL

img

  • img_id — int — 기본 키 — NOT NULL
  • image_list — varchar(500)
  • inquiry_id — bigint — 외래 키 → inquiry.inquiry_id
  • notice_id — bigint — 외래 키 → notice.notice_id
  • review_id — bigint — 외래 키 → review.review_id

ingredient

  • ingredient_id — bigint — 기본 키 — NOT NULL
  • ingredient_name — varchar(255)
  • quantity — bigint
  • unit — varchar(255)
  • type — varchar(255)
  • recipe_id — bigint — 외래 키 → recipe.recipe_id — NOT NULL

inquiry

  • inquiry_id — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id
  • title — varchar(200) — NOT NULL
  • content — text — NOT NULL
  • status — varchar(20)
  • created_date — datetime
  • admin_id — bigint — 외래 키 → member.member_id
  • answer_content — varchar(100)
  • answered_date — datetime
  • guest_name — varchar(50)
  • guest_email — varchar(100)
  • guest_password — varchar(255)
  • inquiry_code — varchar(50)
  • type — varchar(50) — NOT NULL

member

  • member_id — bigint — 기본 키 — NOT NULL
  • login_id — varchar(50)
  • password — varchar(250)
  • nickname — varchar(50) — NOT NULL
  • email — varchar(100) — NOT NULL
  • role — varchar(20)
  • status — varchar(20)
  • report_count — int
  • created_date — datetime
  • profile_img — varchar(100)
  • login_type — varchar(20)
  • provider — varchar(20)
  • provider_id — varchar(100)
  • name — varchar(50) — NOT NULL
  • member_intro — varchar(500)

notice

  • notice_id — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • title — varchar(200) — NOT NULL
  • content — text — NOT NULL
  • view_count — int
  • created_date — datetime

notice_view

  • notice_id — bigint — 외래 키 → notice.notice_id — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • viewed_date — datetime

password_reset_token

  • token_id — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • token — varchar(255)
  • expire_date — datetime — NOT NULL
  • created_date — datetime — NOT NULL
  • used — char(1) — NOT NULL

recipe

  • recipe_id — bigint — 기본 키 — NOT NULL
  • title — varchar(255) — NOT NULL
  • thumbnail — varchar(255)
  • cooking_time — varchar(30)
  • difficulty — varchar(255)
  • view_count — int
  • like_count — int
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • status — varchar(20)
  • created_date — datetime
  • updated_date — datetime
  • food_id — bigint — 외래 키 → food.food_id — NOT NULL
  • recommend — tinyint(1)

report

  • report_id — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • target_type — varchar(20) — NOT NULL
  • board_id — bigint — 외래 키 → board.board_id
  • reason — varchar(100) — NOT NULL
  • detail — text
  • status — varchar(20)
  • admin_id — bigint — 외래 키 → member.member_id
  • admin_memo — text
  • created_date — datetime
  • processed_date — datetime
  • comment_id — bigint — 외래 키 → comment.comment_id
  • recipe_id — bigint — 외래 키 → recipe.recipe_id
  • report_count — int
  • reported_count — int
  • report_title — varchar(50)
  • review_id — bigint — 외래 키 → review.review_id

review

  • review_id — bigint — 기본 키 — NOT NULL
  • recipe_id — bigint — 외래 키 → recipe.recipe_id — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • title — varchar(100) — NOT NULL
  • content — text — NOT NULL
  • thumbnail — varchar(255)
  • rating — decimal(3,1) — NOT NULL
  • view_count — int — NOT NULL
  • status — varchar(20) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

search_log

  • search_id — bigint — 기본 키 — NOT NULL
  • keyword — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL

seasons

  • season_id — int — 기본 키 — NOT NULL
  • season_name — varchar(50) — NOT NULL — 봄, 여름, 가을, 겨울
  • banner_title — varchar(255) — NOT NULL — 배너 메인 타이틀
  • banner_desc — varchar(255) — NOT NULL — 배너 서브 설명
  • food_id — bigint — 외래 키 → food.food_id — NOT NULL — 음식 ID (food 테이블 참조)
  • sub_desc — varchar(255) — NOT NULL — 음식 한 줄 설명
  • custom_image — varchar(255) — 관련 음식 이미지

web_push_subscription

  • endpoint — varchar(500) — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • p256dh — varchar(200) — NOT NULL
  • auth — varchar(200) — NOT NULL
  • created_at — timestamp