sns + chat
Tables (13)
chat_message (채팅메시지)
- id — Primary key — NOT NULL
- content (내용)
- chat_rood_id (채팅방ID) — Foreign key → chat_room.Key — NOT NULL
- member_id (멤버ID) — Foreign key → member.id — NOT NULL
chat_participant (채팅참여자)
- Key (id) — Primary key — NOT NULL
- member_id (멤버ID) — Foreign key → member.id — NOT NULL
- chat_room_id (채팅방ID) — Foreign key → chat_room.Key — NOT NULL
chat_room (채팅방)
- Key (id) — Primary key — NOT NULL
- isGroupChat (오픈채팅여부) — NOT NULL
- Field
comment (댓글)
- id — Primary key — NOT NULL
- post (게시물)
- comment_parent (부모코멘트)
- comment_childs (자식코멘트)
- updated_at (content) — NOT NULL
- member (댓글작성자) — Foreign key → member.id — NOT NULL
comment_vote (댓글투표(좋아요/싫어요))
- id — Foreign key → vote_base.id — NOT NULL
- comment (투표한 댓글) — Foreign key → comment.id — NOT NULL
member (회원)
- id — Primary key — NOT NULL
- name (이름)
- email (이메일)
- password (패스워드) — NOT NULL
- created_at (만들어진 때)
- updated_at (업데이트된 때)
message_read_status (메시지읽음)
- id — Primary key — NOT NULL
- isRead (읽음여부) — NOT NULL
- chat_message_id (메시지ID) — Foreign key → chat_message.id — NOT NULL
- chat_room_id (채팅방ID) — Foreign key → chat_room.Key — NOT NULL
- member_id (멤버ID(메시지보낸사람)) — Foreign key → member.id — NOT NULL
post (게시물)
- id — Primary key — NOT NULL
- title (제목) — NOT NULL
- content (내용) — NOT NULL
- like_count (좋아요) — NOT NULL
- dislike_count (싫어요) — NOT NULL
- edited (수정여부) — NOT NULL
- comment)count (댓글 개수)
- post_media_list (포스트미디어리스트)
- created_at (만들어진때) — NOT NULL
- updated_at (업데이트된때)
- id (member) — Foreign key → member.id — NOT NULL
post_vote (게시글투표(좋아요/싫어요))
- id — Foreign key → vote_base.id — NOT NULL
- post (투표게시글) — Foreign key → post.id — NOT NULL
vote_base (투표베이스)
- id — Primary key — NOT NULL
- member (투표자) — NOT NULL
- vote_type (투표타입(좋아요/싫어요)) — NOT NULL
- created_at (만들어진때) — NOT NULL
- updated_at (업데이트된 때)