# Drata schema ERD

Table and field reference for the Fivetran Drata connector.

## Table & Field Reference

### trustcenter_access_request

| Column | Type | Keys |
| --- | --- | --- |
| request_id | Unknown | PK |
| company | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| expiration_date | Unknown |  |
| flow_type | Unknown |  |
| is_auto_approved | Unknown |  |
| lastname | Unknown |  |
| name | Unknown |  |
| reviewed_at | Unknown |  |
| status | Unknown |  |

### workspace_framework

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| active_logo | Unknown |  |
| bg_color | Unknown |  |
| color | Unknown |  |
| controls_enabled | Unknown |  |
| created_at | Unknown |  |
| custom_framework_id | Unknown |  |
| description | Unknown |  |
| enabled_at | Unknown |  |
| framework_enabled | Unknown |  |
| has_level | Unknown |  |
| inactive_logo | Unknown |  |
| is_ready | Unknown |  |
| label | Unknown |  |
| level_label | Unknown |  |
| long_description | Unknown |  |
| name | Unknown |  |
| num_in_scope_requirement | Unknown |  |
| num_ready_in_scope_requirement | Unknown |  |
| privacy | Unknown |  |
| product_framework_enabled | Unknown |  |
| selected_level | Unknown |  |
| slug | Unknown |  |
| tags | Unknown |  |
| total_enabled_control | Unknown |  |
| total_in_scope_control | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### workspace

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| how_it_works | Unknown |  |
| logo | Unknown |  |
| name | Unknown |  |
| primary_ | Unknown |  |
| url | Unknown |  |

### control_external_evidence

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| control_id | Unknown | PK, FK |
| created_at | Unknown |  |
| description | Unknown |  |
| file | Unknown |  |
| is_expired | Unknown |  |
| name | Unknown |  |
| renewal_date | Unknown |  |
| renewal_schedule_type | Unknown |  |
| url | Unknown |  |

### user_identities_infrastruture

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| connection_id | Unknown | FK |
| service_account_designator | Unknown | FK |
| admin_access | Unknown |  |
| connected_at | Instant |  |
| created_at | Unknown |  |
| db_access | Unknown |  |
| disconnected_at | Unknown |  |
| email | Unknown |  |
| has_mfa | Unknown |  |
| identity_id | Unknown |  |
| last_checked_at | Unknown |  |
| service_account | Unknown |  |
| service_account_reason | Unknown |  |
| updated_at | Unknown |  |
| username | Unknown |  |

### policy_version_grace_period_sla

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| policy_id | Unknown | PK, FK |
| policy_version_id | Unknown | PK, FK |
| created_at | Instant |  |
| grace_period | Unknown |  |
| label | Unknown |  |
| updated_at | Instant |  |

### policy_version_p_3_matrix_sla

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| policy_id | Unknown | PK, FK |
| policy_version_id | Unknown | PK, FK |
| created_at | Instant |  |
| label | Unknown |  |
| time_frame | Unknown |  |
| updated_at | Instant |  |

### policy_version_week_time_frame_sla

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| policy_id | Unknown | PK, FK |
| policy_version_id | Unknown | PK, FK |
| created_at | Instant |  |
| label | Unknown |  |
| time_frame | Unknown |  |
| updated_at | Instant |  |

### policy_version

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| policy_id | Unknown | PK, FK |
| owner_id | Unknown | FK |
| approved_at | Instant |  |
| changes_explanation | Unknown |  |
| created_at | Instant |  |
| current | Unknown |  |
| description | Unknown |  |
| policy_version_status | Unknown |  |
| published_at | Instant |  |
| renewal_date | LocalDate |  |
| require_acknowledgment | Unknown |  |
| sub_version | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |
| version | Unknown |  |

### connection_provider_type

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| connection_id | Unknown | FK |
| is_enabled | Unknown |  |
| value | Unknown |  |

### connection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| alias_updated_at | Unknown |  |
| authorized | Unknown |  |
| client_alias | Unknown |  |
| client_id | Unknown |  |
| client_type | Unknown |  |
| code | Unknown |  |
| connected | Unknown |  |
| connected_at | Instant |  |
| deleted_at | Unknown |  |
| failed_at | Unknown |  |
| key | Unknown |  |
| manually_updated_at | Unknown |  |
| state | Unknown |  |
| workspace | Json |  |
| write_access_enabled | Unknown |  |

