# Compliance Checkpoint schema ERD

Table and field reference for the Fivetran Compliance Checkpoint connector.

## Table & Field Reference

### audit_all_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| audit_id | Unknown | PK, FK |
| all_status | Unknown |  |

### audit_auditor

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| audit_id | Unknown | PK, FK |
| auditor_id | Unknown | FK |
| user_id | Unknown | FK |

### audit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| entity_id | Unknown | FK |
| organisation_id | Unknown | FK |
| questionnaire_id | Unknown | FK |
| status_id | Unknown | FK |
| account_id | Unknown |  |
| asset_name | Json |  |
| can_be_copied | Unknown |  |
| can_be_deleted | Unknown |  |
| can_be_edited | Unknown |  |
| can_view_non_conformances | Unknown |  |
| can_view_reports | Unknown |  |
| can_view_summary | Unknown |  |
| close_date | Unknown |  |
| close_meeting | Unknown |  |
| comment | Unknown |  |
| enabled_external_link | Unknown |  |
| enabled_internal_link | Unknown |  |
| end_date | Unknown |  |
| entity_name | Unknown |  |
| has_secure_external_links | Unknown |  |
| has_secure_internal_links | Unknown |  |
| is_announced | Unknown |  |
| is_checklist_generated | Unknown |  |
| is_entity_confirmed | Unknown |  |
| is_linked_to_activity | Unknown |  |
| is_locked | Unknown |  |
| is_paid | Unknown |  |
| locked_by | Unknown |  |
| locked_by_user_id | Unknown |  |
| note | Unknown |  |
| open_meeting | Unknown |  |
| paid_by | Unknown |  |
| purchase_item_id | Unknown |  |
| purpose_id | Unknown |  |
| read_only | Unknown |  |
| repeated_by_audit_number | Unknown |  |
| repeating_audit_number | Unknown |  |
| result | Unknown |  |
| result_final | Unknown |  |
| review_date | Unknown |  |
| score | Unknown |  |
| score_details | Unknown |  |
| score_details_threshold | Unknown |  |
| show_application_menu | Unknown |  |
| show_only_organisations | Unknown |  |
| start_date | Unknown |  |
| total_answered | Unknown |  |
| total_attachments | Unknown |  |
| total_non_conformances | Unknown |  |
| total_outstanding_non_conformances | Unknown |  |
| total_questions | Unknown |  |

### audit_checklist_response

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| answer_id | Unknown | PK, FK |
| audit_id | Unknown | PK, FK |
| section_name | Unknown | PK, FK |
| auto_non_conformance_id | Unknown |  |
| auto_raise_non_conformance | Unknown |  |
| changes_made | Unknown |  |
| comment | Unknown |  |
| comment_id | Unknown |  |
| duplicate_section | Unknown |  |
| is_attachment_compulsory | Unknown |  |
| is_compulsory | Unknown |  |
| is_multi_required_select_any | Unknown |  |
| is_multiline | Unknown |  |
| is_not_applicable | Unknown |  |
| is_scored | Unknown |  |
| is_selected | Unknown |  |
| is_subj | Unknown |  |
| is_trigger | Unknown |  |
| object_type | Unknown |  |
| observation | Unknown |  |
| observation_id | Unknown |  |
| original_response_id | Unknown |  |
| question_item_id | Unknown |  |
| regex | Unknown |  |
| response_text | Unknown |  |
| score | Unknown |  |
| section_to_duplicate | Unknown |  |
| sequence | Unknown |  |
| sub_header_sequence | Unknown |  |

### audit_checklist_question

| Column | Type | Keys |
| --- | --- | --- |
| answer_id | Unknown | PK |
| audit_id | Unknown | PK, FK |
| section_name | Unknown | PK, FK |
| allow_data_copy | Unknown |  |
| attachment_count | Unknown |  |
| completed_percentage | Unknown |  |
| current_position | Unknown |  |
| is_answered | Unknown |  |
| is_attachment_compulsory | Unknown |  |
| is_compulsory | Unknown |  |
| is_critical | Unknown |  |
| is_first_question | Unknown |  |
| is_flagged | Unknown |  |
| is_last_question | Unknown |  |
| is_not_applicable | Unknown |  |
| non_scored_responses_selected | Unknown |  |
| original_section_name | Unknown |  |
| question_id | Unknown |  |
| question_number | Unknown |  |
| question_text | Unknown |  |
| response_count | Unknown |  |
| restrict_editing | Unknown |  |
| risk | Unknown |  |
| scored_response_count | Unknown |  |
| section_sequence | Unknown |  |
| theme_1 | Unknown |  |
| threshold_score | Unknown |  |
| total_questions | Unknown |  |

### audit_checklist

