Venminder
Explore the interactive ERD
Table & Field Reference
country
| Column | Type | Keys |
|---|---|---|
dialing_code | Unknown | PK |
abbreviation | Unknown | |
country | Unknown |
form_vendor_profile_expected_answer
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
form_vendor_profile_answer_key | Unknown | PKFK |
expected_answer | Unknown |
form_vendor_profile_answer
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
form_key | Unknown | FK |
form_product_profile_expected_answer
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
form_product_profile_answer_key | Unknown | PKFK |
expected_answer | Unknown |
form_product_profile_answer
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
form_key | Unknown | FK |
budget
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
vendor_profile_key | Unknown | PKFK |
amount | Unknown | |
end_date | Unknown | |
name | Unknown | |
start_date | Unknown |
contract_product
| Column | Type | Keys |
|---|---|---|
contract_key | Unknown | PKFK |
key | Unknown | PKFK |
status | Unknown |
contract
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
vendor_key | Unknown | FK |
auto_renewal_notice_days | Unknown | |
effective_date | Unknown | |
expiration_date | Unknown | |
is_perpetual | Unknown | |
name | Unknown | |
required_notification_dead_line | Unknown | |
status | Unknown |
onboarding_request_section_status
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
onboarding_request_requested_date | Unknown | PKFK |
onboarding_request_requestor_key | Unknown | PKFK |
approver_key | Unknown | |
approver_name | Unknown | |
assigned_to | Unknown | |
assigned_to_key | Unknown | |
is_required | Unknown | |
section_name | Unknown | |
status | Unknown | |
status_date | Unknown |
onboarding_request
| Column | Type | Keys |
|---|---|---|
requested_date | Unknown | PK |
requestor_key | Unknown | PK |
product_key | Unknown | FK |
vendor_key | Unknown | FK |
approved_or_declined_date | Unknown | |
deadline_date | Unknown | |
product_name | Unknown | |
relationship_key | Unknown | |
requestor_name | Unknown | |
status | Unknown | |
status_id | Unknown | |
vendor_name | Unknown | |
vmo_manager_key | Unknown | |
vmo_manager_name | Unknown |
oversight_task_product
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
oversight_task_key | Unknown | PKFK |
key | Unknown |
oversight_task_document
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
oversight_task_key | Unknown | PKFK |
key | Unknown |
oversight_task_comment
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
oversight_task_key | Unknown | PKFK |
comment | Unknown |
oversight_task
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
approver_key | Unknown | FK |
completed_by_key | Unknown | FK |
internal_reviewer_key | Unknown | FK |
owner_key | Unknown | FK |
vendor_key | Unknown | FK |
approval_status | Unknown | |
completed_date | Unknown | |
end_date | Unknown | |
external_reviewer | Unknown | |
external_reviewer_date | Unknown | |
internal_reviewer_date | Unknown | |
lifecycle | Unknown | |
offboarding_property_request_key | Unknown | |
onboarding_property_request_relationship_key | Unknown | |
owner_type | Unknown | |
requirement_key | Unknown | |
requirement_name | Unknown | |
review_result | Unknown | |
soc_type | Unknown | |
start_date | Unknown | |
task_status | Unknown |
request_answer_vendor_profile_expected_answer
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
request_answer_vendor_profile_answer_key | Unknown | PKFK |
expected_answer | Unknown |
request_answer_vendor_profile_answer
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
relationship_key | Unknown |
request_answer_product_profile_expected_answer
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
request_answer_product_profile_answer_key | Unknown | PKFK |
expected_answer | Unknown |
request_answer_product_profile_answer
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
relationship_key | Unknown |
vendor_profile_fourth_party
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
vendor_profile_key | Unknown | PKFK |
key | Unknown |
vendor_profile_third_party
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
vendor_profile_key | Unknown | PKFK |
key | Unknown |
vendor_profile_data_answer
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
vendor_profile_data_key | Unknown | PKFK |
vendor_profile_key | Unknown | PKFK |
answer | Unknown |
vendor_profile_data
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
vendor_profile_key | Unknown | PKFK |
answer_format | Unknown | |
data_field_key | Unknown | |
formatted_answer | Unknown | |
group_identity | Unknown | |
label | Unknown |
vendor_profile_open_requirement_product
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
vendor_profile_key | Unknown | PKFK |
vendor_profile_open_requirement_index | Unknown | PKFK |
key | Unknown |
vendor_profile_open_requirement
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
vendor_profile_key | Unknown | PKFK |
due_date | Unknown | |
key | Unknown | |
requirement_key | Unknown | |
task_owner_key | Unknown |
vendor_profile_product_contact_phone_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
vendor_profile_key | Unknown | PKFK |
vendor_profile_product_contact_index | Unknown | PKFK |
vendor_profile_product_key | Unknown | PKFK |
area_code | Unknown | |
extension | Unknown | |
prefix | Unknown | |
suffix | Unknown | |
type | Unknown |
vendor_profile_product_contact
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
vendor_profile_key | Unknown | PKFK |
vendor_profile_product_key | Unknown | PKFK |
contact_key | Unknown | |
email_address | Unknown | |
first_name | Unknown | |
is_primary | Unknown | |
is_primary_questionnaires | Unknown | |
key | Unknown | |
last_name | Unknown |
vendor_profile_product_data_answer
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
vendor_profile_key | Unknown | PKFK |
vendor_profile_product_data_key | Unknown | PKFK |
vendor_profile_product_key | Unknown | PKFK |
answer | Unknown |
vendor_profile_product_data
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
vendor_profile_key | Unknown | PKFK |
vendor_profile_product_key | Unknown | PKFK |
answer_format | Unknown | |
data_field_key | Unknown | |
formatted_answer | Unknown | |
group_identity | Unknown | |
label | Unknown |
vendor_profile_collaborator
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
vendor_profile_key | Unknown | PKFK |
vendor_profile_product_key | Unknown | PKFK |
key | Unknown |
vendor_profile_business_unit
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
vendor_profile_key | Unknown | PKFK |
vendor_profile_product_key | Unknown | PKFK |
business_unit | Unknown |
vendor_profile_product
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
vendor_profile_key | Unknown | PKFK |
assessment_last_completed | Unknown | |
assessment_next_due | Unknown | |
category | Unknown | |
inherent_assessment_approved_by | Unknown | |
inherent_assessment_performed_by | Unknown | |
inherent_risk | Unknown | |
inherent_risk_score | Unknown | |
is_active | Unknown | |
manager_key | Unknown | |
name | Unknown | |
residual_assessment_approved_by | Unknown | |
residual_assessment_performed_by | Unknown | |
residual_risk | Unknown | |
residual_risk_score | Unknown |
vendor_profile_contract
| Column | Type | Keys |
|---|---|---|
key | Unknown | PKFK |
vendor_profile_key | Unknown | PKFK |
vendor_profile
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
confidence_level | Unknown | |
confidence_level_comment | Unknown | |
contact_key | Unknown | |
has_vendor_spend_budget | Unknown | |
has_vendor_spend_detail | Unknown | |
is_critical | Unknown | |
is_fourth_party | Unknown | |
is_third_party | Unknown | |
name | Unknown |
vendor_profile_expected_answer
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
vendor_profile_answer_key | Unknown | PKFK |
vendor_profile_key | Unknown | PKFK |
expected_answer | Unknown |
vendor_profile_answer
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
vendor_profile_key | Unknown | PKFK |
product_profile_expected_answer
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
product_profile_answer_key | Unknown | PKFK |
vendor_profile_key | Unknown | PKFK |
expected_answer | Unknown |
product_profile_answer
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
vendor_profile_key | Unknown | PKFK |
vendor_onboarding_form_category
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
vendor_onboarding_form_key | Unknown | PKFK |
category | Unknown |
vendor_onboarding_form
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
last_edited_by_key | Unknown | FK |
is_active | Unknown | |
last_edited_by | Unknown | |
last_edited_date | Unknown | |
name | Unknown | |
type | Unknown |
vendor_onboarding_request_reason
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
is_custom_reason | Unknown | |
reason | Unknown |
client_info_vendor_product
| Column | Type | Keys |
|---|---|---|
client_info_vendor_key | Unknown | PK |
key | Unknown | PK |
created_date | Unknown | |
product_type | Unknown |
client_info_oversight_requirement
| Column | Type | Keys |
|---|---|---|
key | Unknown | PKFK |
applies_to_all_products | Unknown | |
label | Unknown |
user_phone_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_key | Unknown | PKFK |
area_code | Unknown | |
extension | Unknown | |
prefix | Unknown | |
suffix | Unknown | |
type | Unknown |
user_role
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
user_key | Unknown | PKFK |
is_custom | Unknown | |
name | Unknown |
users
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
created_by_user_key_or_description | Unknown | |
created_date | Unknown | |
email_address | Unknown | |
first_name | Unknown | |
full_name | Unknown | |
is_active | Unknown | |
is_enrolled | Unknown | |
last_name | Unknown |
client_info_risk_level
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
name | Unknown | |
score | Unknown |
client_info_value_list
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
data_key_field | Unknown | |
data_key_field_label | Unknown | |
key | Unknown | |
label | Unknown | |
sort_index | Unknown |
spend
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
budget_key | Unknown | FK |
product_key | Unknown | FK |
vendor_key | Unknown | FK |
amount | Unknown | |
budget_name | Unknown | |
invoice_date | Unknown | |
invoice_number | Unknown | |
notes | Unknown |
oversight_requirement
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
is_one_time_requirement | Unknown | |
is_soc | Unknown | |
lifecycle | Unknown | |
name | Unknown | |
offboarding_lifecycle | Unknown | |
onboarding_lifecycle_approver_contact_key | Unknown | |
onboarding_lifecycle_approver_contact_name | Unknown | |
onboarding_lifecycle_default_task_owner_key | Unknown | |
onboarding_lifecycle_default_task_owner_name | Unknown | |
onboarding_lifecycle_default_task_owner_type | Unknown | |
onboarding_lifecycle_is_active | Unknown | |
onboarding_lifecycle_is_approval_required | Unknown | |
onboarding_lifecycle_oversight_requirement_key | Unknown | |
ongoing_lifecycle | Unknown | |
oversight_requirement_category | Unknown | |
oversight_requirement_result_group | Unknown | |
oversight_requirement_type | Unknown | |
should_notify_admin_when_overdue | Unknown | |
task_duration_in_days | Unknown |
business_unit_product
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
business_unit_key | Unknown | PKFK |
key | Unknown |
business_unit_user
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
business_unit_key | Unknown | PKFK |
key | Unknown | FK |
business_unit
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
name | Unknown |
unassigned_product
| Column | Type | Keys |
|---|---|---|
key | Unknown | PKFK |
unassigned_user
| Column | Type | Keys |
|---|---|---|
key | Unknown | PKFK |
form_vendor_information_child_question
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
form_key | Unknown | PKFK |
form_vendor_information_question_key | Unknown | PKFK |
parent_selection_name | Unknown | |
question | Unknown | |
responsibility | Unknown | |
type | Unknown |
form_vendor_information_question
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
form_key | Unknown | PKFK |
data_field_key | Unknown | |
question | Unknown | |
responsibility | Unknown | |
type | Unknown |
form_product_information_child_question
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
form_key | Unknown | PKFK |
form_product_information_question_key | Unknown | PKFK |
parent_selection_name | Unknown | |
question | Unknown | |
responsibility | Unknown | |
type | Unknown |
form_product_information_question
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
form_key | Unknown | PKFK |
data_field_key | Unknown | |
question | Unknown | |
responsibility | Unknown | |
type | Unknown |
form_pricing_question
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
form_key | Unknown | PKFK |
question | Unknown | |
responsibility | Unknown |
form_criticality_question
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
form_key | Unknown | PKFK |
question | Unknown | |
responsibility | Unknown |
form_risk_assessment_question
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
form_key | Unknown | PKFK |
is_prevailing | Unknown | |
question | Unknown | |
responsibility | Unknown |
form
| Column | Type | Keys |
|---|---|---|
key | Unknown | PKFK |
service_product
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
service_id | Unknown | PKFK |
key | Unknown | |
name | Unknown |
service
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
vendor_key | Unknown | FK |
created_date | Unknown | |
key | Unknown | |
status | Unknown | |
status_changed_date | Unknown | |
type | Unknown |