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