### risk_note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| risk_id | Unknown | PK, FK |
| risk_register_id | Unknown | PK, FK |
| owner_id | Unknown | FK |
| comment | Unknown |  |
| created_at | Instant |  |
| updated_at | Instant |  |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| role_name | Unknown |  |

### user_background_check

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| case_id | Unknown |  |
| case_invitation_id | Unknown |  |
| created_at | Unknown |  |
| invitation_email | Unknown |  |
| linked_at | Unknown |  |
| manual_check_date | Unknown |  |
| manually_check_url | Unknown |  |
| out_of_scope_at | Unknown |  |
| out_of_scope_reason | Unknown |  |
| report_data | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| users | Json |  |

### user_identity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| connection_id | Unknown | FK |
| connected_at | Unknown |  |
| disconnected_at | Unknown |  |
| first_name | Unknown |  |
| has_idp | Unknown |  |
| has_mfa | Unknown |  |
| identity_id | Unknown |  |
| is_contractor | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| manager_id | Unknown |  |
| manager_name | Unknown |  |
| secondary_email | Unknown |  |
| separated_at | Unknown |  |
| started_at | Unknown |  |
| username | Unknown |  |
| users | Json |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| avatar_url | Unknown |  |
| created_at | Unknown |  |
| drata_terms_agreed_at | Unknown |  |
| email | Unknown |  |
| entry_id | Unknown |  |
| first_name | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| updated_at | Unknown |  |

### monitor_instance_exclusion

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| test_id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| connection_id | Unknown | FK |
| exclusion_designator_id | Unknown | FK |
| created_at | Instant |  |
| exclusion_reason | Unknown |  |
| target_id | Unknown |  |
| target_name | Unknown |  |
| updated_at | Instant |  |

### trustcenter_monitor_control

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| category | Unknown |  |
| control_code | Unknown |  |
| description | Unknown |  |
| is_enabled | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |

### user_identities_version_control

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| connection_id | Unknown | FK |
| service_account_designator | Unknown | FK |
| connected_at | Instant |  |
| created_at | Unknown |  |
| disconnected_at | Unknown |  |
| email | Unknown |  |
| has_mfa | Unknown |  |
| identity_id | Unknown |  |
| last_checked_at | Unknown |  |
| push_production_code_access | Unknown |  |
| service_account | Unknown |  |
| service_account_reason | Unknown |  |
| updated_at | Unknown |  |
| username | Unknown |  |
| write_access | Unknown |  |

### device_compliance_check

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| device_id | Unknown | PK, FK |
| check_frequency | Unknown |  |
| created_at | Unknown |  |
| expires_at | Unknown |  |
| last_checked_at | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### device_identifier

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| device_id | Unknown | PK, FK |
| created_at | Unknown |  |
| identifier | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### device_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| device_id | Unknown | PK, FK |
| created_at | Unknown |  |
| file_url | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### device

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | FK |
| user_id | Unknown | FK |
| antivirus_enabled | Unknown |  |
| antivirus_explanation | Unknown |  |
| apps_count | Unknown |  |
| auto_update_enabled | Unknown |  |
| auto_update_explanation | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| encryption_enabled | Unknown |  |
| encryption_explanation | Unknown |  |
| external_id | Unknown |  |
| firewall_enabled | Unknown |  |
| firewall_explanation | Unknown |  |
| gate_keeper_enabled | Unknown |  |
| is_device_compliant | Unknown |  |
| last_checked_at | Unknown |  |
| mac_address | Unknown |  |
| model | Unknown |  |
| os_version | Unknown |  |
| password_manager_enabled | Unknown |  |
| password_manager_explanation | Unknown |  |
| personnel_id | Unknown |  |
| screen_lock_explanation | Unknown |  |
| screen_lock_time | Unknown |  |
| serial_number | Unknown |  |
| source_type | Unknown |  |
| updated_at | Unknown |  |

### vendor_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_id | Unknown | PK, FK |
| created_at | Unknown |  |
| file_url | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### vendor_review_trust_service_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_id | Unknown | PK, FK |
| vendor_review_id | Unknown | PK, FK |
| category | Unknown |  |

