Schedules
Tables (3)
Comment (comments)
- Comment_id (comment_id) — bigint(10) — Primary key — NOT NULL
- Contents (contents) — VARCHAR(100)
- Comments User (comments_user) — VARCHAR(20)
- Create Date (created_at) — TIMESTAMP
- Update Date (updated_at) — TIMESTAMP
- Schedule_id (schedule_id) — bigint(10) — Foreign key → Schedules.Schedule_id — NOT NULL
Schedules (schedules)
- Schedule_id (schedule_id) — bigint(10) — Primary key — NOT NULL
- User Name (username) — VARCHAR(20)
- Title (title) — VARCHAR(50)
- Contents (contents) — VARCHAR(100)
- Create Date (created_at) — TIMESTAMP
- Update Date (updated_at) — TIMESTAMP
- User_id (user_id) — bigint(10) — Foreign key → Users.User_id — NOT NULL
Users (users)
- User_id (user_id) — bigint(10) — Primary key — NOT NULL
- User Name (username) — VARCHAR(20)
- Email (email) — VARCHAR(100)
- Create Date (created_at) — TIMESTAMP
- Update Date (updated_at) — TIMESTAMP
- Schedule_id (schedule_id) — bigint(10) — Foreign key → Schedules.Schedule_id — NOT NULL