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