### vendor_review_user_control

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_id | Unknown | PK, FK |
| vendor_review_id | Unknown | PK, FK |
| in_place | Unknown |  |
| name | Unknown |  |

### vendor_review_service

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_id | Unknown | PK, FK |
| vendor_review_id | Unknown | PK, FK |
| name | Unknown |  |

### vendor_review_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_id | Unknown | PK, FK |
| vendor_review_id | Unknown | PK, FK |
| city | Unknown |  |
| state_country | Unknown |  |

### vendor_review_finding

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_id | Unknown | PK, FK |
| vendor_review_id | Unknown | PK, FK |
| description | Unknown |  |

### vendor_review

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_id | Unknown | PK, FK |
| cpa_firm | Unknown |  |
| cpa_procedure_performed | Unknown |  |
| encompass_business_need | Unknown |  |
| follow_up_activity | Unknown |  |
| has_material_impact | Unknown |  |
| report_issue_date | Unknown |  |
| report_opinion | Unknown |  |
| review_date | Unknown |  |
| reviewer | Unknown |  |
| soc_report | Unknown |  |
| soc_report_type_1 | Unknown |  |
| soc_report_type_2 | Unknown |  |
| soc_type_1_end_date | Unknown |  |
| soc_type_1_start_date | Unknown |  |
| soc_type_2_end_date | Unknown |  |
| soc_type_2_start_date | Unknown |  |
| subservice_organization | Unknown |  |
| subservice_organization_procedure_performed | Unknown |  |
| subservice_organization_using_inclusive_method | Unknown |  |
| updated_at | Unknown |  |

### vendor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| account_manager_email | Unknown |  |
| account_manager_name | Unknown |  |
| archived_at | Unknown |  |
| category | Unknown |  |
| confirmed_at | Unknown |  |
| created_at | Unknown |  |
| critical | Unknown |  |
| data_stored | Unknown |  |
| has_pii | Unknown |  |
| is_compliance_review_required | Unknown |  |
| is_sub_processor | Unknown |  |
| is_sub_processor_active | Unknown |  |
| last_questionnaire | Unknown |  |
| location | Unknown |  |
| logo_url | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| password_mfa_enabled | Unknown |  |
| password_min_length | Unknown |  |
| password_policy | Unknown |  |
| password_requires_min_length | Unknown |  |
| password_requires_number | Unknown |  |
| password_requires_symbol | Unknown |  |
| privacy_url | Unknown |  |
| renewal_date | Unknown |  |
| renewal_date_status | Unknown |  |
| renewal_schedule_type | Unknown |  |
| risk | Unknown |  |
| services_provided | Unknown |  |
| terms_url | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### policy_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| policy_id | Unknown | PK, FK |
| created_at | Instant |  |
| external_id | Unknown |  |
| name | Unknown |  |
| source | Unknown |  |
| updated_at | Instant |  |

### policy_control

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| policy_id | Unknown | PK, FK |
| code | Unknown |  |
| created_at | Instant |  |
| description | Unknown |  |
| is_ready | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |

### policy_week_time_frame_sla

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| policy_id | Unknown | PK, FK |
| created_at | Instant |  |
| label | Unknown |  |
| time_frame | Unknown |  |
| updated_at | Instant |  |

### policy_grace_period_sla

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| policy_id | Unknown | PK, FK |
| created_at | Instant |  |
| grace_period | Unknown |  |
| label | Unknown |  |
| updated_at | Instant |  |

### policy_p_3_matrix_sla

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| policy_id | Unknown | PK, FK |
| created_at | Instant |  |
| label | Unknown |  |
| time_frame | Unknown |  |
| updated_at | Instant |  |

### policy

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| approved_at | Instant |  |
| created_at | Instant |  |
| current_version_id | Unknown |  |
| name | Unknown |  |
| published_at | Instant |  |
| renewal_date | Instant |  |
| scope | Unknown |  |
| status | Unknown |  |
| sub_version | Unknown |  |
| updated_at | Instant |  |
| version | Unknown |  |

### trustcenter_private_access

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| flow_type | Unknown |  |
| id | Unknown |  |
| name | Unknown |  |

