TODO List Service

Tables (6)

DailyTodo (Untitled3)

  • pk (id) — Primary key — NOT NULL
  • fk (repo) — Foreign key → TodoRepository.pk — NOT NULL
  • 작성날짜 (date) — date — 연월일 ex) 2023.08.11

MonthlyTodo (Untitled4)

  • Key — Primary key — NOT NULL
  • 작성날짜 (date) — date

TodoRepository (Untitled6)

  • pk (id) — Primary key — NOT NULL
  • fk (user) — bigint — Foreign key → User.pk — NOT NULL
  • 제목 (title)
  • 설명 (description)
  • 유저 id (user_id)

TodoTask (Untitled2)

  • pk (id) — bigint — Primary key — NOT NULL
  • fk (daily_todo) — Foreign key → DailyTodo.pk — NOT NULL
  • 생성날짜 (created_at)
  • 수정날짜 (updated_at)
  • 내용 (content)
  • 완료여부 (is_completed) — bool

User (Untitled)

  • pk (id) — bigint — Primary key — NOT NULL
  • 유저 이름 (fullname)
  • 닉네임 (username)
  • 유저 Email (email)
  • 비밀번호 (password)

YearlyTodo (Untitled5)

  • pk (id) — Primary key — NOT NULL
  • 작성날짜 (date) — date