# OneTrust schema ERD

Table and field reference for the Fivetran OneTrust connector.

## 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 | PK, FK |
| preference_center_id | Unknown | PK, FK |
| 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 | PK, FK |
| preference_center_id | Unknown | PK, FK |
| preference_center_schema_notification_purpose_id | Unknown | PK, FK |
| 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 | PK, FK |
| preference_center_id | Unknown | PK, FK |
| preference_center_schema_notification_purpose_id | Unknown | PK, FK |
| 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 | PK, FK |
| preference_center_id | Unknown | PK, FK |
| preference_center_schema_notification_purpose_id | Unknown | PK, FK |
| languages | Json |  |
| name | Unknown |  |

### preference_center_schema_notification_purpose

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| preference_center_id | Unknown | PK, FK |
| 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 | PK, FK |
| preference_center_id | Unknown | PK, FK |
| preference_center_schema_page_id | Unknown | PK, FK |
| 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 | PK, FK |
| preference_center_id | Unknown | PK, FK |
| preference_center_schema_page_id | Unknown | PK, FK |
| preference_center_schema_page_section_id | Unknown | PK, FK |
| 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 | PK, FK |
| preference_center_id | Unknown | PK, FK |
| preference_center_schema_page_id | Unknown | PK, FK |
| 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 | PK, FK |
| preference_center_id | Unknown | PK, FK |
| 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 | PK, FK |
| consent_group_id | Unknown | PK, FK |
| effective_status | Unknown |  |
| status | Unknown |  |
| version | Unknown |  |

### consent_group_data_subject

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| consent_group_id | Unknown | PK, FK |
| identifier | Unknown |  |

### consent_group_purpose_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| consent_group_id | Unknown | PK, FK |
| 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 | PK, FK |
| id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| display | Unknown |  |
| is_primary | Boolean |  |
| reference | Unknown |  |
| type | Unknown |  |

### users_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| users_id | Unknown | PK, FK |
| 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 | PK, FK |
| receipt_purpose_custom_preference_id | Unknown | PK, FK |
| receipt_purpose_id | Unknown | PK, FK |
| 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 | PK, FK |
| receipt_purpose_id | Unknown | PK, FK |
| custom_preference_options | Json |  |
| display_as | Unknown |  |
| name | Unknown |  |

### receipt_purpose_topic

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| receipt_id | Unknown | PK, FK |
| receipt_purpose_id | Unknown | PK, FK |
| integration_key | Unknown |  |
| languages | Json |  |
| name | Unknown |  |

### receipt_purpose

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| receipt_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| purpose_version_custom_preference_id | Unknown | PK, FK |
| purpose_version_index | Unknown | PK, FK |
| 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 | PK, FK |
| purpose_version_index | Unknown | PK, FK |
| custom_preference_options | Json |  |
| display_as | Unknown |  |
| name | Unknown |  |

### purpose_version_topic

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purpose_id | Unknown | PK, FK |
| purpose_version_index | Unknown | PK, FK |
| integration_key | Unknown |  |
| languages | Json |  |
| name | Unknown |  |

### purpose_version

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purpose_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| collection_point_purpose_id | Unknown | PK, FK |
| 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 | PK, FK |
| collection_point_purpose_id | Unknown | PK, FK |
| can_delete | Boolean |  |
| integration_key | Unknown |  |
| name | Unknown |  |

### collection_point_purpose

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| collection_point_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| choices | Json |  |
| options | Json |  |

### transaction_topic

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| 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 | PK, FK |
| data_subject_purpose_id | Unknown | PK, FK |
| name | Unknown |  |
| options | Json |  |

### data_subject_purpose_topic

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| data_subject_id | Unknown | PK, FK |
| data_subject_purpose_id | Unknown | PK, FK |
| is_consented | Boolean |  |
| name | Unknown |  |