| Column | Type | Keys |
| --- | --- | --- |
| section_name | Unknown | PK |
| audit_id | Unknown | PK, FK |
| completed_percentage | Unknown |  |
| has_flagged_questions | Unknown |  |
| is_duplicate | Unknown |  |
| non_conformance_count | Unknown |  |
| original_section_name | Unknown |  |
| section_sequence | Unknown |  |
| total_answered | Unknown |  |
| total_questions | Unknown |  |

### checklist_theme_1_summary

| Column | Type | Keys |
| --- | --- | --- |
| section_name | Unknown | PK |
| audit_id | Unknown | PK, FK |
| average_score | Unknown |  |
| completed_percentage | Unknown |  |
| has_flagged_questions | Unknown |  |
| is_duplicate | Unknown |  |
| non_conformance_count | Unknown |  |
| section_sequence | Unknown |  |
| total_answered | Unknown |  |
| total_na_questions | Unknown |  |
| total_questions | Unknown |  |
| total_score | Unknown |  |
| total_threshold_score | Unknown |  |

### non_conformance

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| answer_id | Unknown | FK |
| audit_id | Unknown | FK |
| audit_status_id | Unknown | FK |
| closed_by_auditor_id | Unknown | FK |
| entity_id | Unknown | FK |
| originator_id | Unknown | FK |
| agreed_date | Unknown |  |
| attachments_count | Unknown |  |
| can_delete | Unknown |  |
| can_edit | Unknown |  |
| closed_date | Unknown |  |
| description | Unknown |  |
| entity_name | Unknown |  |
| entity_time_zone_id | Unknown |  |
| is_closed | Unknown |  |
| is_sfi | Unknown |  |
| reference | Unknown |  |
| reported_date | Unknown |  |
| short_description | Unknown |  |
| status | Unknown |  |
| status_id | Unknown |  |
| type | Unknown |  |
| type_id | Unknown |  |

### organisation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_1 | Unknown |  |
| city | Unknown |  |
| code | Unknown |  |
| country | Unknown |  |
| email | Unknown |  |
| entity_user_group_id | Unknown |  |
| is_assigned | Unknown |  |
| is_audit_license | Unknown |  |
| is_audit_organisation | Unknown |  |
| is_entity_organisation | Unknown |  |
| manager_user_group_id | Unknown |  |
| name | Unknown |  |
| number_of_users | Unknown |  |
| other_user_group_id | Unknown |  |
| phone_number | Unknown |  |
| state | Unknown |  |

### entity_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| entity_id | Unknown | PK, FK |
| color | Unknown |  |
| id | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |

### entity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| status_id | Unknown | FK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| assigned_audit_organization_id | Unknown |  |
| business_hours_close | Unknown |  |
| business_hours_open | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| fax_number | Unknown |  |
| full_name | Unknown |  |
| fulltime_staff | Unknown |  |
| is_structure_only | Unknown |  |
| last_modified_date | Unknown |  |
| phone_number | Unknown |  |
| postcode | Unknown |  |
| reference | Unknown |  |
| region_id | Unknown |  |
| region_name | Unknown |  |
| risk_result_color | Unknown |  |
| risk_result_id | Unknown |  |
| risk_result_name | Unknown |  |
| short_name | Unknown |  |
| size | Unknown |  |
| size_name | Unknown |  |
| state | Unknown |  |
| trading_name | Unknown |  |
| travel_distance | Unknown |  |

### audit_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color | Unknown |  |
| is_assigned | Unknown |  |
| name | Unknown |  |
| phase_id | Unknown |  |
| phase_name | Unknown |  |
| sequence | Unknown |  |
| update_audit_end_date | Unknown |  |

### checklist_section_summary

| Column | Type | Keys |
| --- | --- | --- |
| section_name | Unknown | PK |
| audit_id | Unknown | PK, FK |
| average_score | Unknown |  |
| completed_percentage | Unknown |  |
| has_flagged_questions | Unknown |  |
| is_duplicate | Unknown |  |
| non_conformance_count | Unknown |  |
| section_sequence | Unknown |  |
| total_answered | Unknown |  |
| total_na_questions | Unknown |  |
| total_questions | Unknown |  |
| total_score | Unknown |  |
| total_threshold_score | Unknown |  |

### questionnaire_standard

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| questionnaire_id | Unknown | PK, FK |
| name | Unknown |  |
| reference | Unknown |  |

### questionnaire_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| questionnaire_id | Unknown | PK, FK |
| is_assigned | Unknown |  |
| name | Unknown |  |

### questionnaire_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| questionnaire_id | Unknown | PK, FK |
| override_compulsory_question_validation | Unknown |  |
| show_submit_button | Unknown |  |

