patient_portal_provider_links


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
account_id uuid 2147483647 null
patient_portal_accounts.id patient_portal_provider_links_account_id_fkey C
legacy_provider_id text 2147483647 null
schema_migrations.id Implied Constraint R
provider_name text 2147483647 null
provider_url_suffix text 2147483647 √ null
is_active bool 1 true
last_verified_at timestamptz 35,6 now()
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
patient_portal_provider_links_pkey Primary key Asc id
patient_portal_provider_links_account_active_idx Performance Asc/Asc account_id + is_active
patient_portal_provider_links_account_id_legacy_provider_id_key Must be unique Asc/Asc account_id + legacy_provider_id
patient_portal_provider_links_provider_idx Performance Asc/Asc legacy_provider_id + is_active

Relationships

Close relationships within degrees of separation