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