### data_subject_purpose

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| data_subject_id | Unknown | PK, FK |
| 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 | PK, FK |
| is_dnc | Boolean |  |
| is_linked | Boolean |  |
| name | Unknown |  |
| value | Unknown |  |

### data_subject_notice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| data_subject_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- preference_center_schema_language(_fivetran_id) → preference_center_schema(_fivetran_id)
- preference_center_schema_language(preference_center_id) → preference_center_schema(preference_center_id)
- preference_center_schema_notification_purpose_custom_preference(preference_center_schema_notification_purpose_id) → preference_center_schema_notification_purpose(id)
- preference_center_schema_notification_purpose_custom_preference(_fivetran_id) → preference_center_schema_notification_purpose(_fivetran_id)
- preference_center_schema_notification_purpose_custom_preference(preference_center_id) → preference_center_schema_notification_purpose(preference_center_id)
- preference_center_schema_notification_purpose_language(preference_center_schema_notification_purpose_id) → preference_center_schema_notification_purpose(id)
- preference_center_schema_notification_purpose_language(_fivetran_id) → preference_center_schema_notification_purpose(_fivetran_id)
- preference_center_schema_notification_purpose_language(preference_center_id) → preference_center_schema_notification_purpose(preference_center_id)
- preference_center_schema_notification_purpose_topic(preference_center_schema_notification_purpose_id) → preference_center_schema_notification_purpose(id)
- preference_center_schema_notification_purpose_topic(_fivetran_id) → preference_center_schema_notification_purpose(_fivetran_id)
- preference_center_schema_notification_purpose_topic(preference_center_id) → preference_center_schema_notification_purpose(preference_center_id)
- preference_center_schema_notification_purpose(_fivetran_id) → preference_center_schema(_fivetran_id)
- preference_center_schema_notification_purpose(preference_center_id) → preference_center_schema(preference_center_id)
- preference_center_schema_page_language(preference_center_schema_page_id) → preference_center_schema_page(id)
- preference_center_schema_page_language(_fivetran_id) → preference_center_schema_page(_fivetran_id)
- preference_center_schema_page_language(preference_center_id) → preference_center_schema_page(preference_center_id)
- preference_center_schema_page_section_notification_purpose(preference_center_schema_page_section_id) → preference_center_schema_page_section(id)
- preference_center_schema_page_section_notification_purpose(preference_center_schema_page_id) → preference_center_schema_page_section(preference_center_schema_page_id)
- preference_center_schema_page_section_notification_purpose(_fivetran_id) → preference_center_schema_page_section(_fivetran_id)
- preference_center_schema_page_section_notification_purpose(preference_center_id) → preference_center_schema_page_section(preference_center_id)
- preference_center_schema_page_section(preference_center_schema_page_id) → preference_center_schema_page(id)
- preference_center_schema_page_section(_fivetran_id) → preference_center_schema_page(_fivetran_id)
- preference_center_schema_page_section(preference_center_id) → preference_center_schema_page(preference_center_id)
- preference_center_schema_page(_fivetran_id) → preference_center_schema(_fivetran_id)
- preference_center_schema_page(preference_center_id) → preference_center_schema(preference_center_id)
- preference_center_schema(preference_center_id) → preference_center(id)
- consent_group_data_subject_purpose(consent_group_data_subject_id) → consent_group_data_subject(id)
- consent_group_data_subject_purpose(consent_group_id) → consent_group_data_subject(consent_group_id)
- consent_group_data_subject(consent_group_id) → consent_group(id)
- consent_group_purpose_rule(consent_group_id) → consent_group(id)
- data_subject_group_primary_data_subject(id) → data_subject(id)
- data_subject_group_primary_data_subject(data_subject_group_id) → data_subject_group(id)
- data_subject_group(primary_data_subject_id) → data_subject(id)
- user_group(created_by) → login_history(id)
- user_group(last_modified_by) → login_history(id)
- resource_schema_extension(resource_id) → resource(id)
- users_email(users_id) → users(id)
- users_group(users_id) → users(id)
- receipt_purpose_custom_preference_language(receipt_purpose_custom_preference_id) → receipt_purpose_custom_preference(id)
- receipt_purpose_custom_preference_language(receipt_purpose_id) → receipt_purpose_custom_preference(receipt_purpose_id)
- receipt_purpose_custom_preference_language(receipt_id) → receipt_purpose_custom_preference(receipt_id)
- receipt_purpose_custom_preference(receipt_purpose_id) → receipt_purpose(id)
- receipt_purpose_custom_preference(receipt_id) → receipt_purpose(receipt_id)
- receipt_purpose_topic(receipt_purpose_id) → receipt_purpose(id)
- receipt_purpose_topic(receipt_id) → receipt_purpose(receipt_id)
- receipt_purpose(transaction_id) → transaction(id)
- receipt_purpose(receipt_id) → receipt(id)
- receipt_rule_evaluation_result(receipt_id) → receipt(id)
- receipt(organization_id) → organization(id)
- receipt(collection_point_uuid) → collection_point(id)
- schema_attribute(schema_id) → schema(id)
- inventories(organization_id) → organization(id)
- purpose_version_custom_preference_language(purpose_version_custom_preference_id) → purpose_version_custom_preference(id)
- purpose_version_custom_preference_language(purpose_version_index) → purpose_version_custom_preference(purpose_version_index)
- purpose_version_custom_preference_language(purpose_id) → purpose_version_custom_preference(purpose_id)
- purpose_version_custom_preference(purpose_version_index) → purpose_version(index)
- purpose_version_custom_preference(purpose_id) → purpose_version(purpose_id)
- purpose_version_topic(purpose_version_index) → purpose_version(index)
- purpose_version_topic(purpose_id) → purpose_version(purpose_id)
- purpose_version(purpose_id) → purpose(id)
- link_token(data_subject_id) → data_subject(id)
- service_provider_configuration_authentication_scheme(service_provider_configuration_fivetran_id) → service_provider_configuration(_fivetran_id)
- collection_point_purpose_custom_preference(collection_point_purpose_id) → collection_point_purpose(id)
- collection_point_purpose_custom_preference(collection_point_id) → collection_point_purpose(collection_point_id)
- collection_point_purpose_topic(collection_point_purpose_id) → collection_point_purpose(id)
- collection_point_purpose_topic(collection_point_id) → collection_point_purpose(collection_point_id)
- collection_point_purpose(collection_point_id) → collection_point(id)
- collection_point(organization_id) → organization(id)
- groups_member(groups_id) → groups(id)
- form_scan_result_form_data_field(form_scan_result_id) → form_scan_result(id)
- scan_delta_added_cookie(scan_delta_id) → scan_delta(id)
- scan_delta_removed_cookie(scan_delta_id) → scan_delta(id)
- organization_children(organization_id) → organization(id)
- organization(parent_id) → organization(id)
- transaction_custom_preference(transaction_id) → transaction(id)
- transaction_topic(transaction_id) → transaction(id)
- transaction(receipt_id) → receipt(id)
- transaction(collection_point_uuid) → collection_point(id)
- data_subject_purpose_custom_preference(data_subject_purpose_id) → data_subject_purpose(id)
- data_subject_purpose_custom_preference(data_subject_id) → data_subject_purpose(data_subject_id)
- data_subject_purpose_topic(data_subject_purpose_id) → data_subject_purpose(id)
- data_subject_purpose_topic(data_subject_id) → data_subject_purpose(data_subject_id)
- data_subject_purpose(last_transaction_collection_point_id) → collection_point(id)
- data_subject_purpose(last_receipt_id) → receipt(id)
- data_subject_purpose(data_subject_id) → data_subject(id)
- data_subject_data_element(data_subject_id) → data_subject(id)
- data_subject_notice(data_subject_id) → data_subject(id)
- data_subject(link_token) → link_token(id)