DocuChat

Tables (3)

chat (Untitled2)

  • chat_id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigInt — Foreign key → user.user_id — NOT NULL
  • room_name (Field) — string
  • document (Field2) — object

log (Untitled3)

  • log_id (Key) — bigInt — Primary key — NOT NULL
  • chat_id (Key2) — bigint — Foreign key → chat.chat_id — NOT NULL
  • contents (Field) — String
  • chat_time (Field2) — Datetime
  • sent_by (Field3) — String

user (Untitled)

  • user_id (Key) — bigInt — Primary key — NOT NULL
  • nickname (Field) — varchar(5)
  • email (Field2) — varchar(50)