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)