v1

Tables (14)

blocks

  • id — VARCHAR
  • blocker_id — VARCHAR — Foreign key → users.id — NOT NULL
  • blocked_id — VARCHAR — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

categories

  • id — VARCHAR
  • user_id — VARCHAR — Foreign key → users.id — NOT NULL
  • name — VARCHAR — NOT NULL
  • color — VARCHAR
  • icon — VARCHAR
  • created_at — TIMESTAMP — NOT NULL

certifications

  • id — VARCHAR
  • todo_id — VARCHAR — Foreign key → todos.id — NOT NULL
  • group_id — VARCHAR — Foreign key → groups.id
  • photo_ref — VARCHAR
  • photo_hash — VARCHAR — NOT NULL
  • ai_score — INT — NOT NULL
  • result — VARCHAR — NOT NULL
  • submitted_at — TIMESTAMP — NOT NULL
  • photo_expire_at — TIMESTAMP

device_tokens

  • id — VARCHAR
  • user_id — VARCHAR — Foreign key → users.id — NOT NULL
  • device_token — VARCHAR — NOT NULL
  • platform — VARCHAR — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

group_members

  • id — VARCHAR
  • group_id — VARCHAR — Foreign key → groups.id — NOT NULL
  • user_id — VARCHAR — Foreign key → users.id — NOT NULL
  • role — VARCHAR — NOT NULL
  • joined_at — TIMESTAMP — NOT NULL

group_todos

  • id — VARCHAR
  • group_id — VARCHAR — Foreign key → groups.id — NOT NULL
  • created_by — VARCHAR — Foreign key → users.id — NOT NULL
  • title — VARCHAR — NOT NULL
  • cert_condition — TEXT — NOT NULL
  • due_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

groups

  • id — VARCHAR
  • name — VARCHAR — NOT NULL
  • description — TEXT
  • goal — TEXT
  • is_public — BOOLEAN — NOT NULL
  • invite_code — VARCHAR — NOT NULL
  • owner_id — VARCHAR — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

notices

  • id — VARCHAR
  • author_id — VARCHAR — Foreign key → users.id — NOT NULL
  • title — VARCHAR — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

notifications

  • id — VARCHAR
  • user_id — VARCHAR — Foreign key → users.id — NOT NULL
  • type — VARCHAR — NOT NULL
  • message — VARCHAR — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

reactions

  • id — VARCHAR
  • certification_id — VARCHAR — Foreign key → certifications.id — NOT NULL
  • user_id — VARCHAR — Foreign key → users.id — NOT NULL
  • type — VARCHAR — NOT NULL
  • emoji — VARCHAR
  • created_at — TIMESTAMP — NOT NULL

repeats

  • id — VARCHAR
  • user_id — VARCHAR — Foreign key → users.id — NOT NULL
  • title — VARCHAR — NOT NULL
  • repeat_type — VARCHAR — NOT NULL
  • weekdays — VARCHAR
  • end_date — DATE
  • created_at — TIMESTAMP — NOT NULL

reports

  • id — VARCHAR
  • certification_id — VARCHAR — Foreign key → certifications.id — NOT NULL
  • reporter_id — VARCHAR — Foreign key → users.id — NOT NULL
  • reason — VARCHAR — NOT NULL
  • status — VARCHAR — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

todos

  • id — VARCHAR
  • user_id — VARCHAR — Foreign key → users.id — NOT NULL
  • group_todo_id — VARCHAR — Foreign key → group_todos.id
  • repeat_id — VARCHAR — Foreign key → repeats.id
  • category_id — VARCHAR — Foreign key → categories.id
  • title — VARCHAR — NOT NULL
  • description — TEXT
  • due_at — TIMESTAMP
  • importance — INT — NOT NULL
  • urgency_base — INT — NOT NULL
  • urgency_effective — INT — NOT NULL
  • requires_cert — BOOLEAN — NOT NULL
  • cert_condition — TEXT
  • status — VARCHAR — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

users

  • id — VARCHAR
  • social_provider — VARCHAR — NOT NULL
  • social_id — VARCHAR — NOT NULL
  • nickname — VARCHAR — NOT NULL
  • profile_image_url — VARCHAR
  • role — VARCHAR — NOT NULL
  • status — VARCHAR — NOT NULL
  • suspended_until — TIMESTAMP
  • day_cutoff_time — VARCHAR — NOT NULL
  • created_at — TIMESTAMP — NOT NULL