NubeXTalk

Tables (5)

chat_content (Untitled)

  • cid (Key3) — int — Primary key — NOT NULL
  • uid (Key) — int — Foreign key → user_info.uid — NOT NULL
  • rid (Key2) — int — Foreign key → chat_room.rid — NOT NULL
  • type (Field) — int — NOT NULL
  • content (Field2) — String — NOT NULL
  • send_date (Field3) — date — NOT NULL

chat_room (Untitled3)

  • rid (Key) — int — Primary key — NOT NULL
  • chat_room_name (Field) — String
  • chat_room_image (Field2) — String
  • updated_date (Field3) — date
  • member_count (Field4) — int

chat_room_member (Untitled4)

  • rid (Key) — int — Foreign key → chat_room.rid — NOT NULL
  • uid (Key2) — int — Foreign key → user_info.uid — NOT NULL

chat_room_option (Untitled5)

  • rid (Key) — int — Foreign key → chat_room.rid — NOT NULL
  • setting_alarm (Field) — boolean
  • setting_fix_top (Field2) — boolean

user_info (Untitled2)

  • uid (Key) — int — Primary key — NOT NULL
  • name (Field) — String
  • profile_image (Field2) — String
  • status (Field3) — int
  • department (Field4) — String