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

Todo (할일 목록)

  • Field

User (사용자)

  • Key (user_id) — varchar — Primary key — NOT NULL
  • email — varchar
  • password — varchar
  • kakaoId (kakao_id) — varchar