### venodr_questionnaire

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_id | Unknown | PK, FK |
| completed_by | Unknown | FK |
| date_sent | Unknown |  |
| is_completed | Unknown |  |
| is_manual_upload | Unknown |  |
| recipient_email | Unknown |  |
| response_id | Unknown |  |

### monitoring_test_fail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| test_id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| account_name | Unknown |  |
| client_id | Unknown |  |
| organizational_unit_id | Unknown |  |
| provider_name | Unknown |  |
| region | Unknown |  |
| resource_arn | Unknown |  |
| resource_name | Unknown |  |

### control_owner

| Column | Type | Keys |
| --- | --- | --- |
| control_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| created_at | Instant |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| updated_at | Instant |  |

### control_mapped_requirement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| control_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| additional_info | Unknown |  |
| additional_info_2 | Unknown |  |
| additional_info_3 | Unknown |  |
| archived_at | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| external_id | Unknown |  |
| framework_name | Unknown |  |
| framework_pill | Unknown |  |
| framework_slug | Unknown |  |
| framework_tag | Unknown |  |
| long_description | Unknown |  |
| name | Unknown |  |
| rationale | Unknown |  |
| updated_at | Unknown |  |

### control_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| control_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### control

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| activity | Unknown |  |
| archived_at | Instant |  |
| code | Unknown |  |
| control_template_id | Unknown |  |
| created_at | Instant |  |
| description | Unknown |  |
| flag_has_evidence | Unknown |  |
| flag_has_owner | Unknown |  |
| flag_has_policy | Unknown |  |
| flag_has_ticket | Unknown |  |
| flag_is_monitored | Unknown |  |
| flag_is_ready | Unknown |  |
| framework_tag | Json |  |
| name | Unknown |  |
| question | Unknown |  |
| slug | Unknown |  |
| topic | Json |  |
| updated_at | Instant |  |

### monitor_instance

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| monitor_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| check_result_status | Unknown |  |
| collection_description | Unknown |  |
| created_at | Instant |  |
| updated_at | Instant |  |

### monitor_control

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| monitor_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| code | Unknown |  |
| created_at | Instant |  |
| description | Unknown |  |
| is_ready | Boolean |  |
| name | Unknown |  |
| updated_at | Instant |  |

### monitor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| disabled_by_user_id | Unknown | FK |
| check_result_status | Unknown |  |
| created_at | Instant |  |
| description | Unknown |  |
| name | Unknown |  |
| test_id | Unknown |  |
| updated_at | Instant |  |

### risk_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| risk_id | Unknown | PK, FK |
| risk_register_id | Unknown | PK, FK |
| created_at | Instant |  |
| download_url | Unknown |  |
| name | Unknown |  |

### risk_register_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| risk_register_id | Unknown | PK, FK |

### risk_register

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| description | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |

### personnel_compliance_test

| Column | Type | Keys |
| --- | --- | --- |
| monitor_id | Unknown | PK, FK |
| personnel_id | Unknown | PK, FK |
| autopilot_task_type | Unknown |  |
| check_result_status | Unknown |  |
| check_status | Unknown |  |
| control_test_instance_id | Unknown |  |
| last_check | Unknown |  |
| name | Unknown |  |
| test_id | Unknown |  |

### personnel_compliance_check

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| personnel_id | Unknown | PK, FK |
| check_frequency | Unknown |  |
| compliant | Unknown |  |
| created_at | Unknown |  |
| expires_at | Unknown |  |
| last_checked_at | Unknown |  |
| types | Unknown |  |
| updated_at | Unknown |  |

### personnel_device

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| personnel_id | Unknown | PK, FK |

### personnel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| reason_provider_id | Unknown | FK |
| user_id | Unknown | FK |
| agent_enabled | Unknown |  |
| apps_count | Unknown |  |
| apps_count_last_checked_at | Unknown |  |
| background_check_excluded | Unknown |  |
| background_check_excluded_reason | Unknown |  |
| created_at | Unknown |  |
| data_agent_version | Unknown |  |
| data_created_at | Unknown |  |
| data_graphics | Unknown |  |
| data_hdd_size | Unknown |  |
| data_lastchecked_at | Unknown |  |
| data_mac_address | Unknown |  |
| data_memory | Unknown |  |
| data_os_version | Unknown |  |
| data_processor | Unknown |  |
| data_screen_lock_time | Unknown |  |
| data_serial_number | Unknown |  |
| data_updated_at | Unknown |  |
| devices_count | Unknown |  |
| devices_failing_compliance_count | Unknown |  |
| employment_status | Unknown |  |
| manual_upload_enabled | Unknown |  |
| not_human_reason | Unknown |  |
| os_version | Unknown |  |
| separation_date | Unknown |  |
| serial_number | Unknown |  |
| start_date | LocalDate |  |
| status_updated_at | Unknown |  |
| updated_at | Unknown |  |

