sns
Tables (8)
chat_message (채팅메시지)
- id (PK) — Primary key — NOT NULL
- room_id (index1) — Foreign key → chat_room.id — NOT NULL
- participant_id (index2) — Foreign key → chat_participant.id — NOT NULL
chat_participant (단톡 참석자)
- id (PK) — Primary key — NOT NULL
- user_id (index1) — Foreign key → users.id — NOT NULL
- room_id (index2) — Foreign key → chat_room.id — NOT NULL
chat_room (단톡방)
- id (PK) — Primary key — NOT NULL
- user_id (index) — Foreign key → users.id — NOT NULL
comment (댓글)
- id (PK) — Primary key — NOT NULL
- post_id (index1) — Foreign key → posts.id — NOT NULL
- user_id (index2) — Foreign key → users.id — NOT NULL
end_room (종료된 방)
- id (PK) — Primary key — NOT NULL
- room_id (index) — Foreign key → chat_room.id — NOT NULL
posts (게시글)
- id (PK) — Primary key — NOT NULL
- user_id (index) — Foreign key → users.id — NOT NULL
users (회원)
- id (PK) — Primary key — NOT NULL