4leaf-2thErd
Tables (3)
friends
- Key — INT — Primary key — NOT NULL
- who (Field) — INT
- whom (Field2) — INT
messages (Untitled2)
- id (Key) — INT — Primary key — NOT NULL
- who (Field) — INT
- whom (Field2) — INT
- content (Field3) — VACHAR(200)
- isRead (Field4) — TINYNT(1)
- createdAt (Field5) — DATE
user (Untitled)
- Key — INT — Primary key — NOT NULL
- email (Field) — VACHAR(200)
- secretCode (Field2) — VACHAR(100)
- nickName (Field3) — VACHAR(30)
- avatar (Field4) — VACHAR(500)
- statusMsg (Field5) — VACHAR(100)
- createdAt (Field6) — DATE
- updatedAt (Field7) — DATE