22/08/17

Tables (3)

chat (Untitled2)

  • chat_id (Key) — INT — Primary key — NOT NULL
  • user_id (Key3) — INT — Foreign key → user.user_id — NOT NULL

message (Untitled3)

  • m_id (Key) — INT — Primary key — NOT NULL
  • createdAt (Field2) — DATETIME
  • chat_id (Key2) — INT — Foreign key → chat.chat_id — NOT NULL
  • content (Field) — VARCHAR(500)
  • user_id (Key3) — INT — Foreign key → user.user_id — NOT NULL

user (Untitled)

  • user_id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)
  • mobile (Field3) — VARCHAR(50)
  • nickName (Field2) — VARCHAR(50)
  • password (Field4) — VARCHAR(50)
  • birth (Field5) — VARCHAR(50)
  • email (Field6) — VARCHAR(100)