Chat

Tables (4)

Chat Room (chatroom_table)

  • chatroom_id (Key) — Bigint — Primary key — NOT NULL
  • channel_type (Channel Type) — Varchar(255)
  • name (ChatroomName) — Varchar(255)
  • status (Status) — Varchar(255)
  • created_at (Created Time) — timestamp
  • end_at (End_time) — timestamp

Chatroom Join (chatroom_join_tale)

  • customer_id (Key) — Bigint — Foreign key → customer.customer_id — NOT NULL
  • chatroom_id (Key2) — Bigint — Foreign key → Chat Room.chatroom_id — NOT NULL

Message(partition) (message_table)

  • message_id (Key) — Bigint — Primary key — NOT NULL
  • customer_id (Key2) — Bigint — Foreign key → Chatroom Join.customer_id — NOT NULL
  • chatroom_id (Key22) — Bigint — Foreign key → Chatroom Join.chatroom_id — NOT NULL
  • message_from (From) — Varchar(255)
  • message_to (To) — Varchar(255)
  • content (Content) — Text
  • created_at (Created Time) — timestamp
  • chatroom_created_at (Created Chatroom Time) — timestamp

customer (CopyOfmessage_table)

  • customer_id (Key) — Bigint — Primary key — NOT NULL