CHAT
Tables (3)
CHAT_MESSAGE
- Key (MESSAGE_ID) — INTEGER — Primary key — NOT NULL
- CHAT_ROOM_ID — INTEGER — Foreign key → CHAT_ROOM.CHAT_ROOM_ID — NOT NULL
- MESSAGE — STRING
- MESSAGE_TIME — DATETIME
- USER_ID — INTEGER
CHAT_ROOM
- CHAT_ROOM_ID — INTEGER — Primary key — NOT NULL
- HOST_ID — INTEGER
- MBTI — STRING
- MBTI_CHECK — BOOLEAN
- MAX_NUM — INTEGER
- CREATION_TIME — DATETIME
- NUM — INTEGER
Untitled (CHAT_ACCESS)
- Key (ACCESS_ID) — INTEGER — Primary key — NOT NULL
- CHAT_ROOM_ID — INTEGER — Foreign key → CHAT_ROOM.CHAT_ROOM_ID — NOT NULL
- Field (USER_ID) — INTEGER
- Field (ACCESS_TIME) — DATETIME