nkakao

Tables (4)

chatroom (Untitled2)

  • roomid (Key) — string — Primary key — NOT NULL
  • users (Field) — string array
  • last_chatid (Field3) — string
  • info (Field4) — json

message (Untitled)

  • messageid (Key) — string — Primary key — NOT NULL
  • roomid (Field) — string
  • userid (Field2) — string
  • date (Field3) — date
  • msg (Field4) — string

token (Untitled4)

  • userid (Key) — string — Primary key — NOT NULL
  • token (Key2) — string — Primary key — NOT NULL
  • create_date (Field2) — date
  • expire_date (Field) — date
  • Field3

user (Untitled3)

  • userid (Key) — string — Primary key — NOT NULL
  • id (Field) — string
  • password (Field2) — encrypt string
  • name (Field3) — string
  • Field4