OneTrust
Explore the interactive ERD
Table & Field Reference
preference_center
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_date | LocalDateTime | |
name | Unknown | |
organization_name | Unknown | |
published_date | LocalDateTime | |
status | Unknown | |
template | Unknown |
preference_center_schema_language
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
preference_center_id | Unknown | PKFK |
content | Unknown | |
description | Unknown | |
is_default | Boolean | |
name | Unknown | |
translated_language | Unknown |
preference_center_schema_notification_purpose_custom_preference
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
_fivetran_id | Unknown | PKFK |
preference_center_id | Unknown | PKFK |
preference_center_schema_notification_purpose_id | Unknown | PKFK |
custom_preference_options | Json | |
description | Unknown | |
display_as | Unknown | |
is_required | Boolean | |
languages | Json | |
name | Unknown | |
selection_type | Unknown |
preference_center_schema_notification_purpose_language
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
preference_center_id | Unknown | PKFK |
preference_center_schema_notification_purpose_id | Unknown | PKFK |
content | Unknown | |
description | Unknown | |
is_default | Boolean | |
name | Unknown | |
translated_language | Unknown |
preference_center_schema_notification_purpose_topic
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
_fivetran_id | Unknown | PKFK |
preference_center_id | Unknown | PKFK |
preference_center_schema_notification_purpose_id | Unknown | PKFK |
languages | Json | |
name | Unknown |
preference_center_schema_notification_purpose
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
_fivetran_id | Unknown | PKFK |
preference_center_id | Unknown | PKFK |
description | Unknown | |
label | Unknown | |
purpose_order | Unknown | |
version | Unknown | |
visibility | Unknown |
preference_center_schema_page_language
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
preference_center_id | Unknown | PKFK |
preference_center_schema_page_id | Unknown | PKFK |
content | Unknown | |
description | Unknown | |
is_default | Boolean | |
name | Unknown | |
translated_language | Unknown |
preference_center_schema_page_section_notification_purpose
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
_fivetran_id | Unknown | PKFK |
preference_center_id | Unknown | PKFK |
preference_center_schema_page_id | Unknown | PKFK |
preference_center_schema_page_section_id | Unknown | PKFK |
custom_preferences | Json | |
description | Unknown | |
label | Unknown | |
languages | Json | |
purpose_order | Unknown | |
topics | Json | |
version | Unknown | |
visibility | Unknown |
preference_center_schema_page_section
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
_fivetran_id | Unknown | PKFK |
preference_center_id | Unknown | PKFK |
preference_center_schema_page_id | Unknown | PKFK |
custom_data_elements_id | Unknown | |
custom_data_elements_is_hidden | Boolean | |
custom_data_elements_is_read_only | Unknown | |
custom_data_elements_languages | Json | |
custom_data_elements_name | Unknown | |
custom_data_elements_order | Unknown | |
elements_id | Unknown | |
elements_languages | Json | |
elements_order | Unknown | |
identifier_type | Unknown | |
is_header_hidden | Boolean | |
languages | Json | |
preference_center_order | Unknown |
preference_center_schema_page
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
_fivetran_id | Unknown | PKFK |
preference_center_id | Unknown | PKFK |
display_subscribe_all | Boolean | |
display_subscribe_settings | Boolean | |
display_unsubscribe_all | Boolean | |
navigation_enabled | Boolean | |
page_order | Unknown |
preference_center_schema
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
preference_center_id | Unknown | FK |
auto_check_topics | Boolean | |
default_language | Unknown | |
display_notification_purpose | Unknown | |
display_page_level_subscribe_settings | Unknown | |
display_subscribe_all | Unknown | |
display_subscribe_settings | Unknown | |
display_unsubscribe_all | Unknown | |
enable_multiple_identities | Unknown | |
hierarchical_access_control | Unknown | |
preference_center_settings_change_preferences_label | Unknown | |
preference_center_settings_company_logo | Unknown | |
preference_center_settings_country_code_placeholder | Unknown | |
preference_center_settings_email_input_title | Unknown | |
preference_center_settings_email_login_error | Unknown | |
preference_center_settings_email_login_option | Unknown | |
preference_center_settings_email_placeholder | Unknown | |
preference_center_settings_language_selector | Unknown | |
preference_center_settings_login_method | Unknown | |
preference_center_settings_login_title | Unknown | |
preference_center_settings_logout_description | Unknown | |
preference_center_settings_logout_title | Unknown | |
preference_center_settings_notification_purpose_description | Unknown | |
preference_center_settings_notification_purpose_label | Unknown | |
preference_center_settings_onbehalf_login_error | Unknown | |
preference_center_settings_page_title | Unknown | |
preference_center_settings_phone_login_error | Unknown | |
preference_center_settings_phone_login_option | Unknown | |
preference_center_settings_phone_number_input_title | Unknown | |
preference_center_settings_phone_number_placeholder | Unknown | |
preference_center_settings_purpose_toggle_active_label | Unknown | |
preference_center_settings_purpose_toggle_inactive_label | Unknown | |
preference_center_settings_reasons_label | Unknown | |
preference_center_settings_reasons_message | Unknown | |
preference_center_settings_reasons_title | Unknown | |
preference_center_settings_select_identifier_label | Unknown | |
preference_center_settings_send_request | Unknown | |
preference_center_settings_sso_login_title | Unknown | |
preference_center_settings_subscribe_all_label | Unknown | |
preference_center_settings_subscribed_badge_label | Unknown | |
preference_center_settings_subscription_settings_label | Unknown | |
preference_center_settings_subscription_status_label | Unknown | |
preference_center_settings_title | Unknown | |
preference_center_settings_topics_label | Unknown | |
preference_center_settings_undo_changes_label | Unknown | |
preference_center_settings_unsubscribe_all_label | Unknown | |
preference_center_settings_unsubscribe_error | Unknown | |
preference_center_settings_unsubscribe_link | Unknown | |
preference_center_settings_unsubscribe_success_label | Unknown | |
preference_center_settings_unsubscribe_successful | Unknown | |
preference_center_settings_unsubscribed_badge_label | Unknown | |
preference_center_settings_update_error_label | Unknown | |
preference_center_settings_update_success_label | Unknown | |
update_not_opted_out_to_active_status | Unknown |
assessment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
create_date | Unknown | |
inherent_risk_score | Unknown | |
last_updated_date | Unknown | |
name | Unknown | |
number | Unknown | |
open_risk_count | Unknown | |
org_group_name | Unknown | |
primary_inventory_id | Unknown | |
primary_inventory_name | Unknown | |
primary_inventory_number | Unknown | |
residual_risk_score | Unknown | |
result | Unknown | |
result_id | Unknown | |
result_name | Unknown | |
state | Unknown | |
status | Unknown | |
tags | Json | |
target_risk_score | Unknown | |
template_id | Unknown | |
template_name | Unknown | |
template_root_version_id | Unknown |
login_history
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ipaddress | Unknown | |
login_datetime | Instant | |
os_info | Unknown | |
status | Unknown | |
username | Unknown |
storage_scan_result
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
web_scan_domain_id | Unknown | PK |
web_scan_id | Unknown | PK |
host | Unknown | |
type | Unknown | |
value | Unknown |
consent_group_data_subject_purpose
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
consent_group_data_subject_id | Unknown | PKFK |
consent_group_id | Unknown | PKFK |
effective_status | Unknown | |
status | Unknown | |
version | Unknown |
consent_group_data_subject
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
consent_group_id | Unknown | PKFK |
identifier | Unknown |
consent_group_purpose_rule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
consent_group_id | Unknown | PKFK |
effective_status | Unknown | |
enforced_status | Unknown |
consent_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
consent_groups | Json | |
description | Unknown | |
external_name | Unknown | |
membership_type | Unknown | |
name | Unknown |
data_subject_group_primary_data_subject
| Column | Type | Keys |
|---|---|---|
data_subject_group_id | Unknown | PKFK |
id | Unknown | PKFK |
identifier | Unknown | |
identifier_type | Unknown |
data_subject_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
primary_data_subject_id | Unknown | FK |
created_date | LocalDateTime | |
group_name | Unknown | |
identifier_key | Unknown | |
is_primary | Boolean | |
last_modified_date | LocalDateTime | |
number_of_data_subject | Unknown | |
organizations | Json |
user_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
last_modified_by | Unknown | FK |
created_date | Instant | |
description | Unknown | |
last_modified_date | Instant | |
name | Unknown |
resource_schema_extension
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
resource_id | Unknown | PKFK |
is_required | Boolean | |
schema | Unknown |
resource
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
endpoint | Unknown | |
meta_attributes | Json | |
meta_created_date | LocalDateTime | |
meta_last_modified_date | LocalDateTime | |
meta_location | Unknown | |
meta_resource_type | Unknown | |
meta_version | Unknown | |
name | Unknown | |
schema | Unknown |
users_email
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
users_id | Unknown | PKFK |
display | Unknown | |
is_primary | Boolean | |
reference | Unknown | |
type | Unknown |
users_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
users_id | Unknown | PKFK |
display | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Boolean | |
external_id | Unknown | |
family_name | Unknown | |
given_name | Unknown | |
meta_created_date | LocalDateTime | |
meta_last_modified_date | LocalDateTime | |
meta_location | Unknown | |
meta_resource_type | Unknown | |
meta_version | Unknown | |
roles | Json | |
schema_enterprise_business_unit | Unknown | |
schema_enterprise_department | Unknown | |
schema_enterprise_division | Unknown | |
schema_enterprise_employee_number | Unknown | |
schema_enterprise_manager | Json | |
schema_enterprise_office_location | Unknown | |
schema_enterprise_organization | Unknown | |
schemas | Json | |
title | Unknown | |
user_name | Unknown | |
user_type | Unknown |
page_scan_result
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
web_scan_domain_id | Unknown | PK |
web_scan_id | Unknown | PK |
audit_url | Unknown | |
cookie_count | Unknown | |
error_message | Unknown | |
is_behind_login | Boolean | |
is_cookie_policy | Unknown | |
is_login_form | Boolean | |
is_privacy_policy | Unknown | |
scan_order | Unknown | |
source_url | Unknown |
receipt_purpose_custom_preference_language
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
receipt_id | Unknown | PKFK |
receipt_purpose_custom_preference_id | Unknown | PKFK |
receipt_purpose_id | Unknown | PKFK |
description | Unknown | |
is_default | Boolean | |
language_code | Unknown | |
name | Unknown | |
options | Json |
receipt_purpose_custom_preference
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
receipt_id | Unknown | PKFK |
receipt_purpose_id | Unknown | PKFK |
custom_preference_options | Json | |
display_as | Unknown | |
name | Unknown |
receipt_purpose_topic
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
receipt_id | Unknown | PKFK |
receipt_purpose_id | Unknown | PKFK |
integration_key | Unknown | |
languages | Json | |
name | Unknown |
receipt_purpose
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
receipt_id | Unknown | PKFK |
transaction_id | Unknown | FK |
consent_lifespan | Unknown | |
description | Unknown | |
expiry_date | LocalDateTime | |
external_reference | Unknown | |
is_valid_note | Boolean | |
name | Unknown | |
note_id | Unknown | |
note_langauge | Unknown | |
note_text | Unknown | |
note_type | Unknown | |
status | Unknown | |
type | Unknown | |
version | Unknown |
receipt_rule_evaluation_result
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
receipt_id | Unknown | PKFK |
action_results | Json | |
additional_params | Json | |
consent_rule_type | Unknown | |
evaluation_result | Boolean | |
group_id | Unknown | |
result_data | Json |
receipt
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
collection_point_uuid | Unknown | FK |
organization_id | Unknown | FK |
attributes | Json | |
consent_creation_date | LocalDateTime | |
consent_string_content | Unknown | |
consent_string_type | Unknown | |
country | Unknown | |
custom_payload | Json | |
data_elements | Json | |
data_subject_identifier | Unknown | |
data_subject_identifier_hash | Unknown | |
double_opt_in | Boolean | |
geo_location_purpose_ids | Json | |
interaction_date | LocalDateTime | |
is_anonymous | Boolean | |
is_test | Boolean | |
jwt_version | Unknown | |
origin | Unknown | |
recorded_language | Unknown | |
source | Json | |
state | Unknown | |
state_name | Unknown | |
unsubscribe_all | Boolean |
schema_attribute
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
schema_id | Unknown | PKFK |
description | Unknown | |
is_case_exact | Boolean | |
is_multi_valued | Boolean | |
is_required | Boolean | |
mutability | Unknown | |
name | Unknown | |
reference_type | Unknown | |
returned | Unknown | |
sub_attributes | Json | |
type | Unknown | |
uniqueness | Unknown |
schema
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
location | Unknown | |
name | Unknown | |
resource_type | Unknown |
inventories
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | FK |
name | Unknown | |
organization_value | Unknown |
purpose_version_custom_preference_language
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
purpose_id | Unknown | PKFK |
purpose_version_custom_preference_id | Unknown | PKFK |
purpose_version_index | Unknown | PKFK |
description | Unknown | |
is_default | Boolean | |
language_code | Unknown | |
name | Unknown | |
options | Json |
purpose_version_custom_preference
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
purpose_id | Unknown | PKFK |
purpose_version_index | Unknown | PKFK |
custom_preference_options | Json | |
display_as | Unknown | |
name | Unknown |
purpose_version_topic
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
purpose_id | Unknown | PKFK |
purpose_version_index | Unknown | PKFK |
integration_key | Unknown | |
languages | Json | |
name | Unknown |
purpose_version
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
purpose_id | Unknown | PKFK |
consent_lifespan | Unknown | |
created_by | Unknown | |
created_date | Instant | |
description | Unknown | |
detail | Unknown | |
enable_geo_location | Boolean | |
expiry_date_type | Unknown | |
implicit_consent_confirm_desc | Unknown | |
implicit_consent_life_span | Unknown | |
label | Unknown | |
last_modified_by | Unknown | |
last_modified_date | Instant | |
organizations | Json | |
parent_purpose_id | Unknown | |
published_by | Unknown | |
published_date | Instant | |
purpose_type | Unknown | |
retired_on_date | Instant | |
status | Unknown | |
version | Unknown |
purpose
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attributes | Json | |
created_date | Instant | |
last_modified_date | Instant | |
published_by | Unknown | |
published_date | Instant | |
retired_on_date | Instant |
link_token
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
data_subject_id | Unknown | FK |
created_date | LocalDateTime | |
expiry_date | LocalDateTime | |
url_encoded_link_token | Unknown |
tag_scan_result
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
web_scan_domain_id | Unknown | PK |
web_scan_id | Unknown | PK |
added | Unknown | |
age | Unknown | |
change_since_previous_scan | Unknown | |
child_url | Unknown | |
created_date | Unknown | |
host | Unknown | |
params | Unknown | |
parent_url | Unknown | |
removed | Unknown | |
src_url | Unknown | |
status | Unknown | |
type | Unknown |
service_provider_configuration_authentication_scheme
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
service_provider_configuration_fivetran_id | Unknown | PKFK |
description | Unknown | |
documentation_link | Unknown | |
is_primary | Boolean | |
name | Unknown | |
spec_link | Unknown | |
type | Unknown |
service_provider_configuration
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
attributes | Json | |
bulk_max_operation | Unknown | |
bulk_max_payload_size | Unknown | |
bulk_supported | Boolean | |
change_password_supported | Boolean | |
created_date | LocalDateTime | |
e_tag_supported | Boolean | |
filter_max_result | Unknown | |
filter_supported | Boolean | |
last_modified_date | LocalDateTime | |
location | Unknown | |
patch_supported | Boolean | |
resource_type | Unknown | |
schemas | Json | |
sort_supported | Boolean | |
version | Unknown | |
xml_data_format_supported | Boolean |
collection_point_purpose_custom_preference
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
collection_point_id | Unknown | PKFK |
collection_point_purpose_id | Unknown | PKFK |
name | Unknown | |
options_disabled | Unknown | |
options_id | Unknown | |
options_label | Unknown |
collection_point_purpose_topic
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
collection_point_id | Unknown | PKFK |
collection_point_purpose_id | Unknown | PKFK |
can_delete | Boolean | |
integration_key | Unknown | |
name | Unknown |
collection_point_purpose
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
collection_point_id | Unknown | PKFK |
attributes | Json | |
created_by | Unknown | |
created_date | Instant | |
description | Unknown | |
enable_geolocation | Boolean | |
external_reference | Unknown | |
implicit_consent_confirm_desc | Unknown | |
implicit_consent_life_span | Unknown | |
label | Unknown | |
life_span | Unknown | |
new_version_available | Boolean | |
organizations | Json | |
parent_purpose_id | Unknown | |
published_by | Unknown | |
published_date | Instant | |
purpose_id_with_version | Unknown | |
purpose_languages | Json | |
status | Unknown | |
type | Unknown | |
updated_by | Unknown | |
updated_date | Instant | |
version | Unknown |
collection_point
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | FK |
ack_email_identifier | Unknown | |
activation_date | LocalDateTime | |
allow_multiple_identifier_types | Boolean | |
attributes | Json | |
can_create_new_version | Boolean | |
consent_doi_cancel_option | Boolean | |
consent_type | Unknown | |
cookie_consent_update | Unknown | |
created_by | Unknown | |
created_date | LocalDateTime | |
data_controller_name | Unknown | |
data_elements | Json | |
data_subject_identifier | Unknown | |
default_language_code | Unknown | |
description | Unknown | |
disable_reports | Boolean | |
disabled | Boolean | |
doi_email_identifier | Unknown | |
doi_email_to_parent | Boolean | |
doi_send_confirmation_email | Boolean | |
enable_captcha | Boolean | |
enable_custom_preference_event | Boolean | |
enable_data_element_event | Boolean | |
enable_geo_location | Boolean | |
enable_geo_location_for_data_elements | Boolean | |
enable_new_consent_integration | Boolean | |
enable_prefill_identifier | Boolean | |
enable_primary_identifier | Boolean | |
enable_publish_event | Boolean | |
enable_purpose_event | Boolean | |
first_consent_receipt_on | Unknown | |
hosted_web_form_branding_data | Json | |
hosted_web_form_captcha_url | Unknown | |
hosted_web_form_default_language_translations | Json | |
hosted_web_form_draft_link | Unknown | |
hosted_web_form_ds_portal_base_url | Unknown | |
hosted_web_form_geo_location_url | Unknown | |
hosted_web_form_id | Unknown | |
hosted_web_form_integration_settings | Json | |
hosted_web_form_integration_urls | Json | |
hosted_web_form_name | Unknown | |
hosted_web_form_new_selected_languages | Json | |
hosted_web_form_portal_data | Json | |
hosted_web_form_preview_id | Unknown | |
hosted_web_form_prod_publish_version | Unknown | |
hosted_web_form_prod_script_guid | Unknown | |
hosted_web_form_published_link | Unknown | |
hosted_web_form_sdk_version | Unknown | |
hosted_web_form_supported_script_version | Unknown | |
hosted_web_form_template | Unknown | |
hosted_web_form_test_publish_version | Unknown | |
hosted_web_form_test_script_guid | Unknown | |
hosted_web_form_translation_cf_worker_url | Unknown | |
hosted_web_form_version_id | Unknown | |
hosted_web_form_web_form_data | Json | |
how_to_withdraw | Unknown | |
iab_vendor_id | Unknown | |
identifier_data_element_allow_multi_value | Boolean | |
identifier_data_element_can_delete | Boolean | |
identifier_data_element_can_edit | Boolean | |
identifier_data_element_collection_points | Unknown | |
identifier_data_element_collection_points_without_retired | Unknown | |
identifier_data_element_created_date | Instant | |
identifier_data_element_data_element_fields | Json | |
identifier_data_element_id | Unknown | |
identifier_data_element_is_identifier | Boolean | |
identifier_data_element_label | Unknown | |
identifier_data_element_languages | Json | |
identifier_data_element_linked_data_subject_element_exists | Boolean | |
identifier_data_element_number_of_languages | Unknown | |
identifier_data_element_organizations | Json | |
identifier_data_element_pi_info | Boolean | |
identifier_data_element_preference_centers | Unknown | |
identifier_data_element_total_active_preference_centers | Unknown | |
identifier_data_element_updated_date | Instant | |
identifier_types | Json | |
include_identifier_parameter | Boolean | |
include_parameter | Boolean | |
is_authentication_required | Boolean | |
is_consent_integration | Boolean | |
is_double_opt_in | Boolean | |
is_dynamic_collection_point | Boolean | |
is_hosted_sdk | Boolean | |
jwt_token | Unknown | |
languages | Json | |
last_activity_date | LocalDateTime | |
last_modified_by | Unknown | |
last_sdk_integration_date | LocalDateTime | |
name | Unknown | |
new_sdk_integration_enabled | Boolean | |
no_consent_transactions | Unknown | |
notices_with_versions | Json | |
other_information | Unknown | |
override_active_purpose | Boolean | |
parent_identifier_types | Json | |
preference_center_id | Unknown | |
preference_center_name | Unknown | |
preference_center_organization_name | Unknown | |
preference_center_template | Unknown | |
prefill_identifier | Unknown | |
primary_identifier_type | Unknown | |
privacy_policy_url | Unknown | |
published_by | Unknown | |
reconfirm_active_purpose | Boolean | |
redirect_on_form_submission | Boolean | |
redirect_url | Unknown | |
responsible_group_id | Unknown | |
responsible_user_id | Unknown | |
right_to_withdraw | Unknown | |
send_consent_email | Boolean | |
show_dl_notification | Boolean | |
show_warning | Boolean | |
status | Unknown | |
type | Unknown | |
version | Unknown | |
warning_reasons | Json | |
web_form_url | Unknown |
cookie_scan_result
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
web_scan_domain_id | Unknown | PK |
web_scan_id | Unknown | PK |
category_id | Unknown | |
color | Unknown | |
cookie_category | Unknown | |
description | Unknown | |
expiry_date | Unknown | |
expiry_unit | Unknown | |
first_party | Unknown | |
host | Unknown | |
host_description | Unknown | |
is_behind_login | Boolean | |
is_http_only | Boolean | |
is_new_found | Boolean | |
is_newly_added | Boolean | |
is_secure | Boolean | |
is_session | Boolean | |
name | Unknown | |
path | Unknown | |
purpose | Unknown | |
status | Unknown | |
third_party_description | Unknown | |
url_domain | Unknown |
groups_member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
groups_id | Unknown | PKFK |
hyperlink | Unknown | |
type | Unknown |
groups
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_date | Instant | |
display_name | Unknown | |
external_id | Unknown | |
last_modified_date | Instant | |
location | Unknown | |
resource_type | Unknown | |
schemas | Json | |
schemas_group_category | Unknown | |
schemas_group_description | Unknown |
form_scan_result_form_data_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
form_scan_result_id | Unknown | PKFK |
field_name | Unknown | |
form_name | Unknown | |
form_value | Unknown | |
label | Unknown | |
personal_data | Unknown | |
title | Unknown | |
type | Unknown |
form_scan_result
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
web_scan_domain_id | Unknown | PK |
web_scan_id | Unknown | PK |
name | Unknown | |
number_of_pages_found | Unknown |
scan_delta_added_cookie
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
scan_delta_id | Unknown | PKFK |
category_id | Unknown | |
color | Unknown | |
cookie_category | Unknown | |
description | Unknown | |
expiry_date | Unknown | |
expiry_unit | Unknown | |
first_party | Unknown | |
host | Unknown | |
host_description | Unknown | |
is_behind_login | Unknown | |
is_http_only | Unknown | |
is_new_found | Unknown | |
is_newly_added | Unknown | |
is_secure | Unknown | |
is_session | Unknown | |
name | Unknown | |
path | Unknown | |
purpose | Unknown | |
status | Unknown | |
third_party_description | Unknown | |
url_domain | Unknown |
scan_delta_removed_cookie
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
scan_delta_id | Unknown | PKFK |
category_id | Unknown | |
color | Unknown | |
cookie_category | Unknown | |
description | Unknown | |
expiry_date | Unknown | |
expiry_unit | Unknown | |
first_party | Unknown | |
host | Unknown | |
host_description | Unknown | |
is_behind_login | Unknown | |
is_http_only | Unknown | |
is_new_found | Unknown | |
is_newly_added | Unknown | |
is_secure | Unknown | |
is_session | Unknown | |
name | Unknown | |
path | Unknown | |
purpose | Unknown | |
status | Unknown | |
third_party_description | Unknown | |
url_domain | Unknown |
scan_delta
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
web_scan_domain_id | Unknown | PK |
web_scan_id | Unknown | PK |
source_scan_id | Unknown | |
target_scan_date | Instant | |
target_scan_deleted | Unknown | |
target_scan_id | Unknown |
organization_children
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
organization_id | Unknown | PKFK |
children | Json | |
default_approver | Unknown | |
default_language_code | Unknown | |
description | Unknown | |
external_id | Unknown | |
name | Unknown | |
parent_external_id | Unknown |
organization
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
parent_id | Unknown | FK |
default_approver | Unknown | |
default_language_code | Unknown | |
description | Unknown | |
external_id | Unknown | |
name | Unknown | |
parent_external_id | Unknown |
purpose_preference
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_date | Instant | |
default_language | Unknown | |
description | Unknown | |
display_as | Unknown | |
is_disabled | Boolean | |
is_required | Boolean | |
languages | Json | |
name | Unknown | |
number_of_languages | Unknown | |
number_of_options | Unknown | |
options | Json | |
organizations | Json | |
selection_type | Unknown | |
total_linked_active_purposes | Unknown | |
updated_date | Instant |
transaction_custom_preference
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
transaction_id | Unknown | PKFK |
choices | Json | |
options | Json |
transaction_topic
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
transaction_id | Unknown | PKFK |
type | Unknown |
transaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
collection_point_uuid | Unknown | FK |
receipt_id | Unknown | FK |
activation_date | LocalDateTime | |
auto_generated | Unknown | |
collection_point_privacy_notices | Json | |
consent_creation_date | LocalDateTime | |
consent_date | LocalDateTime | |
created_by | Unknown | |
double_opt_in | Boolean | |
expiry_date | LocalDateTime | |
guid | Unknown | |
identifier | Unknown | |
interaction_date | LocalDateTime | |
is_test | Boolean | |
issue_date | LocalDateTime | |
purpose_privacy_notices | Json | |
type | Unknown | |
withdrawal_date | LocalDateTime | |
withdrawn_by | Unknown | |
custom_attributes_** |
service_scan_result
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
added | Unknown | |
category | Unknown | |
change_since_previous_scan | Unknown | |
description | Unknown | |
location | Unknown | |
privacy_policy | Unknown | |
removed | Unknown | |
service_name | Unknown | |
vendor | Unknown | |
web_scan_domain_id | Unknown | |
web_scan_id | Unknown |
data_subject_purpose_custom_preference
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
data_subject_id | Unknown | PKFK |
data_subject_purpose_id | Unknown | PKFK |
name | Unknown | |
options | Json |
data_subject_purpose_topic
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
data_subject_id | Unknown | PKFK |
data_subject_purpose_id | Unknown | PKFK |
is_consented | Boolean | |
name | Unknown |
data_subject_purpose
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
data_subject_id | Unknown | PKFK |
last_receipt_id | Unknown | FK |
last_transaction_collection_point_id | Unknown | FK |
attributes | Json | |
consent_date | LocalDateTime | |
expiry_date | LocalDateTime | |
first_transaction_date | LocalDateTime | |
geo_location_country | Unknown | |
geo_location_data_subject_id | Unknown | |
geo_location_receipt_id | Unknown | |
geo_location_state | Unknown | |
geo_location_state_name | Unknown | |
group_effective_id | Unknown | |
group_effective_status | Unknown | |
last_interaction_date | LocalDateTime | |
last_transaction_date | LocalDateTime | |
last_updated_date | LocalDateTime | |
name | Unknown | |
purpose_note | Unknown | |
status | Unknown | |
version | Unknown | |
withdrawal_date | LocalDateTime |
data_subject_data_element
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
data_subject_id | Unknown | PKFK |
is_dnc | Boolean | |
is_linked | Boolean | |
name | Unknown | |
value | Unknown |
data_subject_notice
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
data_subject_id | Unknown | PKFK |
collection_point_id | Unknown | |
collection_point_name | Unknown | |
collection_point_version | Unknown | |
guid | Unknown | |
name | Unknown | |
notice_type | Unknown | |
privacy_notice_version | Unknown | |
privacy_notice_version_id | Unknown | |
privacy_notice_version_name | Unknown | |
purposes | Json | |
type | Unknown | |
url | Unknown |
data_subject
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
link_token | Unknown | FK |
created_date | LocalDateTime | |
identifier | Unknown | |
last_updated_date | LocalDateTime | |
latest_geo_location_country | Unknown | |
latest_geo_location_data_subject_id | Unknown | |
latest_geo_location_receipt_id | Unknown | |
latest_geo_location_state | Unknown | |
latest_geo_location_state_name | Unknown | |
pref_language | Unknown | |
test_data_subject | Boolean |