EmoLetter

Tables (3)

Untitled (User)

  • Key (userId) — varchar(50) — Primary key — NOT NULL
  • Field (password) — varchar(50) — NOT NULL
  • Field (createAt) — datetime — NOT NULL
  • Field (nickname) — varchar(30) — NOT NULL
  • Field (email) — varchar(50) — NOT NULL
  • Field — NOT NULL
  • Field2

Untitled (Diary)

  • Key (diaryId) — int — Primary key — NOT NULL
  • Field (content) — text
  • Field (createAt) — datetime — NOT NULL
  • Key (userId) — varchar(50) — Foreign key → Untitled.Key — NOT NULL
  • Field (emoji_code) — varchar(30) — NOT NULL

Untitled (Letter)

  • Key (letterId) — int — Primary key — NOT NULL
  • Field (content) — text
  • Field (deliverDate) — datetime
  • Field (isOpened) — boolean
  • Field (createAt) — datetime
  • Key (userId) — varchar(50) — Foreign key → Untitled.Key — NOT NULL
  • Field (note_code) — varchar(30) — NOT NULL