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