Galileo unique constraints reference guide

Who is this article for?
Users Galileo users who want to learn about the Unique Constraints in Galileo schemas
Permissions are required.

This article provides a comprehensive reference of unique constraints for views in the DWANALYTICS and DWREPORTING schemas, helping you understand the key structures that ensure data integrity in Galileo.

1. Understanding the disclaimer

The unique constraints analysis presented in this article is based on sample data profiles. Your uniqueness percentages may differ depending on your specific dataset configuration and the data contained within your Galileo instance.

2. Reviewing DWANALYTICS schema constraints

View Name	Unique Constraint	Type
asset	`id`	Single Field
attachment	`id`	Single Field
audit	`id`	Single Field
audit_checklist	`id`	Single Field
audit_checklist_bridge	`audit_checklist_key + audit_checklist_section_key + audit_checklist_item_key + audit_checklist_item_auditor_action_key + audit_checklist_item_standard_key + linked_report_via_checklist_item`	Composite Key
audit_checklist_detail	`checklist_id + section_id + item_id + finding_id`	Composite Key
audit_checklist_item	`id`	Single Field
audit_checklist_item_auditor_action	`id`	Single Field
audit_checklist_item_standard	`id`	Single Field
audit_checklist_section	`id`	Single Field
audit_fact	`audit_key + auditor_key + auditee_key + scope_item_key + audit_location_key + audit_checklist_key + workflow_key + workflow_stage_key + task_key + report_linked_via_audit`	Composite Key
audit_fact_non_workflow	`audit_key + auditor_key + auditee_key + scope_item_key + audit_location_key + audit_checklist_key + report_linked_via_audit`	Composite Key
audit_fact_workflow	`audit_key + workflow_key + workflow_stage_key + task_key`	Composite Key
audit_location	`id`	Single Field
audit_scope_item	`id`	Single Field
audit_type	`id`	Single Field
auditee	`id`	Single Field
auditor	`id`	Single Field
change_request	`id`	Single Field
control_effectiveness	`id`	Single Field
customer	`id`	Single Field
document_fact	`document_revision_key + change_request_key + workflow_key + workflow_stage_key + task_key + attachment_key`	Composite Key
document_fact_non_workflow	`document_revision_key + change_request_key + attachment_key`	Composite Key
document_fact_workflow	`document_revision_key + workflow_key + workflow_stage_key + task_key`	Composite Key
document_revision	`id`	Single Field
document_revision_with_change_requests	`change_request_key + document_revision_key`	Composite Key
form	`id`	Single Field
lists	`id`	Single Field
normalisation	`id`	Single Field
organisational_unit	`id`	Single Field
process	`id`	Single Field
report	`id`	Single Field
report_additional_information_field	`id`	Single Field
report_category	`id`	Single Field
report_classification	`id`	Single Field
report_classification_field	`id`	Single Field
report_fact	report_key + report_field_key + report_classification_field_key + report_additional_information_field_key + workflow_key + workflow_stage_key + task_key + raised_from_audit_key + raised_from_checklist_item_key + auditor_key + auditee_key + category_key + organisational_unit_key + duplicate_of_key + linked_from_report_key + linked_from_workflow_key + linked_from_stage_key + linked_from_task_key + linked_to_key + risk_assessment_key + report_interested_party_key + report_classification_key + timeline_event_key + timeline_event_classification_key + timeline_event_control_key	Composite Key
report_fact_audit	`report_key + raised_from_audit_key + raised_from_checklist_item_key + auditor_key + auditee_key`	Composite Key
report_fact_fields	`report_key + report_field_key + report_classification_field_key + report_additional_information_field_key`	Composite Key
report_fact_historical	report_key + report_field_key + report_classification_field_key + report_additional_information_field_key + workflow_key + workflow_stage_key + task_key + raised_from_audit_key + raised_from_checklist_item_key + auditor_key + auditee_key + category_key + organisational_unit_key + duplicate_of_key + linked_from_report_key + linked_from_workflow_key + linked_from_stage_key + linked_from_task_key + linked_to_key + risk_assessment_key + report_interested_party_key + report_classification_key + timeline_event_key + timeline_event_classification_key + timeline_event_control_key	Composite Key
report_fact_historical_audit	`report_key + raised_from_audit_key + raised_from_checklist_item_key + auditor_key + auditee_key`	Composite Key
report_fact_historical_fields	`report_key + report_field_key + report_classification_field_key + report_additional_information_field_key`	Composite Key
report_fact_historical_other_reports	`report_key + category_key + organisational_unit_key + duplicate_of_key + linked_from_report_key + linked_from_workflow_key + linked_from_stage_key + linked_from_task_key + linked_to_key + report_interested_party_key + report_classification_key`	Composite Key
report_fact_historical_risk	`report_key + risk_assessment_key`	Composite Key
report_fact_historical_timeline	`report_key + timeline_event_key + timeline_event_classification_key + timeline_event_control_key`	Composite Key
report_fact_historical_workflow	`report_key + workflow_key + workflow_stage_key + task_key`	Composite Key
report_fact_other_reports	`report_key + linked_to_key + report_interested_party_key + report_classification_key + duplicate_of_key`	Composite Key
report_fact_risk	`report_key + risk_assessment_key`	Composite Key
report_fact_timeline	`report_key + timeline_event_key + timeline_event_classification_key + timeline_event_control_key`	Composite Key
report_fact_workflow	`report_key + workflow_key + workflow_stage_key + task_key`	Composite Key
report_feedback	`id`	Single Field
report_field	`id`	Single Field
report_field_obsolete	`id`	Single Field
report_form_section_field	`report_id + repeater_section_id + field_id + value_field_id + report_field_key`	Composite Key
report_interested_party	`id`	Single Field
report_section_field	`id`	Single Field
report_users	`id`	Single Field
risk_assessment	`id`	Single Field
risk_event	`id`	Single Field
risk_event_risk_assessment_approval_task	`id`	Single Field
risk_fact	`risk_project_key + hazard_key + risk_event_key + control_key + risk_project_organisational_unit_key + risk_event_risk_assessment_approval_task_key + risk_assessment_key`	Composite Key
risk_project	`id`	Single Field
risk_project_organisational_unit	`id`	Single Field
risk_project_stakeholder	`risk_project_stakeholder_key + user_key`	Composite Key
standard	`id`	Single Field
supplier	`id`	Single Field
task	`id`	Single Field
timeline_event	`id`	Single Field
timeline_event_classification	`id`	Single Field
timeline_event_control_note	`id`	Single Field
timeline_event_note	`id`	Single Field
user_group	`id`	Single Field
user_group_membership	`id`	Single Field
users	`id`	Single Field
workflow	`id`	Single Field
workflow_stage	`id`	Single Field

3. Reviewing DWREPORTING schema constraints

View Name	Unique Constraint	Type
asset_type	`id`	Single Field
asset_type_hierarchy	`id`	Single Field
audit_detail	`audit_id + finding_id + location_id + auditor_id + auditee_id + scope_item_id + is_lead_auditor`	Composite Key
audit_detail_with_summary	`audit_id + finding_id + location_id + auditor_id + auditee_id + scope_item_id + is_lead_auditor`	Composite Key
audit_open_status	`auditor_key + audit_key`	Composite Key
audit_stage	`stage_key`	Single Field
audit_summary	`audit_key + location_key`	Composite Key
audit_task	`task_key`	Single Field
audit_type_count	`id`	Single Field
audit_type_hierarchy	`id`	Single Field
audit_workflow	`task_key`	Single Field
control	`id`	Single Field
document_change_requests	`document_revision_key + change_request_key`	Composite Key
document_stage	`stage_key`	Single Field
document_summary	`id`	Single Field
document_task	`task_key`	Single Field
document_type_hierarchy	`id`	Single Field
document_workflow	`task_key`	Single Field
general_assets	`id`	Single Field
general_consequences	`id`	Single Field
general_lists	`id`	Single Field
general_org_unit_users	`user_key`	Single Field
general_org_units	`id`	Single Field
general_threats	`id`	Single Field
hazards	`id`	Single Field
organisational_unit_hierarchy	`id`	Single Field
process_hierarchy	`id`	Single Field
report_classification_detail	`id`	Single Field
report_risk_assessments	`report_key + risk_assessment_key`	Composite Key
report_stage	`stage_key`	Single Field
report_summary	`report_key`	Single Field
report_task	`report_key + workflow_key + stage_key + task_key`	Composite Key
report_workflow	`report_key + workflow_key + stage_key + task_key`	Composite Key
risk_assessment_x_perspective	`id`	Single Field
risk_assessment_y_perspective	`id`	Single Field
risk_event	`id`	Single Field
risk_event_bow_tie	`id`	Single Field
risk_event_bow_tie_new	`id`	Single Field
risk_event_controls	`id`	Single Field
risk_event_details	`risk_event_key + control_key`	Composite Key
standard_hierarchy	`id`	Single Field
timeline_event_classification	`id`	Single Field
timeline_event_control	`id`	Single Field
timeline_event_detail	`id`	Single Field
user_group_membership	`id`	Single Field
users	`id`	Single Field

1. Understanding the disclaimer

2. Reviewing DWANALYTICS schema constraints

3. Reviewing DWREPORTING schema constraints

More articles in this section

On this page

Looking for help?

Common queries

Send us feedback

Before you start

1. Understanding the disclaimer

2. Reviewing DWANALYTICS schema constraints

3. Reviewing DWREPORTING schema constraints

More articles in this section

On this page