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