.

Tables (6)

citizen_profiles

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • preferred_district_id — INTEGER
  • age_group — VARCHAR(20)
  • move_in_status — VARCHAR(20) — NOT NULL
  • notification_enabled — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

district_alert_subscriptions

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • district_id — INTEGER — NOT NULL
  • alert_on_grades — VARCHAR(50) — NOT NULL
  • channel — VARCHAR(20) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

district_bookmarks

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • district_id — INTEGER — NOT NULL
  • memo — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL

official_profiles

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • organization — VARCHAR(100) — NOT NULL
  • department — VARCHAR(100) — NOT NULL
  • job_title — VARCHAR(100)
  • employee_number — VARCHAR(50)
  • district_id — INTEGER
  • approval_status — VARCHAR(20) — NOT NULL
  • approved_by — INTEGER — Foreign key → users.id
  • approved_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

password_resets

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • token — VARCHAR(200) — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • used_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

users

  • id — SERIAL — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • hashed_password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(30)
  • role — VARCHAR(20) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • is_verified — BOOLEAN — NOT NULL
  • last_login_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL