스프링세션_데일리플랜__과제
테이블 (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