PlanIt
Tables (6)
Curriculum (커리큘럼)
- id (Key) — Long — Primary key — NOT NULL
- hostId (호스트ID) — Long — Foreign key → User.id — NOT NULL
- name (커리큘럼이름) — String
- startDate (시작일) — DateTime
- endDate (종료일) — DateTime
- createdDate (생성일) — DateTime
- modifiedDate (수정일) — DateTime
Guest (게스트)
- Key — Long — Primary key — NOT NULL
- curriculumId (커리큘럼ID) — Long — Foreign key → Curriculum.id — NOT NULL
- hostId (유저ID) — Long — Foreign key → Curriculum.hostId — NOT NULL
- invite (초대상태) — boolean
- Field
Schedule (일정)
- id (Key) — Long — Primary key — NOT NULL
- curriculumId (커리큘럼ID) — Long — Foreign key → Curriculum.id — NOT NULL
- content (내용) — String
- day (일자) — Date
- createdDate (생성일) — DateTime
- modifiedDate (수정일) — DateTime
SpinGame (원판돌리기)
- id (Key) — Long — Primary key — NOT NULL
- content (내용) — String
User (유저)
- id (Key) — Long — Primary key — NOT NULL
- username (ID) — String
- password (PW) — String
- nickname (닉네임) — String
- email (Email) — String
- createdDate (생성일) — DateTime
- modifiedDate (수정일) — DateTime
comment (댓글)
- id (Key) — Long — Primary key — NOT NULL
- scheduleId (일정ID) — Long — Foreign key → Schedule.id — NOT NULL
- authorId (작성자ID) — Long — Foreign key → User.id — NOT NULL
- content (내용) — String
- createdDate (생성일) — DateTime
- modifiedDate (수정일) — DateTime