joyfulmind

Tables (3)

chatlist (Untitled3)

  • Key — Primary key — NOT NULL
  • Field

diary (Untitled)

  • id — INT — Primary key
  • userId — INT — Primary key
  • title — VARCHAR(100)
  • content — TEXT
  • date — DATE — NOT NULL
  • emotion — VARCHAR(100) — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

user (Untitled2)

  • id — INT — Primary key — NOT NULL
  • email — VARCHAR(100)
  • password — VARCHAR(200)
  • nickname — VARCHAR(200)
  • age — INT
  • gender — TINYINT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP