16 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| record_creators_name_entity_id_fkey |
|
|
Restrict delete | ||
| record_creators_record_id_fkey |
|
|
Cascade on delete | ||
| curators_name_entity_id_fkey |
|
|
Restrict delete | ||
| record_files_record_id_fkey |
|
|
Cascade on delete | ||
| record_files_file_extension_id_fkey |
|
|
Restrict delete | ||
| record_subjects_subject_scheme_id_fkey |
|
|
Restrict delete | ||
| record_subjects_record_id_fkey |
|
|
Cascade on delete | ||
| name_entitie_identifiers_name_entity_id_fkey |
|
|
Restrict delete | ||
| name_entity_identifiers_external_identifier_scheme_id_fkey |
|
|
Restrict delete | ||
| record_fundings_funder_id_fkey |
|
|
Restrict delete | ||
| record_fundings_record_id_fkey |
|
|
Cascade on delete | ||
| record_contributors_record_id_fkey |
|
|
Cascade on delete | ||
| record_contributors_name_entity_id_fkey |
|
|
Restrict delete | ||
| record_trails_record_id_fkey |
|
|
Cascade on delete | ||
| record_licenses_license_id_fkey |
|
|
Restrict delete | ||
| record_licenses_record_id_fkey |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| record_files | record_files_general_type_check | ((general_type = ANY (ARRAY['image'::text, 'document'::text, 'tabularData'::text, 'dataCube'::text, 'dataCollection'::text, 'metadata'::text]))) |
| name_entities | name_entities_name_type_check | ((name_type = ANY (ARRAY['Personal'::text, 'Organizational'::text]))) |
| records | records_doi_status_check | ((doi_status = ANY (ARRAY['Draft'::text, 'Findable'::text]))) |
| records | records_general_type_check | ((general_type = ANY (ARRAY['Collection'::text, 'Dataset'::text, 'Event'::text, 'Image'::text, 'InteractiveResource'::text, 'Model'::text, 'PhysicalObject'::text, 'Service'::text, 'Software'::text, 'text'::text, 'Workflow'::text, 'Other'::text]))) |
| records | records_process_status_check | ((process_status = ANY (ARRAY['Accepted'::text, 'Submitted'::text, 'InReview'::text, 'Published'::text, 'Rejected'::text, 'Archived'::text]))) |
| records | records_submission_type_check | ((submission_type = ANY (ARRAY['Regular'::text, 'BundleDelivery'::text]))) |
| curators | curators_role_check | ((role = ANY (ARRAY['Curate'::text, 'Maintain'::text, 'Admin'::text]))) |
| record_contributors | record_contributors_contributor_type_check | ((contributor_type = ANY (ARRAY['ContactPerson'::text, 'DataCollector'::text, 'DataCurator'::text, 'DataManager'::text, 'Distributor'::text, 'Editor'::text, 'HostingInstitution'::text, 'Producer'::text, 'ProjectLeader'::text, 'ProjectManager'::text, 'ProjectMember'::text, 'RegistrationAgency'::text, 'RegistrationAuthority'::text, 'RelatedPerson'::text, 'Researcher'::text, 'ResearchGroup'::text, 'RightsHolder'::text, 'Sponsor'::text, 'Supervisor'::text, 'WorkPackageLeader'::text, 'Other'::text]))) |