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