아이투두
테이블 (9)
Category (category)
- category_id (PK) — Long — 기본 키 — NOT NULL
- member_id (member) — Long — 외래 키 → Member.id — NOT NULL
- success_todo_count (successToDoCount) — bigint
- success_challenge_count (successChallengeCount) — bigint
- category_code (categoryCode) — enum
- count_by_todo (countByToDo) — bigint
- count_by_challenge (countByChallenge) — bigint
Challenge (challenge)
- challenge_id (PK) — Long — 기본 키 — NOT NULL
- member_id (member) — Long — 외래 키 → Member.id — NOT NULL
- verification_member_id (vertificationMemberId) — Long — 외래 키 → Member.id — NOT NULL
- category_id (category) — Long — 외래 키 → Category.category_id — NOT NULL
- deadline — timestamp
- challenge_status (challengeStatus) — enum
- min_count_per_interval (minCountPerInterval) — bigint
- validation_interval (validationInterval) — enum
- title — varchar
- Field
DailyPlan (dailyplan)
- dailyplan_id (PK) — Long — 기본 키 — NOT NULL
- member_id (member) — Long — 외래 키 → Member.id — NOT NULL
- 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
- challenge_success_count (challengeSuccessCount) — bigint
Proof (proofs)
- proof_id (id) — Long — 기본 키 — NOT NULL
- challeng_id (challenge) — Long — 외래 키 → Challenge.challenge_id — NOT NULL
- writing — varchar
- upload_data (uploadDate) — varchar
ProofImage (proofImage)
- proof_image_id (id) — Long — 기본 키 — NOT NULL
- proof_id (proof) — Long — 외래 키 → Proof.proof_id — NOT NULL
- origin_name (originName) — varchar
- stored_name (storedName) — varchar
- access_url (accessUrl) — varchar
ToDo (toDo)
- to_do_list_id (id) — Long — 기본 키 — NOT NULL
- dailyplan_id (dailyPlan) — Long — 외래 키 → DailyPlan.dailyplan_id — NOT NULL
- category_id (category) — Long — 외래 키 → Category.category_id — NOT NULL
- alarm_end_time (alarmEndTime) — varchar
- todo_status (isComplete) — enum
- title — varchar
- alarm_start_time (alarmStartTime) — varchar
Validation (validation)
- validation_id (id) — Long — 기본 키 — NOT NULL
- validator_member_id (validatorMemberId) — Long — 외래 키 → Member.id — NOT NULL
- creator_member_id (creatorMemberId) — Long — 외래 키 → Member.id — NOT NULL
- challenge_id (challenge) — Long — 외래 키 → Challenge.challenge_id — NOT NULL
- validator_name (validatorName) — String