.
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