catalog_item_provider_mappings


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
catalog_item_id uuid 2147483647 null
catalog_items.id catalog_item_provider_mappings_catalog_item_id_fkey C
provider_id text 2147483647 null
schema_migrations.id Implied Constraint R
practice_location_id text 2147483647 √ null
schema_migrations.id Implied Constraint R
is_active bool 1 true
legacy_provider_id text 2147483647 √ null
schema_migrations.id Implied Constraint R
legacy_payload jsonb 2147483647 '{}'::jsonb
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
catalog_item_provider_mappings_pkey Primary key Asc id
catalog_item_provider_mappings_global_unique Must be unique Asc/Asc catalog_item_id + provider_id
catalog_item_provider_mappings_location_unique Must be unique Asc/Asc/Asc catalog_item_id + provider_id + practice_location_id
catalog_item_provider_mappings_provider_idx Performance Asc/Asc provider_id + is_active

Relationships

Close relationships within degrees of separation