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