SafetyCulture
Explore the interactive ERD
Table & Field Reference
course_progress
| Column | Type | Keys |
|---|---|---|
course_id | Unknown | PKFK |
user_id | Unknown | PKFK |
completed_at | Unknown | |
completed_lessons | Unknown | |
completion_expiry_date | Unknown | |
due_at | Unknown | |
opened_at | Unknown | |
progress_percent | Unknown | |
score | Unknown | |
total_lessons | Unknown | |
user_external_id | Unknown |
incident_category_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_category_id | Unknown | PKFK |
question_id | Unknown | FK |
is_disabled | Unknown | |
is_mandatory | Unknown | |
name | Unknown | |
type | Unknown |
incident_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
display_order | Unknown | |
is_visible | Unknown | |
key | Unknown | |
label | Unknown | |
use_category_access_whitelist | Unknown |
response
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
response_set_id | Unknown | PKFK |
label | Unknown | |
short_label | Unknown |
response_set
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
modified_at | Unknown | |
name | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
created_at | Unknown | |
email | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
last_seen_at | Unknown | |
organisation_id | Unknown | |
seat_type | Unknown |
folder_ancestor
| Column | Type | Keys |
|---|---|---|
folder_id | Unknown | PKFK |
id | Unknown | PKFK |
folder
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
creator_id | Unknown | |
deleted | Unknown | |
folder_members_count | Unknown | |
has_children | Unknown | |
members_count | Unknown | |
meta_label | Unknown | |
modified_at | Instant | |
name | Unknown | |
org_id | Unknown |
template_item_children
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
template_id | Unknown | PKFK |
template_item_id | Unknown | PKFK |
children | Json | |
label | Unknown | |
custom_** |
template_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
template_id | Unknown | PKFK |
label | Unknown | |
section | Json |
template_response
| Column | Type | Keys |
|---|---|---|
response_id | Unknown | PK |
color | Unknown | |
is_grs | Unknown | |
label | Unknown | |
response_set_id | Unknown | |
score | Unknown | |
score_enabled | Unknown | |
template_id | Unknown |
template_title_rule
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
template_id | Unknown | PKFK |
rule | Unknown |
template_media
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
template_id | Unknown | PKFK |
filename | Unknown | |
media_type | Unknown | |
token | Unknown |
template
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
access_level | Unknown | |
added_at | Unknown | |
archived | Unknown | |
author_id | Unknown | |
created_at | Unknown | |
date_draft_modified | Unknown | |
description | Unknown | |
draft_author_name | Unknown | |
global_response_set | Json | |
is_locked_from_shared_library | Unknown | |
last_used | Unknown | |
mandatory_mark_as_complete | Unknown | |
metadata_image_filename | Unknown | |
metadata_image_id | Unknown | |
metadata_image_media_type | Unknown | |
metadata_image_token | Unknown | |
modified_at | Unknown | |
name | Unknown | |
origin_information | Unknown | |
owner_id | Unknown | |
revision_id | Unknown | |
revision_key | Unknown | |
support_site_as_question_type | Unknown | |
translation_id | Unknown |
template_permission
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
template_id | Unknown | PKFK |
permission | Unknown | |
type | Unknown |
schedule_item_reminder
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
schedule_item_id | Unknown | PKFK |
duration | Unknown | |
event | Unknown |
schedule_item_assignee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
schedule_item_id | Unknown | PKFK |
name | Unknown | |
type | Unknown |
schedule_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
asset_id | Unknown | FK |
creator_id | Unknown | FK |
can_late_submit | Unknown | |
created_at | Unknown | |
description | Unknown | |
document_id | Unknown | |
document_name | Unknown | |
document_type | Unknown | |
duration | Unknown | |
from_date | Unknown | |
location_id | Unknown | |
modified_at | Unknown | |
must_complete | Unknown | |
next_occurrence_due | Unknown | |
next_occurrence_start | Unknown | |
recurrence | Unknown | |
site_based_assignment_enabled | Unknown | |
start_time_hour | Unknown | |
start_time_minute | Unknown | |
status | Unknown | |
timezone | Unknown | |
to_date | Unknown |
incident_question_choice
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_id | Unknown | PKFK |
question_id | Unknown | PKFK |
text | Unknown |
incident_question_answer
| Column | Type | Keys |
|---|---|---|
answer_id | Unknown | PK |
incident_id | Unknown | PKFK |
question_id | Unknown | PKFK |
choice_id | Unknown | FK |
answered_at | Unknown | |
text | Unknown |
incident_question
| Column | Type | Keys |
|---|---|---|
question_id | Unknown | PK |
incident_id | Unknown | PKFK |
is_answered | Unknown | |
is_mandatory | Unknown | |
text | Unknown | |
type | Unknown |
inspection_answer
| Column | Type | Keys |
|---|---|---|
inspection_id | Unknown | PK |
question_id | Unknown | PK |
address_answer | Unknown | |
asset_answer | Unknown | |
calculation_answer | Json | |
checkbox_answer | Unknown | |
datetime_answer | Unknown | |
drawing_answer | Json | |
dynamicfield_answer | Json | |
list_answer | Json | |
location | Json | |
media_answer | Json | |
modified_at | Unknown | |
question_answer | Json | |
signature_answer | Json | |
site_answer | Json | |
slider_answer | Json | |
switch_answer | Unknown | |
temperature_answer | Json | |
text_answer | Unknown |
course
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
branding_image_url | Unknown | |
created_datetime | Unknown | |
description | Unknown | |
due_by | Unknown | |
duration | Unknown | |
external_id | Unknown | |
is_mandatory | Unknown | |
is_published | Unknown | |
lesson_count | Unknown | |
locale | Unknown | |
logo_url | Unknown | |
modified_datetime | Unknown | |
status | Unknown | |
thumbnail_url | Unknown | |
title | Unknown | |
translation_original_course_external_id | Unknown | |
translation_original_course_id | Unknown |
group_member
| Column | Type | Keys |
|---|---|---|
groups_id | Unknown | PKFK |
user_id | Unknown | PKFK |
groups
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
name | Unknown | |
type | Unknown |
site
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
deleted | Unknown | |
meta_label | Unknown | |
name | Unknown | |
organisation_id | Unknown | |
parent_id | Unknown | |
site_uuid | Unknown |
asset_media
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
asset_id | Unknown | PKFK |
filename | Unknown | |
media_type | Unknown | |
token | Unknown |
asset_field
| Column | Type | Keys |
|---|---|---|
field_id | Unknown | PK |
asset_id | Unknown | PKFK |
currency_code | Unknown | |
currency_nanos | Unknown | |
currency_unit | Unknown | |
custom_id | Unknown | |
field_type | Unknown | |
id | Unknown | |
name | Unknown | |
string_value | Unknown | |
timestamp_value | Unknown | |
value_type | Unknown | |
visible | Unknown |
asset
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
code | Unknown | |
created_at | Unknown | |
custom_id | Unknown | |
inspected_at | Unknown | |
modified_at | Instant | |
name | Unknown | |
profile_image_filename | Unknown | |
profile_image_id | Unknown | |
profile_image_media_type | Unknown | |
profile_image_token | Unknown | |
site_id | Unknown | |
site_name | Unknown | |
sourced_from_external_system | Unknown | |
state | Unknown | |
type | Unknown | |
type_id | Unknown |
incident_collaborator
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_id | Unknown | PKFK |
contributor_id | Unknown | FK |
user_id | Unknown | FK |
assigned_role | Unknown | |
external_user_email | Unknown | |
external_user_id | Unknown | |
group_id | Unknown | |
type | Unknown |
incident_reference
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_id | Unknown | PKFK |
type | Unknown |
incident_label
| Column | Type | Keys |
|---|---|---|
label_id | Unknown | PK |
incident_id | Unknown | PKFK |
incident_media
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_id | Unknown | PKFK |
filename | Unknown | |
media_type | Unknown | |
token | Unknown |
incident
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
asset_id | Unknown | FK |
category_id | Unknown | FK |
creator_id | Unknown | FK |
inspection_id | Unknown | FK |
template_id | Unknown | FK |
administrative_area | Unknown | |
completed_at | Unknown | |
country | Unknown | |
created_at | Unknown | |
description | Unknown | |
due_at | Unknown | |
iso_country_code | Unknown | |
locality | Unknown | |
modified_at | Instant | |
name | Unknown | |
occurred_at | Unknown | |
postal_code | Unknown | |
priority_id | Unknown | |
site_area | Unknown | |
site_id | Unknown | |
site_name | Unknown | |
site_region | Unknown | |
status_display_order | Unknown | |
status_id | Unknown | |
status_key | Unknown | |
status_label | Unknown | |
sub_administrative_area | Unknown | |
sub_locality | Unknown | |
sub_thoroughfare | Unknown | |
thoroughfare | Unknown | |
title | Unknown | |
type | Unknown | |
unique_id | Unknown |
schedule_occurrence
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
audit_id | Unknown | FK |
template_id | Unknown | FK |
assignee_status | Unknown | |
completed_at | Instant | |
due_time | Instant | |
miss_time | Instant | |
note | Unknown | |
occurrence_id | Unknown | |
occurrence_status | Unknown | |
organisation_id | Unknown | |
schedule_id | Unknown | |
start_time | Instant | |
user_id | Unknown |
action
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assignee_id | Unknown | FK |
action_id | Unknown | |
modified_at | Unknown | |
name | Unknown | |
organisation_id | Unknown | |
type | Unknown |
inspection
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
asset_id | Unknown | FK |
template_id | Unknown | FK |
archived | Unknown | |
author_id | Unknown | |
author_name | Unknown | |
client_site | Unknown | |
conducted_on | Unknown | |
created_at | Unknown | |
date_completed | Unknown | |
date_modified | Unknown | |
date_started | Unknown | |
document_no | Unknown | |
duration | Unknown | |
latitude | Unknown | |
location | Unknown | |
longitude | Unknown | |
max_score | Unknown | |
modified_at | Unknown | |
name | Unknown | |
organisation_id | Unknown | |
owner_id | Unknown | |
owner_name | Unknown | |
personnel | Unknown | |
prepared_by | Unknown | |
score | Unknown | |
score_percentage | Unknown | |
site_id | Unknown | |
template_author | Unknown | |
template_name | Unknown | |
web_report_link | Unknown |
inspection_items
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
audit_id | Unknown | FK |
template_id | Unknown | FK |
category | Unknown | |
category_id | Unknown | |
combined_max_score | Unknown | |
combined_score | Unknown | |
combined_score_percentage | Unknown | |
comment | Unknown | |
created_at | Instant | |
inactive | Unknown | |
is_failed_response | Unknown | |
item_id | Unknown | |
item_index | Unknown | |
label | Unknown | |
location_latitude | Unknown | |
location_longitude | Unknown | |
mandatory | Unknown | |
max_score | Unknown | |
media_files | Unknown | |
media_hypertext_reference | Unknown | |
media_ids | Unknown | |
modified_at | Instant | |
organisation_id | Unknown | |
parent_id | Unknown | |
primeelement_id | Unknown | |
primeelement_index | Unknown | |
response | Unknown | |
response_id | Unknown | |
response_set_id | Unknown | |
score | Unknown | |
score_percentage | Unknown | |
type | Unknown |