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