### questionnaire

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assign_organisations_only | Unknown |  |
| auto_schedule | Unknown |  |
| base_questionnaire_id | Unknown |  |
| can_be_edited | Unknown |  |
| colour | Unknown |  |
| created_date | Unknown |  |
| creator_email | Unknown |  |
| creator_name | Unknown |  |
| enable_auto_numbering | Unknown |  |
| estimated_hours | Unknown |  |
| force_section_view | Unknown |  |
| industries | Json |  |
| is_active | Unknown |  |
| is_assigned | Unknown |  |
| is_free | Unknown |  |
| is_public | Unknown |  |
| name | Unknown |  |
| purchase_id | Unknown |  |
| repeat_interval | Unknown |  |
| repeat_non_conformances_only | Unknown |  |
| repeat_number | Unknown |  |
| repeat_questionnaire_id | Unknown |  |
| result_id_on_critical_fail | Unknown |  |
| scope | Unknown |  |
| show_progress_indicators | Unknown |  |
| skip_sync_audit_date_to_car_date | Unknown |  |
| system_generated | Unknown |  |
| terms | Unknown |  |

### user_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| is_assigned | Unknown |  |
| is_entity_group | Unknown |  |
| is_restricted_group | Unknown |  |
| is_system_group | Unknown |  |
| name | Unknown |  |
| template | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| auditor_id | Unknown | FK |
| organisation_id | Unknown | FK |
| account_id | Unknown |  |
| can_be_edited | Unknown |  |
| contact_id | Unknown |  |
| email | Unknown |  |
| enable_multi_factor_auth | Unknown |  |
| first_name | Unknown |  |
| full_name | Unknown |  |
| is_account_administrator | Unknown |  |
| is_active | Unknown |  |
| is_deleted | Unknown |  |
| is_locked | Unknown |  |
| is_logged_in | Unknown |  |
| is_organisation_administrator | Unknown |  |
| is_restricted | Unknown |  |
| landing_page | Unknown |  |
| last_name | Unknown |  |
| multi_factor_auth_mobile_number | Unknown |  |
| multi_factor_auth_mobile_number_pending | Unknown |  |
| multi_factor_auth_use_email | Unknown |  |
| multi_factor_auth_use_mobile | Unknown |  |
| must_change_password | Unknown |  |
| password_never_expires | Unknown |  |
| restrict_edit_reason | Unknown |  |
| time_zone_id | Unknown |  |
| use_external_login | Unknown |  |
| user_name | Unknown |  |

### auditor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organisation_id | Unknown | FK |
| user_id | Unknown | FK |
| active | Unknown |  |
| assigned | Unknown |  |
| confirmed | Unknown |  |
| email | Unknown |  |
| full_name | Unknown |  |
| has_audit | Unknown |  |
| is_available | Unknown |  |
| role_id | Unknown |  |

## Relationships

- audit_all_status(audit_id) → audit(id)
- audit_auditor(auditor_id) → auditor(id)
- audit_auditor(user_id) → users(id)
- audit_auditor(audit_id) → audit(id)
- audit(entity_id) → entity(id)
- audit(organisation_id) → organisation(id)
- audit(status_id) → audit_status(id)
- audit(questionnaire_id) → questionnaire(id)
- audit_checklist_response(answer_id) → audit_checklist_question(answer_id)
- audit_checklist_response(audit_id) → audit_checklist_question(audit_id)
- audit_checklist_response(section_name) → audit_checklist_question(section_name)
- audit_checklist_question(section_name) → audit_checklist(section_name)
- audit_checklist_question(audit_id) → audit_checklist(audit_id)
- audit_checklist(audit_id) → audit(id)
- checklist_theme_1_summary(audit_id) → audit(id)
- non_conformance(entity_id) → entity(id)
- non_conformance(answer_id) → audit_checklist_question(answer_id)
- non_conformance(audit_status_id) → audit_status(id)
- non_conformance(audit_id) → audit(id)
- non_conformance(originator_id) → auditor(id)
- non_conformance(closed_by_auditor_id) → auditor(id)
- entity_category(entity_id) → entity(id)
- entity(status_id) → audit_status(id)
- entity(parent_id) → entity(id)
- checklist_section_summary(audit_id) → audit(id)
- questionnaire_standard(questionnaire_id) → questionnaire(id)
- questionnaire_category(questionnaire_id) → questionnaire(id)
- questionnaire_status(id) → audit_status(id)
- questionnaire_status(questionnaire_id) → questionnaire(id)
- user_group(user_id) → users(id)
- users(organisation_id) → organisation(id)
- users(auditor_id) → auditor(id)
- auditor(user_id) → users(id)
- auditor(organisation_id) → organisation(id)