20210811 게시판 (초기 DB 설계)

테이블 (19)

blacklists

  • BlackUserId — varchar(100) — 외래 키 → users.user_id — NOT NULL
  • UserId — varchar(100) — 외래 키 → users.user_id — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

channelchats

  • chat_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • chat_content — text — NOT NULL
  • channel_id — int(11) — 외래 키 → channels.channel_id
  • user_id — varchar(100) — 외래 키 → users.user_id

channelmembers

  • ChannelId — int(11) — 외래 키 → channels.channel_id — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • ChannelMemberId — varchar(100) — 외래 키 → users.user_id

channels

  • channel_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • channel_name — varchar(30) — NOT NULL

commentlikes

  • comment_liked — int(11) — 외래 키 → comments.comment_id — NOT NULL
  • comment_likers — varchar(100) — 외래 키 → users.user_id — NOT NULL

commentreports

  • report_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • report_content — text — NOT NULL
  • ReportCategoryId — int(11) — 외래 키 → reportcategories.report_category_id — NOT NULL
  • ReporterId — varchar(255) — 외래 키 → users.user_id — NOT NULL
  • ReportedCommentId — int(11) — NOT NULL
  • ReportedPostId — int(11) — 외래 키 → comments.comment_id

comments

  • comment_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • comment — text — NOT NULL
  • comment_depth — tinyint(4) — NOT NULL
  • comment_order — int(11) — NOT NULL
  • post_id — int(11) — 외래 키 → posts.post_id
  • UserId — varchar(255) — 외래 키 → users.user_id — NOT NULL

friends

  • UserId — varchar(255) — 외래 키 → users.user_id — NOT NULL
  • FriendId — varchar(255) — 외래 키 → users.user_id — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

groupcategories

  • group_category_id — tinyint(4) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • group_category_name — varchar(255) — NOT NULL

groups

  • group_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • group_name — varchar(255) — NOT NULL
  • group_category_id — tinyint(4) — 외래 키 → groupcategories.group_category_id

groupusers

  • group_member_id — varchar(255) — 외래 키 → users.user_id — NOT NULL
  • group_id — int(11) — 외래 키 → groups.group_id — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • group_role — tinyint(4) — NOT NULL

images

  • image_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • image — varchar(255) — NOT NULL
  • post_id — int(11) — 외래 키 → posts.post_id

majors

  • major_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • major_name — varchar(255) — NOT NULL

postcategories

  • post_category_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • post_category_name — varchar(255) — NOT NULL

postlikes

  • post_likers — varchar(100) — 외래 키 → users.user_id — NOT NULL
  • post_liked — int(11) — 외래 키 → posts.post_id — NOT NULL

postreports

  • report_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • report_content — text — NOT NULL
  • ReportCategoryId — int(11) — 외래 키 → reportcategories.report_category_id — NOT NULL
  • ReporterId — varchar(255) — 외래 키 → users.user_id — NOT NULL
  • ReportedPostId — int(11) — 외래 키 → posts.post_id — NOT NULL

posts

  • post_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • post_title — varchar(255) — NOT NULL
  • post_content — text — NOT NULL
  • user_id — varchar(100) — 외래 키 → users.user_id
  • PostCategoryId — int(11) — 외래 키 → postcategories.post_category_id — NOT NULL

reportcategories

  • report_category_id — int(11) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • report_category_name — varchar(255) — NOT NULL

users

  • user_id — varchar(100) — 기본 키 — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • user_email — varchar(50) — NOT NULL
  • user_nickname — varchar(20)
  • user_image — text
  • user_sex — tinyint(4)
  • UserMajor — int(11) — 외래 키 → majors.major_id