meeting

Tables (8)

ChatRoom (Untitled7)

  • id (chatRoom_id) — long,auto — Primary key — NOT NULL
  • 방장 (master_user_id) — long
  • 참여자 (slave_user_id) — long

Comment (Untitled3)

  • id (comment_id) — long,auto — Primary key — NOT NULL
  • 내용 (content) — varchar
  • 글쓴이 (author) — varchar
  • 생성일자 (created_at) — date
  • 수정일자 (updated_at) — date
  • post_id (Post.id) — long,FK — Foreign key → Post.id — NOT NULL

MatchingRequest (Untitled6)

  • id (matching_id) — long.auto — Primary key — NOT NULL
  • sender_id (User.id) — long — Foreign key → User.id — NOT NULL
  • receiver_id (user.id) — long — Foreign key → User.id — NOT NULL
  • 매칭여부 (isMatched) — boolean

Message (Untitled8)

  • id (message_id) — long,auto — Primary key — NOT NULL
  • 보내는사람 (sender_id) — varchar
  • 받는사람 (receiver_id) — varchar
  • 채팅방 (chatRoom_id) — long — Foreign key → ChatRoom.id — NOT NULL
  • 메시지 전송 시간 (timeStamp) — date
  • sender_id (User.id) — long — Foreign key → User.id — NOT NULL
  • receiver_id (user.id) — long — Foreign key → User.id — NOT NULL

Post (Untitled2)

  • id (post_id) — long,auto — Primary key — NOT NULL
  • 제목 (title) — varchar
  • 내용 (content) — varchar
  • 생성일자 (created_at) — date
  • 수정일자 (updated_at) — date
  • user_id (User.id) — long, FK — Foreign key → User.id — NOT NULL

SubComment (Untitled4)

  • id (subComment_id) — long,auto — Primary key — NOT NULL
  • comment_id (Comment.id) — long — Foreign key → Comment.id — NOT NULL
  • 내용 (content) — varchar
  • 글쓴이 (author) — varchar
  • 생성일자 (created_at) — date
  • 수정일자 (updated_at) — date

User (Untitled)

  • id (user_id) — long, auto — Primary key — NOT NULL
  • 아이디 (email) — varchar
  • 비밀번호 (password) — varchar
  • 나이 (age) — long
  • 성별 (gender) — enum
  • 사는지역 (address) — enum
  • 하트 (heart) — long
  • 카톡아이디 (kakao_id) — varchar
  • 프로필 이미지 (image_url) — varchar

like (Like)

  • id (like_id) — long,auto — Primary key — NOT NULL
  • 생성일자 (timestamp) — date
  • post_id (Post.id) — long,FK — Foreign key → Post.id — NOT NULL
  • user_id (User.id) — long,FK — Foreign key → User.id — NOT NULL