dynamic_framework_contract_sub_contractor

0 rows


Description

sub-contractors for each commissioned rehabilitative services contract

Columns

Column Type Size Nulls Auto Default Children Parents Comments
dynamic_framework_contract_id uuid 2147483647 null
dynamic_framework_contract.id fk_contract_idR
subcontractor_provider_id varchar 30 null
service_provider.id fk_subcontractor_idR

Indexes

Constraint Name Type Sort Column(s)
pk_subcontractor Primary key Asc/Asc subcontractor_provider_id + dynamic_framework_contract_id
idx_sub_contractor_prime_provider_id Performance Asc subcontractor_provider_id

Relationships

Close relationships within degrees of separation