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