scheduler
Tables (11)
Group (그룹)
- GroupId (group_id) — Long — Primary key — NOT NULL
- CreatedUserId (created_user_id) — Long — Foreign key → User.UserId — NOT NULL
- GroupName (group_name) — String
- CreatedAt (created_at) — DATETIME
- ModifiedAt (modified_at) — DATETIME
GroupSchedule (그룹 일정)
- ScheduleId (schedule_id) — Long — Primary key — NOT NULL
- GroupId (group_id) — Long — Foreign key → Group.GroupId — NOT NULL
- CreatedUserId (created_user_id) — Long — Foreign key → User.UserId — NOT NULL
- Schedule Name (schedule_name) — String
- RepeatType (repeat_type) — Enum
- RepeatInterval (repeat_interval) — Integer
- StartDate (start_date) — DATE
- EndDate (end_date) — DATE
- StartTime (start_time) — TIME
- EndTime (end_time) — TIME
- CreatedAt (created_at) — DATETIME
- ModifiedAt (modified_at) — DATETIME
GroupScheduleMonthlyRule (월 반복(그룹))
- ScheduleId (schedule_id) — Long — Foreign key → GroupSchedule.ScheduleId — NOT NULL
- DaysOfMonth (days_of_month) — TINYINT
- CreateAt (creat_at) — DATETIME
- ModifiedAt (modified_at) — DATETIME
GroupScheduleWeeklyRule (요일 반복(그룹))
- DayOfWeek (dayOfWeek) — Enum — Primary key — NOT NULL
- ScheduleId (schedule_id) — Long — Foreign key → GroupSchedule.ScheduleId — NOT NULL
- CreateAt (creat_at) — DATETIME
- ModifiedAt (modified_at) — DATETIME
GroupScheduleYearlyRule (연 반복(그룹))
- ScheduleId (schedule_id) — Long — Foreign key → GroupSchedule.ScheduleId — NOT NULL
- Month (month) — TINYINT
- DayOfMonth (day_of_month) — TINYINT
- CreateAt (create_at) — DATETIME
- ModifiedAt (modified_at) — DATETIME
GroupUser (사용자-그룹 중간 테이블)
- GroupUserId (group_user_id) — Long — Primary key — NOT NULL
- UserId (user_id2) — Long — Foreign key → User.UserId — NOT NULL
- GroupId (group_id) — Long — Foreign key → Group.GroupId — NOT NULL
- Role (role) — String
- CreatedAt (created_at) — DATETIME
- ModifiedAt (modified_at) — DATETIME
PersonalSchedule (개인 일정)
- ScheduleId (schedule_id) — Long — Primary key — NOT NULL
- CreatedUserId (created_user_id) — Long — Foreign key → User.UserId — NOT NULL
- Schedule Name (schedule_name) — String
- RepeatType (repeat_type) — Enum
- RepeatInterval (repeat_interval) — Integer
- StartDate (start_date) — DATE
- EndDate (end_date) — DATE
- StartTime (start_time) — TIME
- EndTime (end_time) — TIME
- CreatedAt (created_at) — DATETIME
- ModifiedAt (modified_at) — DATETIME
PersonalScheduleMonthlyRule (월 반복(개인))
- ScheduleId (schedule_id) — Long — Foreign key → PersonalSchedule.ScheduleId — NOT NULL
- DaysOfMonth (days_of_month) — TINYINT
- CreateAt (creat_at) — DATETIME
- ModifiedAt (modified_at) — DATETIME
PersonalScheduleWeeklyRule (요일 반복(개인))
- DaysOfWeek (days_of_week) — Enum — Primary key — NOT NULL
- ScheduleId (schedule_id) — Long — Foreign key → PersonalSchedule.ScheduleId — NOT NULL
- CreateAt (creat_at) — DATETIME
- ModifiedAt (modified_at) — DATETIME
PersonalScheduleYearlyRule (연 반복(개인))
- ScheduleId (schedule_id) — Long — Foreign key → PersonalSchedule.ScheduleId — NOT NULL
- Month (month) — TINYINT
- DayOfMonth (day_of_month) — TINYINT
- CreateAt (create_at) — DATETIME
- ModifiedAt (modified_at) — DATETIME
User (사용자)
- UserId (user_id) — Long — Primary key — NOT NULL
- AnonymousId (anonymous_id) — String
- Email (email) — String
- Password (password) — String
- Nickname (nickname) — String
- UserRole (user_role) — Enum
- UserType (user_type) — String
- LastAccessedAt (last_accessed_at) — DATETIME
- CreatedAt (created_at) — DATETIME
- ModifiedAt (modifiedAt) — DATETIME