chatting
Tables (3)
Chat (Untitled)
- pk (chat_id) — BIGINT — Primary key — NOT NULL
- pk (id2) — BIGINT — Foreign key → Participant.pk — NOT NULL
- 메시지 (message) — VARCHAR(500)
- 채팅 유형 (chatType) — ENUM
Participant (CopyOfUntitled)
- pk (id) — BIGINT — Primary key — NOT NULL
- 메시지 (message) — VARCHAR(500)
- 채팅 유형 (chatType) — ENUM
Room (CopyOfCopyOfUntitled)
- pk (room_id) — BIGINT — Primary key — NOT NULL
- 방이름 (roomName) — VARCHAR(500)
- 방 내용 (roomContent) — varchar(25)
- 채팅목록 (chat)