safe-return-app
Tables (12)
account_deletion_jobs
- id — UUID — Primary key — NOT NULL
- auth_user_id — UUID — NOT NULL
- status — VARCHAR(20) — NOT NULL
- prepared_at — TIMESTAMPTZ — NOT NULL
- completed_at — TIMESTAMPTZ
- last_error — TEXT
checkin_events
- id — UUID — Primary key — NOT NULL
- schedule_id — UUID — Foreign key → schedules.id — NOT NULL
- actor_user_id — UUID — Foreign key → users.id
- event_type — TEXT — NOT NULL
- metadata — JSONB — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
checkin_reason_presets
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- body — TEXT — NOT NULL
- sort_order — SMALLINT — NOT NULL
- use_count — INT — NOT NULL
- last_used_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
group_entitlements
- id — UUID — Primary key — NOT NULL
- group_id — UUID — Foreign key → groups.id — NOT NULL
- plan_tier — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- started_at — TIMESTAMPTZ — NOT NULL
- expires_at — TIMESTAMPTZ
- provider — TEXT
- frozen_at — TIMESTAMPTZ
- frozen_reason — TEXT
- prefreeze_notified_at — TIMESTAMPTZ
group_members
- id — UUID — Primary key — NOT NULL
- group_id — UUID — Foreign key → groups.id — NOT NULL
- user_id — UUID — Foreign key → users.id
- role — VARCHAR(10) — NOT NULL
- type — VARCHAR(10) — NOT NULL
- return_hour — SMALLINT
- return_minute — SMALLINT
- removed_at — TIMESTAMPTZ
- removed_reason — TEXT
- removed_by — UUID — Foreign key → users.id
- removed_display_name — TEXT
- removed_by_label — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
groups
- id — UUID — Primary key — NOT NULL
- name — TEXT — NOT NULL
- invite_code — VARCHAR(10) — NOT NULL
- admin_id — UUID — Foreign key → users.id
- plan_tier — VARCHAR(20) — NOT NULL
- low_battery_alert_enabled — BOOLEAN — NOT NULL
- billing_admin_id — UUID — Foreign key → users.id
- deleted_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
location_access_logs
- id — UUID — Primary key — NOT NULL
- guardian_id — UUID — Foreign key → users.id — NOT NULL
- protegee_id — UUID — Foreign key → users.id — NOT NULL
- schedule_id — UUID — Foreign key → schedules.id
- reason — TEXT — NOT NULL
- accessed_at — TIMESTAMPTZ — NOT NULL
notification_logs
- id — UUID — Primary key — NOT NULL
- schedule_id — UUID — Foreign key → schedules.id
- target_user_id — UUID — Foreign key → users.id — NOT NULL
- channel — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- provider_response — TEXT
- expo_message_id — TEXT
- ticket_status — TEXT
- ticket_error_type — TEXT
- receipt_status — TEXT
- receipt_error_type — TEXT
- attempt_count — SMALLINT — NOT NULL
- max_attempts — SMALLINT — NOT NULL
- next_attempt_at — TIMESTAMPTZ
- failure_class — TEXT
- idempotency_key — TEXT
- correlation_id — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
private_user_locations
- user_id — UUID — Foreign key → users.id — NOT NULL
- lat — DOUBLE PRECISION
- lng — DOUBLE PRECISION
- updated_at — TIMESTAMPTZ
schedules
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- group_id — UUID — Foreign key → groups.id — NOT NULL
- target_time — TIMESTAMPTZ — NOT NULL
- status — VARCHAR(20) — NOT NULL
- estimated_return_time — TIMESTAMPTZ
- escalation_state — VARCHAR(20) — NOT NULL
- escalation_started_at — TIMESTAMPTZ
- last_response_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
user_consents
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- consent_type — TEXT — NOT NULL
- version — TEXT — NOT NULL
- granted_at — TIMESTAMPTZ — NOT NULL
- revoked_at — TIMESTAMPTZ
- metadata — JSONB — NOT NULL
users
- id — UUID — Primary key — NOT NULL
- email — TEXT — NOT NULL
- name — TEXT — NOT NULL
- phone_number — TEXT
- fcm_token — TEXT
- location_sharing_consent — BOOLEAN — NOT NULL
- location_sharing_consented_at — TIMESTAMPTZ
- location_sharing_revoked_at — TIMESTAMPTZ
- last_login_method — TEXT
- last_login_at — TIMESTAMPTZ
- service_country — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL