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