Yapp-web-2
테이블 (9)
member
- member_id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- status — varchar(8)
- job_category — varchar(20)
- nickname — varchar(255)
- profile_image — varchar(255)
- working_years — int — NOT NULL
대댓글 (reply_comment)
- reply_id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- status — varchar(8)
- contents — varchar(255)
- comment_id — bigint — 외래 키 → 댓글.comment_id — NOT NULL
댓글 (comment)
- comment_id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- status — varchar(8)
- contents — varchar(255)
- topic_id — bigint — 외래 키 → 투표 게시글.topic_id — NOT NULL
댓글 좋아요 (comment_likes)
- comment_likes_id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → member.member_id — NOT NULL
- comment_id — bigint — 외래 키 → 댓글.comment_id — NOT NULL
투표 게시글 (topic)
- topic_id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- status — varchar(8)
- contents — varchar(1000)
- topic_category — varchar(255)
- title — varchar(255)
- vote_type — varchar(30)
- member_id — bigint — 외래 키 → member.member_id — NOT NULL
투표 선택지 (vote_option)
- vote_option_id — bigint — 기본 키 — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- status — varchar(8)
- code_block — varchar(255)
- text — varchar(255)
- image — varchar(255)
- topic_id — bigint — 외래 키 → 투표 게시글.topic_id — NOT NULL
투표 정보 (vote_option_member)
- vote_option_member_id — bigint — 기본 키 — NOT NULL
- vote_option_id — bigint — 외래 키 → 투표 선택지.vote_option_id — NOT NULL
- member_id (member_id2) — bigint — 외래 키 → member.member_id — NOT NULL
투표 좋아요 (vote_likes)
- vote_likes_id — bigint — 기본 키 — NOT NULL
- topic_id — bigint — 외래 키 → 투표 게시글.topic_id — NOT NULL
- member_id — bigint — 외래 키 → member.member_id — NOT NULL
해시태그 (hash_tag)
- hash_tag_id — bigint — 기본 키 — NOT NULL
- hash_tag — varchar(255)
- topic_id — bigint — 외래 키 → 투표 게시글.topic_id — NOT NULL