### risk_control

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| risk_id | Unknown | PK, FK |
| risk_register_id | Unknown | PK, FK |

### risk_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| risk_id | Unknown | PK, FK |
| risk_register_id | Unknown | PK, FK |
| created_at | Instant |  |
| name | Unknown |  |
| updated_at | Instant |  |

### risk_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| risk_id | Unknown | PK, FK |
| risk_register_id | Unknown | PK, FK |

### risk_reviewer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| risk_id | Unknown | PK, FK |
| risk_register_id | Unknown | PK, FK |
| created_at | Instant |  |
| updated_at | Instant |  |

### risk_ticket

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| risk_id | Unknown | PK, FK |
| risk_register_id | Unknown | PK, FK |
| created_at | Instant |  |
| external_ticket_id | Unknown |  |
| is_done | Unknown |  |
| updated_at | Instant |  |

### risk_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| risk_id | Unknown | PK, FK |
| risk_register_id | Unknown | PK, FK |
| completed_at | Instant |  |
| created_at | Instant |  |
| description | Unknown |  |
| due_date | LocalDate |  |
| title | Unknown |  |
| updated_at | Instant |  |

### risk_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| custom_field_id | Unknown | PK |
| risk_id | Unknown | PK, FK |
| risk_register_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### risk

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| risk_register_id | Unknown | PK, FK |
| anticipated_completion_date | Instant |  |
| completion_date | Instant |  |
| created_at | Instant |  |
| description | Unknown |  |
| impact | Unknown |  |
| likelihood | Unknown |  |
| residual_impact | Unknown |  |
| residual_likelihood | Unknown |  |
| residual_score | Unknown |  |
| risk_id | Unknown |  |
| score | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| treatment_details | Unknown |  |
| treatment_plan | Unknown |  |
| updated_at | Instant |  |

### trustcenter_private_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| type | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |

### asset_class_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | PK, FK |
| asset_class_type | Unknown |  |
| created_at | Unknown |  |
| updated_at | Unknown |  |

### asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| device_id | Unknown | FK |
| owner_id | Unknown | FK |
| approved_at | Unknown |  |
| asset_provider | Unknown |  |
| asset_reference_type | Unknown |  |
| asset_type | Unknown |  |
| company | Unknown |  |
| created_at | Instant |  |
| description | Unknown |  |
| employment_status | Unknown |  |
| external_id | Unknown |  |
| external_owner_id | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| removed_at | Unknown |  |
| unique_id | Unknown |  |
| updated_at | Instant |  |

## Relationships

