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)