Compliance Checkpoint
Explore the interactive ERD
Table & Field Reference
audit_all_status
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
audit_id | Unknown | PKFK |
all_status | Unknown |
audit_auditor
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
audit_id | Unknown | PKFK |
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 | PKFK |
audit_id | Unknown | PKFK |
section_name | Unknown | PKFK |
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 | PKFK |
section_name | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
name | Unknown | |
reference | Unknown |
questionnaire_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
questionnaire_id | Unknown | PKFK |
is_assigned | Unknown | |
name | Unknown |
questionnaire_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
questionnaire_id | Unknown | PKFK |
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 | PKFK |
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 |