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