최종프로젝트 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