chat
Tables (5)
chat_message (Untitled4)
- id (chat_message_pk) — Primary key — NOT NULL
- id (user_participant_pk) — Foreign key → chat_participant.id — NOT NULL
- id (chat_room_pk) — Foreign key → chat_room.id — NOT NULL
chat_participant (Untitled3)
- id (user_participant_pk) — Primary key — NOT NULL
- id (user_pk) — Foreign key → user.id — NOT NULL
- id (chat_room_pk) — Foreign key → chat_room.id — NOT NULL
- status (참가상태)
chat_room (Untitled2)
- id (chat_room_pk) — Primary key — NOT NULL
- 이름 (name)
- id (user_pk) — Foreign key → user.id — NOT NULL
read_status (Untitled5)
- id (read_status_pk) — Primary key — NOT NULL
- id (user_participant_pk) — Foreign key → chat_participant.id — NOT NULL
- id (chat_message_pk) — Foreign key → chat_message.id — NOT NULL
- status (상태)
user (Untitled)
- id (user_pk) — Primary key — NOT NULL
- username (유저아이디)
- password (패스워드)