Transcend
Explore the interactive ERD
Table & Field Reference
legal_hold
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
identifier_id | Unknown | FK |
created_at | Instant | |
request_count | Unknown | |
value | Unknown |
data_flow_datapoint
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
data_flow_id | Unknown | PK |
index | Unknown | PK |
description | Unknown | |
employee_description | Unknown | |
name | Unknown | |
reference | Unknown | |
subjective_path | Unknown | |
title | Unknown |
data_flow_user
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
data_flow_id | Unknown | PK |
user_id | Unknown | PKFK |
data_flow
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
consent_manager_id | Unknown | PKFK |
created_at | Instant | |
description | Unknown | |
frequency | Unknown | |
integration_name | Unknown | |
is_junk | Unknown | |
last_discovered_at | Unknown | |
logo | Unknown | |
logo_square | Unknown | |
service_description | Unknown | |
service_id | Unknown | |
source | Unknown | |
status | Unknown | |
table_name | Unknown | |
title | Unknown | |
type | Unknown | |
updated_at | Instant | |
value | Unknown |
data_flow_encounter
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
data_flow_id | Unknown | PK |
index | Unknown | PK |
encounter | Unknown |
data_flow_action
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
data_flow_id | Unknown | PK |
index | Unknown | PK |
action | Unknown |
data_flow_team
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
data_flow_id | Unknown | PK |
team_id | Unknown | PKFK |
data_flow_attribute_value
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
data_flow_id | Unknown | PK |
attribute_value_id | Unknown | PKFK |
data_flow_purpose
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
data_flow_id | Unknown | PK |
purpose_id | Unknown | PKFK |
data_flow_service_recipient
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
data_flow_id | Unknown | PK |
id | Unknown | PK |
title | Unknown |
activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
communication_user_id | Unknown | FK |
data_point_id | Unknown | FK |
data_silo_id | Unknown | FK |
request_id | Unknown | FK |
user_id | Unknown | FK |
code | Unknown | |
communication_id | Unknown | |
communication_is_attachment_can_toggle_is_read | Unknown | |
communication_is_attachment_filenames | Unknown | |
communication_is_avatar_url | Unknown | |
communication_is_bcc | Unknown | |
communication_is_bounced | Unknown | |
communication_is_created_at | Unknown | |
communication_is_encrypted | Unknown | |
communication_is_from | Unknown | |
communication_is_read | Unknown | |
communication_is_template | Unknown | |
communication_is_to | Unknown | |
communication_request_data_silo_id | Unknown | |
communication_subject | Unknown | |
communication_type | Unknown | |
created_at | Unknown | |
error | Unknown | |
profile_id | Unknown | |
profile_type | Unknown | |
request_enricher_id | Unknown | |
request_file_id | Unknown | |
request_identifier_id | Unknown | |
request_identifier_request_id | Unknown |
vendor_business
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
vendor_id | Unknown | PKFK |
address | Unknown | |
created_at | Unknown | |
description | Unknown | |
headquarter_country | Unknown | |
headquarter_sub_division | Unknown | |
officer_email | Unknown | |
officer_name | Unknown | |
title | Unknown |
vendor_data_silo
| Column | Type | Keys |
|---|---|---|
data_silo_id | Unknown | PKFK |
vendor_id | Unknown | PKFK |
vendor_data_subcategory
| Column | Type | Keys |
|---|---|---|
data_subcategory_id | Unknown | PKFK |
vendor_id | Unknown | PKFK |
vendor_process_purpose
| Column | Type | Keys |
|---|---|---|
process_purpose_id | Unknown | PKFK |
vendor_id | Unknown | PKFK |
vendor_attribute_value
| Column | Type | Keys |
|---|---|---|
attribute_value_id | Unknown | PKFK |
vendor_id | Unknown | PKFK |
vendor_user
| Column | Type | Keys |
|---|---|---|
user_id | Unknown | PKFK |
vendor_id | Unknown | PKFK |
vendor_team
| Column | Type | Keys |
|---|---|---|
team_id | Unknown | PKFK |
vendor_id | Unknown | PKFK |
vendor_catalog_recipient
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
vendor_id | Unknown | PKFK |
title | Unknown |
vendor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
address | Unknown | |
agreement_link | Unknown | |
agreement_status | Unknown | |
controllership | Json | |
country | Unknown | |
created_at | Instant | |
description | Unknown | |
email | Unknown | |
name | Unknown | |
phone | Unknown | |
sub_division | Unknown | |
title | Unknown | |
website_url | Unknown |
privacy_center_locale
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
privacy_center_id | Unknown | PKFK |
locale | Unknown |
privacy_center_page
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
privacy_center_id | Unknown | PKFK |
type | Unknown |
privacy_center_consent_manager
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PKFK |
privacy_center_id | Unknown | PKFK |
privacy_center
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | FK |
custom_subdomain | Unknown | |
default_locale | Unknown | |
email_prefix | Unknown | |
hosted_domain | Unknown | |
is_disabled | Unknown | |
reply_to_email | Unknown | |
show_consent_manager | Unknown | |
show_cookie | Unknown | |
show_data_flow | Unknown | |
show_policie | Unknown | |
show_privacy_request_button | Unknown | |
show_tracking_technology | Unknown | |
support_email | Unknown | |
theme_str | Unknown | |
transform_access_report | Unknown | |
type | Unknown | |
url | Unknown | |
use_custom_email_domain | Unknown | |
use_reply_email_address | Unknown | |
home_** |
team_user
| Column | Type | Keys |
|---|---|---|
team_id | Unknown | PKFK |
user_id | Unknown | PKFK |
link_team
| Column | Type | Keys |
|---|---|---|
link_team_id | Unknown | PKFK |
team_id | Unknown | PKFK |
team_data_silo
| Column | Type | Keys |
|---|---|---|
data_silo_id | Unknown | PKFK |
team_id | Unknown | PKFK |
team_scope
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
team_id | Unknown | PKFK |
color | Unknown | |
description | Unknown | |
name | Unknown | |
title | Unknown | |
type | Unknown |
team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
name | Unknown | |
parent_team_id | Unknown | |
sso_department | Unknown | |
sso_group | Unknown | |
sso_title | Unknown |
sombra_ip_address
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
sombra_id | Unknown | PKFK |
ip_address | Unknown |
sombra_data_silo
| Column | Type | Keys |
|---|---|---|
data_silo_id | Unknown | PKFK |
sombra_id | Unknown | PKFK |
data_subject_authentication_method
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
sombra_id | Unknown | PKFK |
method | Unknown |
employee_authentication_method
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
sombra_id | Unknown | PKFK |
method | Unknown |
sombra
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
audience | Unknown | |
changelog | Json | |
customer_url | Unknown | |
hosted_method | Unknown | |
is_primary_sombra | Unknown | |
most_recent_sombra | Unknown | |
public_key_ecdh | Unknown | |
tenant_parameters_allow_employee_access | Unknown | |
tenant_parameters_organization_uri | Unknown | |
url | Unknown | |
version | Unknown |
airgap_bundle
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
af_zz | Unknown | |
ar_ae | Unknown | |
bg_bg | Unknown | |
core | Unknown | |
core_config | Unknown | |
created_at | Unknown | |
cs_cz | Unknown | |
da_dk | Unknown | |
de_de | Unknown | |
el_gr | Unknown | |
en | Unknown | |
es_419 | Unknown | |
es_es | Unknown | |
explorer | Unknown | |
fi_fi | Unknown | |
fr_fr | Unknown | |
he_il | Unknown | |
hi_in | Unknown | |
hr_hr | Unknown | |
hu_hu | Unknown | |
id_id | Unknown | |
it_it | Unknown | |
ja_jp | Unknown | |
ko_kr | Unknown | |
lt_lt | Unknown | |
meta_data | Unknown | |
mr_in | Unknown | |
ms_my | Unknown | |
nb_ni | Unknown | |
nl_nl | Unknown | |
pl_pl | Unknown | |
pt_br | Unknown | |
ro_ro | Unknown | |
ru_ru | Unknown | |
sr_latn_rs | Unknown | |
style_sheet | Unknown | |
sv_se | Unknown | |
sync | Unknown | |
ta_in | Unknown | |
tcf_en | Unknown | |
tcf_style_sheet | Unknown | |
tcf_ui | Unknown | |
th_th | Unknown | |
tr_tr | Unknown | |
ui | Unknown | |
uk_ua | Unknown | |
user_script | Unknown | |
vi_vn | Unknown | |
xdi | Unknown | |
zh_cn | Unknown | |
zh_hk | Unknown |
assessment_form_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
author_id | Unknown | FK |
assessment_event_id | Unknown | |
content | Unknown | |
created_at | Unknown | |
form_status | Unknown | |
updated_at | Unknown |
assessment_question_select_option
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
additional_context | Unknown |
user_team
| Column | Type | Keys |
|---|---|---|
team_id | Unknown | PKFK |
user_id | Unknown | PKFK |
user_data_silo
| Column | Type | Keys |
|---|---|---|
data_silo_id | Unknown | PKFK |
user_id | Unknown | PKFK |
user_scope
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
color | Unknown | |
description | Unknown | |
name | Unknown | |
title | Unknown | |
type | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Instant | |
email | Unknown | |
is_admin | Unknown | |
is_invited | Unknown | |
login_method | Unknown | |
name | Unknown | |
onboarded | Unknown | |
profile_picture | Unknown | |
reveal_sombra_secret | Unknown |
cookie_team
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
cookie_id | Unknown | PK |
team_id | Unknown | PKFK |
cookie_datapoint
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
cookie_id | Unknown | PK |
index | Unknown | PK |
description | Unknown | |
employee_description | Unknown | |
name | Unknown | |
reference | Unknown | |
subjective_path | Unknown | |
title | Unknown |
cookie_domain
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
cookie_id | Unknown | PK |
id | Unknown | PK |
domain | Unknown | |
last_discovered_at | Unknown |
cookie_encounter
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
cookie_id | Unknown | PK |
index | Unknown | PK |
encounter | Unknown |
cookie
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
consent_manager_id | Unknown | PKFK |
created_at | Instant | |
description | Unknown | |
frequency | Unknown | |
integration_name | Unknown | |
is_junk | Unknown | |
is_regex | Unknown | |
last_discovered_at | Unknown | |
logo | Unknown | |
logo_square | Unknown | |
name | Unknown | |
service_description | Unknown | |
service_id | Unknown | |
source | Unknown | |
status | Unknown | |
table_name | Unknown | |
title | Unknown | |
updated_at | Instant |
cookie_action
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
cookie_id | Unknown | PK |
index | Unknown | PK |
action | Unknown |
cookie_attribute_value
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
cookie_id | Unknown | PK |
attribute_value_id | Unknown | PKFK |
cookie_user
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
cookie_id | Unknown | PK |
user_id | Unknown | PKFK |
cookie_service_recipient
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
cookie_id | Unknown | PK |
id | Unknown | PK |
title | Unknown |
cookie_purpose
| Column | Type | Keys |
|---|---|---|
consent_manager_id | Unknown | PK |
cookie_id | Unknown | PK |
purpose_id | Unknown | PKFK |
assessment_question_answer_option
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assessment_question_id | Unknown | PKFK |
index | Unknown | |
is_user_created | Unknown | |
presigned_url | Unknown | |
value | Unknown |
assessment_question_selected_answer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assessment_question_id | Unknown | PKFK |
additional_context | Unknown | |
index | Unknown | |
is_user_created | Unknown | |
presigned_url | Unknown | |
value | Unknown |
assessment_question_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assessment_question_id | Unknown | PKFK |
author_id | Unknown | FK |
content | Unknown | |
created_at | Unknown | |
updated_at | Unknown |
assessment_question_previous_submission_answer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assessment_question_id | Unknown | PKFK |
assessment_question_previous_submission_id | Unknown | PKFK |
additional_context | Unknown | |
index | Unknown | |
is_user_created | Unknown | |
presigned_url | Unknown | |
value | Unknown |
assessment_question_previous_submission
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assessment_question_id | Unknown | PKFK |
updated_at | Unknown |
assessment_question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attribute_key_id | Unknown | FK |
allow_select_other | Unknown | |
allowed_mime_types | Unknown | |
description | Unknown | |
display_logic | Unknown | |
external_respondent_email | Unknown | |
index | Unknown | |
is_required | Unknown | |
placeholder | Unknown | |
presigned_risk_file_url | Unknown | |
reference_id | Unknown | |
require_risk_evaluation | Unknown | |
require_risk_matrix_evaluation | Unknown | |
respondent_id | Unknown | |
reviewer_risk_level_id | Unknown | |
risk_category | Json | |
risk_framework_id | Unknown | |
risk_level_from_risk_matrix_color | Unknown | |
risk_level_from_risk_matrix_id | Unknown | |
risk_level_from_risk_matrix_title | Unknown | |
risk_level_id | Unknown | |
risk_logic | Unknown | |
sub_type | Unknown | |
sync_column | Unknown | |
sync_model | Unknown | |
sync_override | Unknown | |
sync_row_ids | Json | |
title | Unknown | |
type | Unknown | |
updated_at | Unknown |
api_key_data_silo
| Column | Type | Keys |
|---|---|---|
api_key_id | Unknown | PKFK |
data_silo_id | Unknown | PKFK |
api_key_scope
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
api_key_id | Unknown | PKFK |
color | Unknown | |
description | Unknown | |
name | Unknown | |
title | Unknown | |
type | Unknown |
api_key
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | FK |
age | Unknown | |
created_at | Instant | |
last_used_at | Unknown | |
preview | Unknown | |
status | Unknown | |
title | Unknown |
assessment_section_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
author_id | Unknown | FK |
assessment_section_id | Unknown | |
content | Unknown | |
created_at | Unknown | |
updated_at | Unknown |
action_integration
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
action_id | Unknown | PKFK |
description | Unknown | |
link | Unknown | |
logo | Unknown | |
title | Unknown | |
type | Unknown |
action_form
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
action_id | Unknown | PKFK |
subject_id | Unknown | FK |
auto_complete | Unknown | |
disabled | Unknown | |
format | Unknown | |
info | Unknown | |
initial_value | Unknown | |
is_plain_text | Unknown | |
is_required | Unknown | |
min_length | Unknown | |
mode | Unknown | |
multiline | Unknown | |
name | Unknown | |
option | Unknown | |
parse_new_line | Unknown | |
send_unencrypted | Unknown | |
snippet | Unknown | |
type | Unknown | |
validator | Unknown | |
value | Unknown | |
label_** | ||
placeholder_** |
action_data_silo
| Column | Type | Keys |
|---|---|---|
action_id | Unknown | PKFK |
data_silo_id | Unknown | PKFK |
action_user
| Column | Type | Keys |
|---|---|---|
action_id | Unknown | PKFK |
user_id | Unknown | PKFK |
action_step
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
action_id | Unknown | PKFK |
description | Unknown | |
icon | Unknown | |
id | Unknown | |
status | Unknown | |
time | Unknown | |
title | Unknown |
action
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
admin_title | Unknown | |
allow_post_compile_choice | Unknown | |
can_resolve | Unknown | |
datapoint_count | Unknown | |
delay_preview_action | Unknown | |
delay_time | Unknown | |
download_availability_duration | Unknown | |
icon | Unknown | |
integration_count | Unknown | |
open_request_count | Unknown | |
post_compile_status | Unknown | |
region | Json | |
region_detection_method | Unknown | |
requires_review | Unknown | |
requires_secondary_review | Unknown | |
send_receipt_email | Unknown | |
skip_downloadable_step | Unknown | |
skip_secondary_if_no_file | Unknown | |
successful_request_count | Unknown | |
type | Unknown | |
waiting_period | Unknown | |
description_** | ||
notfound_template_** | ||
receipt_template_** | ||
secondary_** | ||
secondary_template_** | ||
success_template_** | ||
title_** |
identifier_subject
| Column | Type | Keys |
|---|---|---|
identifier_id | Unknown | PKFK |
subject_id | Unknown | PKFK |
identifier_data_silo
| Column | Type | Keys |
|---|---|---|
data_silo_id | Unknown | PKFK |
identifier_id | Unknown | PKFK |
identifier
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
can_resolve | Unknown | |
is_communication_model | Unknown | |
is_required | Unknown | |
logo | Unknown | |
name | Unknown | |
place_holder | Unknown | |
privacy_center_visibility | Json | |
regex | Unknown | |
select_option | Json | |
type | Unknown | |
display_description_** | ||
display_title_** |
enricher_dependent
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
enricher_id | Unknown | PKFK |
enricher_header
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
enricher_id | Unknown | PKFK |
is_secret | Unknown | |
name | Unknown | |
value | Unknown |
enricher_user
| Column | Type | Keys |
|---|---|---|
enricher_id | Unknown | PKFK |
user_id | Unknown | PKFK |
enricher_identifier
| Column | Type | Keys |
|---|---|---|
enricher_id | Unknown | PKFK |
identifier_id | Unknown | PKFK |
enricher_data_silo
| Column | Type | Keys |
|---|---|---|
data_silo_id | Unknown | PK |
enricher_id | Unknown | PKFK |
enricher_subject
| Column | Type | Keys |
|---|---|---|
enricher_id | Unknown | PKFK |
subject_id | Unknown | PKFK |
enricher_action
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
enricher_id | Unknown | PKFK |
action | Unknown |
enricher
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
identifier_id | Unknown | FK |
description | Unknown | |
error_count | Unknown | |
expiration_duration | Unknown | |
logo | Unknown | |
looker_query_title | Unknown | |
phone_numbers | Json | |
region_list | Json | |
test_regex | Unknown | |
title | Unknown | |
transition_status | Unknown | |
type | Unknown | |
url | Unknown | |
continuation_template_** | ||
template_** |
data_report
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
filter | Unknown | |
hidden_column | Unknown | |
tables | Unknown | |
title | Unknown |
datapoint_integration
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
datapoint_id | Unknown | PKFK |
query | Unknown | |
request_type | Unknown | |
suggested_query | Unknown |
datapoint_reference
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
datapoint_id | Unknown | PKFK |
reference | Unknown |
datapoint_data_subcategory
| Column | Type | Keys |
|---|---|---|
data_subcategory_id | Unknown | PKFK |
datapoint_id | Unknown | PKFK |
datapoint_action_setting
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
datapoint_id | Unknown | PKFK |
active | Unknown | |
allowed | Unknown | |
type | Unknown |
datapoint_team
| Column | Type | Keys |
|---|---|---|
datapoint_id | Unknown | PKFK |
team_id | Unknown | PKFK |
datapoint_user
| Column | Type | Keys |
|---|---|---|
datapoint_id | Unknown | PKFK |
user_id | Unknown | PKFK |
datapoint
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
data_silo_id | Unknown | FK |
access_request_visibility_count | Unknown | |
can_delete | Unknown | |
collection_id | Unknown | |
collection_logo | Unknown | |
collection_static_type | Unknown | |
collection_visual_id | Unknown | |
confirmed_personal_data_count | Unknown | |
data_count_high | Unknown | |
data_count_low | Unknown | |
data_count_medium | Unknown | |
employee_description | Unknown | |
erasure_redaction_method | Unknown | |
erasure_request_redaction_count | Unknown | |
export_mode | Unknown | |
name | Unknown | |
path | Json | |
scanned_description | Unknown | |
subjective_path | Unknown | |
description_** | ||
title_** |
organization_sombra
| Column | Type | Keys |
|---|---|---|
organization_id | Unknown | PKFK |
sombra_id | Unknown | PKFK |
organization
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
parent_id | Unknown | FK |
created_at | Unknown | |
default_email_alias | Unknown | |
deployed_privacy_center_url | Unknown | |
domain | Unknown | |
favicon_alt | Json | |
favicon_id | Unknown | |
favicon_key | Unknown | |
favicon_mime_type | Unknown | |
favicon_size | Unknown | |
favicon_src | Unknown | |
hosted_domain | Unknown | |
logo_alt | Json | |
logo_id | Unknown | |
logo_key | Unknown | |
logo_mime_type | Unknown | |
logo_size | Unknown | |
logo_src | Unknown | |
name | Unknown | |
tier | Unknown | |
uri | Unknown |
subject_action
| Column | Type | Keys |
|---|---|---|
action_id | Unknown | PKFK |
subject_id | Unknown | PKFK |
subject_team
| Column | Type | Keys |
|---|---|---|
subject_id | Unknown | PKFK |
team_id | Unknown | PKFK |
subject_user
| Column | Type | Keys |
|---|---|---|
subject_id | Unknown | PKFK |
user_id | Unknown | PKFK |
subject
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
fulfill_request_count | Unknown | |
icon | Unknown | |
login_instruction_default_message | Unknown | |
login_instruction_description | Unknown | |
login_instruction_id | Unknown | |
open_request_count | Unknown | |
response_type | Unknown | |
silent_mode | Unknown | |
subject_class | Unknown | |
title_default_message | Unknown | |
title_description | Unknown | |
title_id | Unknown | |
type | Unknown | |
disable_instruction_** | ||
redirect_url_** |
experience_region
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
experience_id | Unknown | PKFK |
country | Unknown | |
country_sub_division | Unknown |
browser_language
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
experience_id | Unknown | PKFK |
languages | Unknown |
experience_opt_out_purpose
| Column | Type | Keys |
|---|---|---|
experience_id | Unknown | PKFK |
purpose_id | Unknown | PKFK |
experience_purpose
| Column | Type | Keys |
|---|---|---|
experience_id | Unknown | PKFK |
purpose_id | Unknown | PKFK |
experience
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
browser_time_zones | Json | |
display_name | Unknown | |
display_priority | Unknown | |
name | Unknown | |
operator | Unknown | |
view_state | Unknown |
assessment_form_assignee
| Column | Type | Keys |
|---|---|---|
assessment_form_id | Unknown | PKFK |
id | Unknown | PKFK |
assessment_form_external_assignee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assessment_form_id | Unknown | PKFK |
email | Unknown | |
is_form_creator | Unknown | |
is_form_creator_assigned | Unknown |
assessment_form_reviewer
| Column | Type | Keys |
|---|---|---|
assessment_form_id | Unknown | PKFK |
id | Unknown | PKFK |
assessment_form_section_question
| Column | Type | Keys |
|---|---|---|
assessment_form_id | Unknown | PKFK |
assessment_form_section_id | Unknown | PKFK |
id | Unknown | PKFK |
assessment_form_section
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assessment_form_id | Unknown | PKFK |
index | Unknown | |
is_reviewed | Unknown | |
status | Unknown | |
title | Unknown |
assessment_form_attribute_value
| Column | Type | Keys |
|---|---|---|
assessment_form_id | Unknown | PKFK |
id | Unknown | PKFK |
assessment_form
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assessment_group_id | Unknown | FK |
creator_id | Unknown | FK |
last_editor_id | Unknown | FK |
approved_at | Unknown | |
assigned_at | Unknown | |
created_at | Unknown | |
description | Unknown | |
due_date | Unknown | |
is_archived | Unknown | |
is_externally_created | Unknown | |
is_locked | Unknown | |
latest_event_id | Unknown | |
latest_event_status | Unknown | |
latest_event_updated_at | Unknown | |
rejected_at | Unknown | |
resource | Json | |
retention_schedule_id | Unknown | |
status | Unknown | |
submitted_at | Unknown | |
synced_row | Json | |
title | Unknown | |
title_is_internal | Unknown | |
updated_at | Unknown |
data_sub_attribute_value
| Column | Type | Keys |
|---|---|---|
attribute_value_id | Unknown | PKFK |
data_subcategory_id | Unknown | PKFK |
data_subcategory_team
| Column | Type | Keys |
|---|---|---|
data_subcategory_id | Unknown | PKFK |
team_id | Unknown | PKFK |
data_subcategory_user
| Column | Type | Keys |
|---|---|---|
data_subcategory_id | Unknown | PKFK |
user_id | Unknown | PKFK |
data_sub_retention_schedule
| Column | Type | Keys |
|---|---|---|
schedule | Unknown | PK |
data_subcategory_id | Unknown | PKFK |
data_sub_catalog_recipient
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
data_subcategory_id | Unknown | PKFK |
title | Unknown |
data_subcategory
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
category | Unknown | |
datapoint_count | Unknown | |
description | Unknown | |
is_default | Unknown | |
name | Unknown |
data_silo_discover
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
data_silo_id | Unknown | PKFK |
connection_state | Unknown | |
deleted_at | Unknown | |
description | Unknown | |
external_id | Unknown | |
is_live | Unknown | |
last_connected_at | Unknown | |
last_enabled_at | Unknown | |
plugin_id | Unknown | |
title | Unknown | |
type | Unknown | |
url | Unknown |
data_silo_header
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
data_silo_id | Unknown | PKFK |
is_secret | Unknown | |
name | Unknown | |
value | Unknown |
data_silo_user
| Column | Type | Keys |
|---|---|---|
data_silo_id | Unknown | PKFK |
user_id | Unknown | PKFK |
data_silo_team
| Column | Type | Keys |
|---|---|---|
data_silo_id | Unknown | PKFK |
team_id | Unknown | PKFK |
data_silo_subject
| Column | Type | Keys |
|---|---|---|
data_silo_id | Unknown | PKFK |
subject_id | Unknown | PKFK |
data_silo_block_subject
| Column | Type | Keys |
|---|---|---|
data_silo_id | Unknown | PKFK |
subject_id | Unknown | PKFK |
data_silo_attribute_value
| Column | Type | Keys |
|---|---|---|
attribute_value_id | Unknown | PKFK |
data_silo_id | Unknown | PKFK |
data_silo_identifier
| Column | Type | Keys |
|---|---|---|
data_silo_id | Unknown | PKFK |
identifier_id | Unknown | PKFK |
data_silo_data_subcategory
| Column | Type | Keys |
|---|---|---|
data_silo_id | Unknown | PKFK |
data_subcategory_id | Unknown | PKFK |
data_silo_process_purpose
| Column | Type | Keys |
|---|---|---|
data_silo_id | Unknown | PKFK |
process_purpose_id | Unknown | PKFK |
data_silo
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
catalog_id | Unknown | FK |
connection_state | Unknown | |
contact_email | Unknown | |
contact_name | Unknown | |
controllership | Json | |
country | Unknown | |
country_sub_division | Unknown | |
data_process_agreement_link | Unknown | |
data_process_agreement_status | Unknown | |
data_retention_note | Unknown | |
default_access_request_visibility | Unknown | |
deleted_at | Instant | |
deprecation_state | Unknown | |
description | Unknown | |
email_completion_link_type | Unknown | |
email_include_identifiers_attachment | Unknown | |
email_send_frequency | Unknown | |
email_send_type | Unknown | |
error_count | Unknown | |
external_id | Unknown | |
has_email_enabled | Unknown | |
has_personal_data | Unknown | |
is_live | Unknown | |
last_connected_at | Unknown | |
last_enabled_at | Unknown | |
link | Unknown | |
manual_work_retry_frequency | Unknown | |
notes | Unknown | |
notify_email_address | Unknown | |
notify_webhook_url | Unknown | |
plugin_id | Unknown | |
receiver_data_silos | Json | |
recommended_for_consent | Unknown | |
recommended_for_privacy | Unknown | |
silo_discover | Json | |
sub_datapoint_count | Unknown | |
subdomain | Unknown | |
title | Unknown | |
type | Unknown | |
url | Unknown | |
vendor | Unknown | |
website_url | Unknown | |
cookie_count_** | ||
data_flow_count_** | ||
prompt_email_template_** |
attribute_key
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assessment_template_id | Unknown | |
description | Unknown | |
is_custom | Unknown | |
name | Unknown | |
type | Unknown |
audit_event_user
| Column | Type | Keys |
|---|---|---|
audit_event_id | Unknown | PKFK |
user_id | Unknown | PKFK |
audit_event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
data_silo_id | Unknown | FK |
data_subcategory_id | Unknown | FK |
process_purpose_id | Unknown | FK |
sub_datapoint_id | Unknown | FK |
action_item_id | Unknown | |
additional_context | Unknown | |
after_state | Unknown | |
before_state | Unknown | |
code | Unknown | |
created_at | Unknown | |
transaction_uuid | Unknown |
request_team
| Column | Type | Keys |
|---|---|---|
request_id | Unknown | PKFK |
team_id | Unknown | PKFK |
request_user
| Column | Type | Keys |
|---|---|---|
request_id | Unknown | PKFK |
user_id | Unknown | PKFK |
request_attribute_value
| Column | Type | Keys |
|---|---|---|
attribute_value_id | Unknown | PKFK |
request_id | Unknown | PKFK |
request_report
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
request_id | Unknown | PKFK |
subject | Unknown | |
template | Unknown | |
title | Unknown |
request_step
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
request_id | Unknown | PKFK |
description | Unknown | |
icon | Unknown | |
id | Unknown | |
status | Unknown | |
time | Unknown | |
title | Unknown |
request
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
action_id | Unknown | FK |
subject_id | Unknown | FK |
active_type | Unknown | |
bounced | Unknown | |
can_download | Unknown | |
can_revoke | Unknown | |
can_view_by_data_subject | Unknown | |
completion_duration | Unknown | |
core_identifier | Unknown | |
country | Unknown | |
country_sub_division | Unknown | |
created_at | Instant | |
current_step | Unknown | |
days_remaining | Unknown | |
details | Unknown | |
email | Unknown | |
is_active | Unknown | |
is_active_data_subject | Unknown | |
is_archived | Unknown | |
is_closed | Unknown | |
is_context_expired | Unknown | |
is_opened | Unknown | |
is_silent | Unknown | |
is_test | Unknown | |
link | Unknown | |
locale | Unknown | |
origin | Unknown | |
overdue_percentage | Unknown | |
overdue_time | Unknown | |
post_compile_status | Unknown | |
reply_to_email_addresses | Json | |
report_opened_time | Unknown | |
secondary_report_send_time | Unknown | |
secondary_start_time | Unknown | |
status | Unknown | |
step_status | Unknown | |
subject_type | Unknown | |
type | Unknown | |
updated_at | Instant |
opt_out_signal
| Column | Type | Keys |
|---|---|---|
signal | Unknown | PK |
purpose_id | Unknown | PKFK |
purpose
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
configurable | Unknown | |
default_consent | Unknown | |
description | Unknown | |
essential | Unknown | |
name | Unknown | |
show_consent_manager | Unknown | |
tracking_type | Unknown |
assessment_group_reviewer
| Column | Type | Keys |
|---|---|---|
assessment_group_id | Unknown | PKFK |
id | Unknown | PKFK |
assessment_group_attribute_value
| Column | Type | Keys |
|---|---|---|
assessment_group_id | Unknown | PKFK |
id | Unknown | PKFK |
assessment_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assessment_form_template_id | Unknown | FK |
creator_id | Unknown | FK |
last_editor_id | Unknown | FK |
created_at | Unknown | |
description | Unknown | |
due_date | Unknown | |
external_email_domain | Json | |
is_archived | Unknown | |
share_link | Unknown | |
status | Unknown | |
title | Unknown | |
updated_at | Unknown |
consent_manager_domain
| Column | Type | Keys |
|---|---|---|
domain | Unknown | PK |
consent_manager_id | Unknown | PKFK |
consent_manager
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bundle_url | Unknown | |
can_update_version | Unknown | |
configuration_backend_sync | Unknown | |
configuration_backend_sync_endpoint | Unknown | |
configuration_consent_precedence | Unknown | |
configuration_csp | Unknown | |
configuration_partitions | Unknown | |
configuration_signed_iab_agreement | Unknown | |
configuration_strategy | Unknown | |
configuration_sync_endpoint | Unknown | |
configuration_sync_group | Unknown | |
configuration_telemetry_partitioning | Unknown | |
configuration_unknown_cookie_policy | Unknown | |
configuration_unknown_request_policy | Unknown | |
configuration_use_default_tcf_settings | Unknown | |
configuration_usp_api | Unknown | |
deploy_error | Unknown | |
is_transcend_hosted | Unknown | |
last_deployed_at | Unknown | |
name | Unknown | |
offs | Unknown | |
onboarding_status | Unknown | |
partition_id | Unknown | |
partition_name | Unknown | |
partitions | Unknown | |
state | Unknown | |
tcf_ui_bundle_url | Unknown | |
test_bundle_url | Unknown | |
use_default_tcf_setting | Unknown | |
use_iab_framework | Unknown | |
use_modules | Unknown | |
version | Unknown |
assessment_form_template_section_question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assessment_form_template_id | Unknown | PKFK |
assessment_form_template_section_id | Unknown | PKFK |
assessment_form_template_section_assignee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assessment_form_template_id | Unknown | PKFK |
assessment_form_template_section_id | Unknown | PKFK |
assessment_form_template_section_external_assignee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assessment_form_template_id | Unknown | PKFK |
assessment_form_template_section_id | Unknown | PKFK |
email | Unknown |
assessment_form_template_section
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assessment_form_template_id | Unknown | PKFK |
index | Unknown | |
is_reviewed | Unknown | |
status | Unknown | |
title | Unknown |
assessment_form_template_attribute_key
| Column | Type | Keys |
|---|---|---|
assessment_form_template_id | Unknown | PKFK |
id | Unknown | PKFK |
assessment_form_template
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
last_editor_id | Unknown | FK |
assessment_email_set_id | Unknown | |
created_at | Unknown | |
description | Unknown | |
is_archived | Unknown | |
is_locked | Unknown | |
parent_id | Unknown | |
retention_schedule_id | Unknown | |
source | Unknown | |
status | Unknown | |
title | Unknown | |
updated_at | Unknown |
process_purpose_attribute_value
| Column | Type | Keys |
|---|---|---|
attribute_value_id | Unknown | PKFK |
process_purpose_id | Unknown | PKFK |
process_purpose_team
| Column | Type | Keys |
|---|---|---|
process_purpose_id | Unknown | PKFK |
team_id | Unknown | PKFK |
process_purpose_user
| Column | Type | Keys |
|---|---|---|
process_purpose_id | Unknown | PKFK |
user_id | Unknown | PKFK |
process_purpose_data_subcategory
| Column | Type | Keys |
|---|---|---|
data_subcategory_id | Unknown | PK |
process_purpose_id | Unknown | PKFK |
id | Unknown | FK |
process_purpose
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
is_default | Unknown | |
name | Unknown | |
purpose | Unknown |
sub_datapoint_subcategory
| Column | Type | Keys |
|---|---|---|
data_subcategory_id | Unknown | PKFK |
sub_datapoint_id | Unknown | PKFK |
sub_datapoint_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
sub_datapoint_id | Unknown | PKFK |
data_subcategory_id | Unknown | FK |
classifier_version | Unknown | |
confidence | Unknown | |
status | Unknown |
sub_datapoint_subject
| Column | Type | Keys |
|---|---|---|
sub_datapoint_id | Unknown | PKFK |
subject_id | Unknown | PKFK |
sub_datapoint_purpose
| Column | Type | Keys |
|---|---|---|
purpose_id | Unknown | PKFK |
sub_datapoint_id | Unknown | PKFK |
sub_datapoint_attribute_value
| Column | Type | Keys |
|---|---|---|
attribute_value_id | Unknown | PKFK |
sub_datapoint_id | Unknown | PKFK |
sub_datapoint
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
data_silo_id | Unknown | FK |
datapoint_id | Unknown | FK |
access_request_visibility_enabled | Unknown | |
can_refetch_sample | Unknown | |
content_classification_status | Unknown | |
controllership | Unknown | |
created_at | Unknown | |
description | Unknown | |
erasure_request_redaction_enabled | Unknown | |
last_classified_at | Unknown | |
name | Unknown | |
retention_period | Unknown | |
retention_type | Unknown |
attribute_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attribute_key_id | Unknown | FK |
assessment_id | Unknown | |
assessment_type | Unknown | |
can_delete | Unknown | |
color | Unknown | |
name | Unknown |