아이투두

테이블 (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