TodoApp
TodoAppERD
Tables (3)
Reply (reply)
- Reply Id (reply_id) — Long — Primary key — NOT NULL
- Conent (conent) — VARCHAR(1024)
- User Id (user_id) — Long — Foreign key → User.User Id — NOT NULL
- Schedule Id (schedule_id) — Long — Foreign key → Schedule.Schedule Id — NOT NULL
- CreatedAt (createdAt) — LocalDateTime
- ModifiedAt (modifiedAt) — LocalDateTime
Schedule (schedule)
- Schedule Id (schedule_id) — Long — Primary key — NOT NULL
- Title (title) — VARCHAR(50)
- Content (content) — VARCHAR(1024)
- IsCompleted (isCompleted) — BOOLEAN
- IsPrivate (isPrivate) — BOOLEAN
- User Id (user_id) — Long — Foreign key → User.User Id — NOT NULL
- CreatedAt (createdAt) — LocalDateTime
- ModifiedAt (modifiedAt) — LocalDateTime
User (user)
- User Id (user_id) — Long — Primary key — NOT NULL
- User Name (username) — VARCHAR(20)
- Password (password) — VARCHAR(100)
- Email (email) — VARCHAR(100)
- Admin (admin) — BOOLEAN
- AdminToken (adminToken) — VARCHAR(255)