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