TodoDevelopProject
Tables (3)
Comment (comment)
- Schedule ID (schedule_id) — BIGINT — Foreign key → Schedule.ID — NOT NULL
- User ID (user_id) — BIGINT — Foreign key → Schedule.User ID — NOT NULL
- Contents (contents) — VARCHAR
- Created Date (created_at) — DATETIME
- Updated Date (updated_at) — DATETIME
Schedule (schedule)
- ID (id) — BIGINT — Primary key — NOT NULL
- User ID (user_id) — BIGINT — Foreign key → User.ID — NOT NULL
- Title (title) — VARCHAR
- Contents (contents) — VARCHAR
- Created Date (created_at) — DATETIME
- Updated Date (updated_at) — DATETIME
User (user)
- ID (id) — BIGINT — Primary key — NOT NULL
- Name (name) — VARCHAR
- Email (email) — VARCHAR
- Password (password) — VARCHAR
- Created Date (created_at) — DATETIME
- Updated Date (updated_at) — DATETIME