Codin
Tables (13)
bookmark (booknark)
- Bookmark_id — Bigint — Primary key — NOT NULL
- post_id — Bigint — Foreign key → post.post_id — NOT NULL
- user_id — Bigint — Foreign key → user.user_id — NOT NULL
- created_at — Timestamp
chatroom (채팅방)
- Chatroom_id — Bigint — Primary key — NOT NULL
- roomname — Bigint
- created_at — Timestamp
comment (댓글)
- comment_id — Bigint — Primary key — NOT NULL
- post_id — Bigint — Foreign key → post.post_id — NOT NULL
- user_id — Bigint — Foreign key → user.user_id — NOT NULL
- content — Varchar(255)
- status — Enum('Active','Disabled','Suspended')
- created_at — TimeStamp
comment_like (댓글 좋아요)
- comment_like_id — Bigint — Primary key — NOT NULL
- comment_id — Bigint — Foreign key → comment.comment_id — NOT NULL
- user_id — Bigint — Foreign key → user.user_id — NOT NULL
- created_at — Timestamp
comment_reply
- comment_reply_id — Bigint — Primary key — NOT NULL
- comment_id — Bigint — Foreign key → comment.comment_id — NOT NULL
- user_id — Bigint — Foreign key → user.user_id — NOT NULL
- content — VarChar(255)
- created_at — Timestamp
comment_reply_like
- comment_reply_like_id — Bigint — Primary key — NOT NULL
- comment_reply_id — Bigint — Foreign key → comment_reply.comment_reply_id — NOT NULL
- user_id — Bigint — Foreign key → user.user_id — NOT NULL
- created_at — Timestamp
message (채팅내용)
- message_id — Bigint — Primary key — NOT NULL
- user_id — Bigint — Foreign key → user_chatroom.user_id — NOT NULL
- chatroom_id — Bigint — Foreign key → user_chatroom.chatroom_id — NOT NULL
- content — Varchar(255)
- send_at — Timestamp
- is_read — Boolean
notice (공지사항)
- notice_id — Bigint — Primary key — NOT NULL
- user_id — Bigint — Foreign key → user.user_id — NOT NULL
post (게시물)
- post_id — Bigint — Primary key — NOT NULL
- user_id — Bigint — Foreign key → user.user_id — NOT NULL
- category — Enum('구해요','소통해요','비교과',,,,,,)
- title — Varchar(255)
- content — Varchar(255)
- is_annonymous — Boolean
- status — Enum('Active','Disabled','Suspended')
- created_at — Timestamp
- updated_at — TimeStamp
post_like (게시물 좋아요)
- post_like_id — Bigint — Primary key — NOT NULL
- post_id — Bigint — Foreign key → post.post_id — NOT NULL
- user_id — Bigint — Foreign key → user.user_id — NOT NULL
- created_at — timestamp
user (유저)
- user_id — Bigint — Primary key — NOT NULL
- email — Varchar(255)
- password — Varchar(255)
- name — Varchar(10)
- nickname — Varchar(50)
- profile_image — Varchar(255)
- verified — Boolean
- department — Varchar(50)
- student_number — Bigint
- superuser — Enum('User','Admin','Manager') Default 'User')
- status — Enum('Active','Disabled','Suspended')
- created_at — TimeStamp
- updated_at — TimeStamp
user_chatroom (유저-채팅방)
- user_id — Bigint — Foreign key → user.user_id — NOT NULL
- chatroom_id — Bigint — Foreign key → chatroom.Chatroom_id — NOT NULL
view (조회수)
- view_id — Bigint — Primary key — NOT NULL
- post_id — Bigint — Foreign key → post.post_id — NOT NULL
- user_id — Bigint — Foreign key → user.user_id — NOT NULL
- view_at — Timestamp