patient_portal_accounts


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
patient_portal_provider_links.account_id patient_portal_provider_links_account_id_fkey C
legacy_patient_id text 2147483647 null
schema_migrations.id Implied Constraint R
legacy_user_id text 2147483647 null
schema_migrations.id Implied Constraint R
login_identifier_hash text 2147483647 √ null
status text 2147483647 'active'::text
last_login_at timestamptz 35,6 √ null
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
patient_portal_accounts_pkey Primary key Asc id
patient_portal_accounts_legacy_patient_id_key Must be unique Asc legacy_patient_id
patient_portal_accounts_legacy_user_idx Performance Asc legacy_user_id
patient_portal_accounts_login_hash_unique Must be unique Asc login_identifier_hash

Check Constraints

Constraint Name Constraint
patient_portal_accounts_status_check ((status = ANY (ARRAY['active'::text, 'disabled'::text])))

Relationships

Close relationships within degrees of separation