seed planner
Tables (8)
SubSchedule (하위일정)
- id — varchar — Primary key — NOT NULL
- name — varchar
- startedAt (started_at) — time
- endedAt (ended_at) — time
- place — varchar
- memo — varchar
- imagePath (image_path) — varchar
- lat — double
- lng — double
- address — varcher
- scheduleId (Key) — Foreign key → Schedule.scheduleId — NOT NULL
BaseEntity (공통 필드)
- id — varchar — Primary key — NOT NULL
- createdAt (created_at) — dateTime
- modifiedAt (modified_at) — dateTime
- isDeleted (is_deleted) — boolean
Category (카테고리)
- Key (category_id) — varchar — Primary key — NOT NULL
- name — varchar
- color — varchar
Log (로그)
- timestamp — datetime
- url — varchar
- Field
Participants (함께하는 사람)
- Key (participants_id) — varchar — Primary key — NOT NULL
- name — varchar
- imagePath (image_path) — varchar
- Key (user_id) — varchar — Foreign key → User.Key — NOT NULL
Schedule (일정)
- scheduleId (Key) — Primary key — NOT NULL
- name — varchar
- startedAt (started_at) — time
- endedAt (ended_at) — time
- place — varchar
- memo — varchar
- imagePath (image_path) — varchar
- lat — double
- lng — double
- address — varcher
- Key (user_id) — varchar — Foreign key → User.Key — NOT NULL
User (사용자)
- Key (user_id) — varchar — Primary key — NOT NULL
- email — varchar
- password — varchar
- kakaoId (kakao_id) — varchar