스프링세션_데일리플랜__과제

테이블 (5)

Category (category)

  • id (PK) — Long — 기본 키 — NOT NULL
  • member_id (member) — Long — 외래 키 → Member.id — NOT NULL
  • category_code (categoryCode) — enum
  • count_by_ToDo (countByToDo) — bigint
  • success_todo_count (successToDoCount) — bigint

DailyPlan (dailyplan)

  • dailyplan_id (PK) — Long — 기본 키 — NOT NULL
  • member_id (member) — Long — 외래 키 → Member.id — NOT NULL
  • year_month (month) — varchar
  • date — varchar

Follow (follows)

  • id (PK) — Long — 기본 키 — NOT NULL
  • member_id (member) — Long — 외래 키 → Member.id — NOT NULL
  • follow_member_id (followMember) — Long — 외래 키 → Member.id — NOT NULL

Member (member)

  • id (Key) — Long — 기본 키 — NOT NULL
  • email — varchar
  • profile_url (profileUrl) — varchar
  • plan_success_count (planSuccessCount) — bigint

ToDo (toDo)

  • to_do_list_id (id) — Long — 기본 키 — NOT NULL
  • category_id (category) — Long — 외래 키 → Category.id — NOT NULL
  • dailyplan_id (dailyPlan) — Long — 외래 키 → DailyPlan.dailyplan_id — NOT NULL
  • is_complete (isComplete) — boolean
  • title — varchar
  • alarm_start_time (alarmStartTime) — varchar
  • alarm_end_time (alarmEndTime) — varchar