Push Broadcasting
Tables (6)
api_log
- pk — uuid — Primary key — NOT NULL
- http method (http_method) — varchar(6)
- uri — varchar(64)
- request_time — timestamp
- ip — varchar(64)
- request_bodyr (request_body) — text
chat
- pk — uuid — Primary key — NOT NULL
- chat_room_fk — uuid — Foreign key → chat_room.pk — NOT NULL
- user_fk — uuid — Foreign key → users.pk — NOT NULL
- chat_data — text
- create_date — timestamp
chat_room
- pk — uuid — Primary key — NOT NULL
- create_date — timestamp
device
- pk — uuid — Primary key — NOT NULL
- user_fk — uuid — Foreign key → users.pk — NOT NULL
- device_id — uuid
user_chat_room
- user_fk — uuid — Foreign key → users.pk — NOT NULL
- chat_room_fk — uuid — Foreign key → chat_room.pk — NOT NULL
users
- pk — uuid — Primary key — NOT NULL
- name — varchar(64)