- workspace_framework(workspace_id) → workspace(id)
- control_external_evidence(control_id) → control(id)
- user_identities_infrastruture(connection_id) → connection(id)
- user_identities_infrastruture(service_account_designator) → users(id)
- policy_version_grace_period_sla(policy_version_id) → policy_version(id)
- policy_version_grace_period_sla(policy_id) → policy(id)
- policy_version_p_3_matrix_sla(policy_version_id) → policy_version(id)
- policy_version_p_3_matrix_sla(policy_id) → policy(id)
- policy_version_week_time_frame_sla(policy_version_id) → policy_version(id)
- policy_version_week_time_frame_sla(policy_id) → policy(id)
- policy_version(owner_id) → users(id)
- policy_version(policy_id) → policy(id)
- connection_provider_type(connection_id) → connection(id)
- risk_note(owner_id) → users(id)
- risk_note(risk_id) → risk(id)
- risk_note(risk_register_id) → risk(risk_register_id)
- user_role(user_id) → users(id)
- user_background_check(user_id) → users(id)
- user_identity(connection_id) → connection(id)
- user_identity(user_id) → users(id)
- monitor_instance_exclusion(connection_id) → connection(id)
- monitor_instance_exclusion(exclusion_designator_id) → users(id)
- monitor_instance_exclusion(workspace_id) → workspace(id)
- user_identities_version_control(connection_id) → connection(id)
- user_identities_version_control(service_account_designator) → users(id)
- device_compliance_check(device_id) → device(id)
- device_identifier(device_id) → device(id)
- device_document(device_id) → device(id)
- device(user_id) → users(id)
- device(asset_id) → asset(id)
- vendor_document(vendor_id) → vendor(id)
- vendor_review_trust_service_category(vendor_review_id) → vendor_review(id)
- vendor_review_trust_service_category(vendor_id) → vendor_review(vendor_id)
- vendor_review_user_control(vendor_review_id) → vendor_review(id)
- vendor_review_user_control(vendor_id) → vendor_review(vendor_id)
- vendor_review_service(vendor_review_id) → vendor_review(id)
- vendor_review_service(vendor_id) → vendor_review(vendor_id)
- vendor_review_location(vendor_review_id) → vendor_review(id)
- vendor_review_location(vendor_id) → vendor_review(vendor_id)
- vendor_review_finding(vendor_review_id) → vendor_review(id)
- vendor_review_finding(vendor_id) → vendor_review(vendor_id)
- vendor_review(vendor_id) → vendor(id)
- vendor(user_id) → users(id)
- policy_group(policy_id) → policy(id)
- policy_control(id) → control(id)
- policy_control(policy_id) → policy(id)
- policy_week_time_frame_sla(policy_id) → policy(id)
- policy_grace_period_sla(policy_id) → policy(id)
- policy_p_3_matrix_sla(policy_id) → policy(id)
- policy(owner_id) → users(id)
- venodr_questionnaire(completed_by) → users(id)
- venodr_questionnaire(vendor_id) → vendor(id)
- monitoring_test_fail(workspace_id) → workspace(id)
- control_owner(id) → users(id)
- control_owner(control_id) → control(id)
- control_owner(workspace_id) → control(workspace_id)
- control_mapped_requirement(control_id) → control(id)
- control_mapped_requirement(workspace_id) → workspace(id)
- control_custom_field(control_id) → control(id)
- control_custom_field(workspace_id) → workspace(id)
- control(workspace_id) → workspace(id)
- monitor_instance(monitor_id) → monitor(id)
- monitor_instance(workspace_id) → workspace(id)
- monitor_control(id) → control(id)
- monitor_control(monitor_id) → monitor(id)
- monitor_control(workspace_id) → workspace(id)
- monitor(disabled_by_user_id) → users(id)
- monitor(workspace_id) → workspace(id)
- risk_document(risk_id) → risk(id)
- risk_document(risk_register_id) → risk(risk_register_id)
- risk_register_owner(id) → users(id)
- risk_register_owner(risk_register_id) → risk_register(id)
- personnel_compliance_test(monitor_id) → monitor(id)
- personnel_compliance_test(personnel_id) → personnel(id)
- personnel_compliance_check(personnel_id) → personnel(id)
- personnel_device(id) → device(id)
- personnel_device(personnel_id) → personnel(id)
- personnel(user_id) → users(id)
- personnel(reason_provider_id) → users(id)
- risk_control(id) → control(id)
- risk_control(risk_id) → risk(id)
- risk_control(risk_register_id) → risk(risk_register_id)
- risk_category(risk_id) → risk(id)
- risk_category(risk_register_id) → risk(risk_register_id)
- risk_owner(id) → users(id)
- risk_owner(risk_id) → risk(id)
- risk_owner(risk_register_id) → risk(risk_register_id)
- risk_reviewer(id) → users(id)
- risk_reviewer(risk_id) → risk(id)
- risk_reviewer(risk_register_id) → risk(risk_register_id)
- risk_ticket(risk_id) → risk(id)
- risk_ticket(risk_register_id) → risk(risk_register_id)
- risk_task(risk_id) → risk(id)
- risk_task(risk_register_id) → risk(risk_register_id)
- risk_custom_field(risk_id) → risk(id)
- risk_custom_field(risk_register_id) → risk(risk_register_id)
- risk(risk_register_id) → risk_register(id)
- asset_class_type(asset_id) → asset(id)
- asset(device_id) → device(id)
- asset(owner_id) → users(id)