service_provider

0 rows


Description

service provider details

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 30 null
dynamic_framework_contract.prime_provider_id fk__dynamic_framework_contract__service_provider_idR
dynamic_framework_contract_sub_contractor.subcontractor_provider_id fk_subcontractor_idR
referral_summary.service_provider_id Implied ConstraintR

service provider unique identifier, used in hmpps-auth as group code

name text 2147483647 null

service provider name

Indexes

Constraint Name Type Sort Column(s)
service_provider_pkey Primary key Asc id

Relationships