dynamic_framework_contract

0 rows


Description

stores the scope of the commissioned rehabilitative services contracts

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
dynamic_framework_contract_sub_contractor.dynamic_framework_contract_id fk_contract_idR
intervention.dynamic_framework_contract_id fk__intervention__dynamic_framework_contract_idR

service-owned unique identifier
prime_provider_id varchar 30 null
service_provider.id fk__dynamic_framework_contract__service_provider_idR

awarded for a (prime) provider
start_date date 13 null

when delivery can start
end_date date 13 null

when delivery must end
nps_region_id bpchar 1 √ null
nps_region.id fk__dynamic_framework_contract__nps_region_idR

awarded to deliver in either an NPS or PCC region
pcc_region_id text 2147483647 √ null
pcc_region.id fk__dynamic_framework_contract__pcc_region_idR

awarded to deliver in either an NPS or PCC region
allows_female bool 1 true

whether female service users can attend
allows_male bool 1 true

whether can male service users can attend
minimum_age int4 10 18

the minimum age of attending service users
maximum_age int4 10 √ null

the maximum age of attending service users
contract_reference varchar 30 null
contract_type_id uuid 2147483647 null
contract_type.id fk__contract_type__contract_type_idR
referral_start_date date 13 '2021-01-01'::date
referral_end_at timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
dynamic_framework_contract_pkey Primary key Asc id
dynamic_framework_contract_contract_reference_key Must be unique Asc contract_reference
idx_prime_provider_id Performance Asc prime_provider_id

Relationships

Close relationships within degrees of separation