Drata
Explore the interactive ERD
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 | PKFK |
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 | PKFK |
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 | PKFK |
policy_version_id | Unknown | PKFK |
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 | PKFK |
policy_version_id | Unknown | PKFK |
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 | PKFK |
policy_version_id | Unknown | PKFK |
created_at | Instant | |
label | Unknown | |
time_frame | Unknown | |
updated_at | Instant |
policy_version
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
policy_id | Unknown | PKFK |
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 | PKFK |
risk_register_id | Unknown | PKFK |
owner_id | Unknown | FK |
comment | Unknown | |
created_at | Instant | |
updated_at | Instant |
user_role
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
role_name | Unknown |
user_background_check
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
created_at | Unknown | |
identifier | Unknown | |
type | Unknown | |
updated_at | Unknown |
device_document
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
device_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
vendor_review_id | Unknown | PKFK |
category | Unknown |
vendor_review_user_control
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
vendor_id | Unknown | PKFK |
vendor_review_id | Unknown | PKFK |
in_place | Unknown | |
name | Unknown |
vendor_review_service
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
vendor_id | Unknown | PKFK |
vendor_review_id | Unknown | PKFK |
name | Unknown |
vendor_review_location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
vendor_id | Unknown | PKFK |
vendor_review_id | Unknown | PKFK |
city | Unknown | |
state_country | Unknown |
vendor_review_finding
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
vendor_id | Unknown | PKFK |
vendor_review_id | Unknown | PKFK |
description | Unknown |
vendor_review
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
vendor_id | Unknown | PKFK |
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 | PKFK |
created_at | Instant | |
external_id | Unknown | |
name | Unknown | |
source | Unknown | |
updated_at | Instant |
policy_control
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
policy_id | Unknown | PKFK |
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 | PKFK |
created_at | Instant | |
label | Unknown | |
time_frame | Unknown | |
updated_at | Instant |
policy_grace_period_sla
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
policy_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
id | Unknown | PKFK |
workspace_id | Unknown | PKFK |
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 | PKFK |
workspace_id | Unknown | PKFK |
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 | PKFK |
workspace_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
control
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
workspace_id | Unknown | PKFK |
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 | PKFK |
workspace_id | Unknown | PKFK |
check_result_status | Unknown | |
collection_description | Unknown | |
created_at | Instant | |
updated_at | Instant |
monitor_control
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
monitor_id | Unknown | PKFK |
workspace_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
risk_register_id | Unknown | PKFK |
created_at | Instant | |
download_url | Unknown | |
name | Unknown |
risk_register_owner
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
risk_register_id | Unknown | PKFK |
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 | PKFK |
personnel_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
personnel_id | Unknown | PKFK |
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 | PKFK |
risk_id | Unknown | PKFK |
risk_register_id | Unknown | PKFK |
risk_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
risk_id | Unknown | PKFK |
risk_register_id | Unknown | PKFK |
created_at | Instant | |
name | Unknown | |
updated_at | Instant |
risk_owner
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
risk_id | Unknown | PKFK |
risk_register_id | Unknown | PKFK |
risk_reviewer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
risk_id | Unknown | PKFK |
risk_register_id | Unknown | PKFK |
created_at | Instant | |
updated_at | Instant |
risk_ticket
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
risk_id | Unknown | PKFK |
risk_register_id | Unknown | PKFK |
created_at | Instant | |
external_ticket_id | Unknown | |
is_done | Unknown | |
updated_at | Instant |
risk_task
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
risk_id | Unknown | PKFK |
risk_register_id | Unknown | PKFK |
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 | PKFK |
risk_register_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
risk
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
risk_register_id | Unknown | PKFK |
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 | PKFK |
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 |