schedules

테이블 (4)

comments

  • comment_id (id) — Long — 기본 키 — NOT NULL
  • schedule_id (schedule) — Long — 외래 키 → 일정.schedule_id — NOT NULL
  • comment_username (commentUserName) — String — NOT NULL
  • comment_description (commentDescription) — String — NOT NULL
  • created_at (createdAt) — datetime
  • modified_at (modifiedAt) — datetime

유저(Schedule, Mangaer) (User)

  • user_id (id) — Long — 기본 키 — NOT NULL
  • user_name (userName) — String
  • user_email (userEmail) — String
  • created_at (createdAt) — datetime
  • modified_atm (modifiedAt) — datetime

일정 (schedule)

  • schedule_id (id) — Long — 기본 키 — NOT NULL
  • user_id (id2) — Long — 외래 키 → 유저(Schedule, Mangaer).user_id — NOT NULL
  • title — String — NOT NULL
  • description — String — NOT NULL
  • created_at (createdAt) — datetime
  • modified_at (modifiedAt) — datetime

일정 담당 매니저 (scheduleManager)

  • schduleManager_id (scheduleManagerId) — Long — 기본 키 — NOT NULL
  • schedule_id (id) — Long — 외래 키 → 일정.schedule_id — NOT NULL
  • user_id (id2) — Long — 외래 키 → 유저(Schedule, Mangaer).user_id — NOT NULL