Chat
Tables (4)
Untitled (chat_room)
- Key (id) — bigint — Primary key — NOT NULL
- Field (room_type) — varchar
- Field (chat_status) — varchar
- Field (creator_type) — varchar
- Field (creator_id) — varchar
- Field (last_message_id) — bigint
- Field (created_at) — datetime
- Field (updated_at) — datetime
Untitled (chat_message)
- Key (id) — bigint — Primary key — NOT NULL
- Key (room_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (message_type) — varchar
- Field (message) — text
- Field (writer_type) — varchar
- Field (writer_id) — varchar
- Field (delete_yn) — char
- Field (created_at) — datetime
Untitled (chat_member)
- Key (from_id) — varchar — Primary key — NOT NULL
- Key (to_id) — varchar — Primary key — NOT NULL
- Key (room_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (from_type) — varchar
- Field (to_type) — varchar
- Field (show_yn) — char
- Field (no_read_count) — int
Untitled (chat_online)
- Key (room_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Field (updated_at) — datetime