# Venminder schema ERD

Table and field reference for the Fivetran Venminder connector.

## 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| amount | Unknown |  |
| end_date | Unknown |  |
| name | Unknown |  |
| start_date | Unknown |  |

### contract_product

| Column | Type | Keys |
| --- | --- | --- |
| contract_key | Unknown | PK, FK |
| key | Unknown | PK, FK |
| 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 | PK, FK |
| onboarding_request_requestor_key | Unknown | PK, FK |
| 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 | PK, FK |
| key | Unknown |  |

### oversight_task_document

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| oversight_task_key | Unknown | PK, FK |
| key | Unknown |  |

### oversight_task_comment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| oversight_task_key | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| key | Unknown |  |

### vendor_profile_third_party

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| vendor_profile_key | Unknown | PK, FK |
| key | Unknown |  |

### vendor_profile_data_answer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| vendor_profile_data_key | Unknown | PK, FK |
| vendor_profile_key | Unknown | PK, FK |
| answer | Unknown |  |

### vendor_profile_data

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| vendor_profile_key | Unknown | PK, FK |
| 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 | PK, FK |
| vendor_profile_open_requirement_index | Unknown | PK, FK |
| key | Unknown |  |

### vendor_profile_open_requirement

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| vendor_profile_key | Unknown | PK, FK |
| 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 | PK, FK |
| vendor_profile_product_contact_index | Unknown | PK, FK |
| vendor_profile_product_key | Unknown | PK, FK |
| 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 | PK, FK |
| vendor_profile_product_key | Unknown | PK, FK |
| 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 | PK, FK |
| vendor_profile_product_data_key | Unknown | PK, FK |
| vendor_profile_product_key | Unknown | PK, FK |
| answer | Unknown |  |

### vendor_profile_product_data

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| vendor_profile_key | Unknown | PK, FK |
| vendor_profile_product_key | Unknown | PK, FK |
| 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 | PK, FK |
| vendor_profile_product_key | Unknown | PK, FK |
| key | Unknown |  |

### vendor_profile_business_unit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| vendor_profile_key | Unknown | PK, FK |
| vendor_profile_product_key | Unknown | PK, FK |
| business_unit | Unknown |  |

### vendor_profile_product

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| vendor_profile_key | Unknown | PK, FK |
| 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 | PK, FK |
| vendor_profile_key | Unknown | PK, FK |

### 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 | PK, FK |
| vendor_profile_key | Unknown | PK, FK |
| expected_answer | Unknown |  |

### vendor_profile_answer

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| vendor_profile_key | Unknown | PK, FK |

### product_profile_expected_answer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_profile_answer_key | Unknown | PK, FK |
| vendor_profile_key | Unknown | PK, FK |
| expected_answer | Unknown |  |

### product_profile_answer

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| vendor_profile_key | Unknown | PK, FK |

### vendor_onboarding_form_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| vendor_onboarding_form_key | Unknown | PK, FK |
| 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 | PK, FK |
| applies_to_all_products | Unknown |  |
| label | Unknown |  |

### user_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_key | Unknown | PK, FK |
| area_code | Unknown |  |
| extension | Unknown |  |
| prefix | Unknown |  |
| suffix | Unknown |  |
| type | Unknown |  |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| user_key | Unknown | PK, FK |
| 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 | PK, FK |
| key | Unknown |  |

### business_unit_user

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| business_unit_key | Unknown | PK, FK |
| key | Unknown | FK |

### business_unit

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| name | Unknown |  |

### unassigned_product

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK, FK |

### unassigned_user

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK, FK |

### form_vendor_information_child_question

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| form_key | Unknown | PK, FK |
| form_vendor_information_question_key | Unknown | PK, FK |
| parent_selection_name | Unknown |  |
| question | Unknown |  |
| responsibility | Unknown |  |
| type | Unknown |  |

### form_vendor_information_question

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| form_key | Unknown | PK, FK |
| data_field_key | Unknown |  |
| question | Unknown |  |
| responsibility | Unknown |  |
| type | Unknown |  |

### form_product_information_child_question

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| form_key | Unknown | PK, FK |
| form_product_information_question_key | Unknown | PK, FK |
| parent_selection_name | Unknown |  |
| question | Unknown |  |
| responsibility | Unknown |  |
| type | Unknown |  |

### form_product_information_question

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| form_key | Unknown | PK, FK |
| data_field_key | Unknown |  |
| question | Unknown |  |
| responsibility | Unknown |  |
| type | Unknown |  |

### form_pricing_question

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| form_key | Unknown | PK, FK |
| question | Unknown |  |
| responsibility | Unknown |  |

### form_criticality_question

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| form_key | Unknown | PK, FK |
| question | Unknown |  |
| responsibility | Unknown |  |

### form_risk_assessment_question

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| form_key | Unknown | PK, FK |
| is_prevailing | Unknown |  |
| question | Unknown |  |
| responsibility | Unknown |  |

### form

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK, FK |

### service_product

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| service_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- form_vendor_profile_expected_answer(form_vendor_profile_answer_key) → form_vendor_profile_answer(key)
- form_vendor_profile_answer(form_key) → vendor_onboarding_form(key)
- form_product_profile_expected_answer(form_product_profile_answer_key) → form_product_profile_answer(key)
- form_product_profile_answer(form_key) → vendor_onboarding_form(key)
- budget(vendor_profile_key) → vendor_profile(key)
- contract_product(key) → vendor_profile_product(key)
- contract_product(contract_key) → contract(key)
- contract(vendor_key) → vendor_profile(key)
- onboarding_request_section_status(onboarding_request_requestor_key) → onboarding_request(requestor_key)
- onboarding_request_section_status(onboarding_request_requested_date) → onboarding_request(requested_date)
- onboarding_request(product_key) → vendor_profile_product(key)
- onboarding_request(vendor_key) → vendor_profile(key)
- oversight_task_product(oversight_task_key) → oversight_task(key)
- oversight_task_document(oversight_task_key) → oversight_task(key)
- oversight_task_comment(oversight_task_key) → oversight_task(key)
- oversight_task(vendor_key) → vendor_profile(key)
- oversight_task(owner_key) → users(key)
- oversight_task(internal_reviewer_key) → users(key)
- oversight_task(approver_key) → users(key)
- oversight_task(completed_by_key) → users(key)
- request_answer_vendor_profile_expected_answer(request_answer_vendor_profile_answer_key) → request_answer_vendor_profile_answer(key)
- request_answer_product_profile_expected_answer(request_answer_product_profile_answer_key) → request_answer_product_profile_answer(key)
- vendor_profile_fourth_party(vendor_profile_key) → vendor_profile(key)
- vendor_profile_third_party(vendor_profile_key) → vendor_profile(key)
- vendor_profile_data_answer(vendor_profile_data_key) → vendor_profile_data(key)
- vendor_profile_data_answer(vendor_profile_key) → vendor_profile_data(vendor_profile_key)
- vendor_profile_data(vendor_profile_key) → vendor_profile(key)
- vendor_profile_open_requirement_product(vendor_profile_open_requirement_index) → vendor_profile_open_requirement(index)
- vendor_profile_open_requirement_product(vendor_profile_key) → vendor_profile_open_requirement(vendor_profile_key)
- vendor_profile_open_requirement(vendor_profile_key) → vendor_profile(key)
- vendor_profile_product_contact_phone_number(vendor_profile_product_contact_index) → vendor_profile_product_contact(index)
- vendor_profile_product_contact_phone_number(vendor_profile_product_key) → vendor_profile_product_contact(vendor_profile_product_key)
- vendor_profile_product_contact_phone_number(vendor_profile_key) → vendor_profile_product_contact(vendor_profile_key)
- vendor_profile_product_contact(vendor_profile_product_key) → vendor_profile_product(key)
- vendor_profile_product_contact(vendor_profile_key) → vendor_profile_product(vendor_profile_key)
- vendor_profile_product_data_answer(vendor_profile_product_data_key) → vendor_profile_product_data(key)
- vendor_profile_product_data_answer(vendor_profile_product_key) → vendor_profile_product_data(vendor_profile_product_key)
- vendor_profile_product_data_answer(vendor_profile_key) → vendor_profile_product_data(vendor_profile_key)
- vendor_profile_product_data(vendor_profile_product_key) → vendor_profile_product(key)
- vendor_profile_product_data(vendor_profile_key) → vendor_profile_product(vendor_profile_key)
- vendor_profile_collaborator(vendor_profile_product_key) → vendor_profile_product(key)
- vendor_profile_collaborator(vendor_profile_key) → vendor_profile_product(vendor_profile_key)
- vendor_profile_business_unit(vendor_profile_product_key) → vendor_profile_product(key)
- vendor_profile_business_unit(vendor_profile_key) → vendor_profile_product(vendor_profile_key)
- vendor_profile_product(vendor_profile_key) → vendor_profile(key)
- vendor_profile_contract(key) → contract(key)
- vendor_profile_contract(vendor_profile_key) → vendor_profile(key)
- vendor_profile_expected_answer(vendor_profile_answer_key) → vendor_profile_answer(key)
- vendor_profile_expected_answer(vendor_profile_key) → vendor_profile_answer(vendor_profile_key)
- vendor_profile_answer(vendor_profile_key) → vendor_profile(key)
- product_profile_expected_answer(product_profile_answer_key) → product_profile_answer(key)
- product_profile_expected_answer(vendor_profile_key) → product_profile_answer(vendor_profile_key)
- product_profile_answer(vendor_profile_key) → vendor_profile(key)
- vendor_onboarding_form_category(vendor_onboarding_form_key) → vendor_onboarding_form(key)
- vendor_onboarding_form(last_edited_by_key) → users(key)
- client_info_oversight_requirement(key) → oversight_requirement(key)
- user_phone_number(user_key) → users(key)
- user_role(user_key) → users(key)
- spend(budget_key) → budget(key)
- spend(product_key) → vendor_profile_product(key)
- spend(vendor_key) → vendor_profile(key)
- business_unit_product(business_unit_key) → business_unit(key)
- business_unit_user(key) → users(key)
- business_unit_user(business_unit_key) → business_unit(key)
- unassigned_product(key) → vendor_profile_product(key)
- unassigned_user(key) → users(key)
- form_vendor_information_child_question(form_vendor_information_question_key) → form_vendor_information_question(key)
- form_vendor_information_child_question(form_key) → form_vendor_information_question(form_key)
- form_vendor_information_question(form_key) → form(key)
- form_product_information_child_question(form_product_information_question_key) → form_product_information_question(key)
- form_product_information_child_question(form_key) → form_product_information_question(form_key)
- form_product_information_question(form_key) → form(key)
- form_pricing_question(form_key) → form(key)
- form_criticality_question(form_key) → form(key)
- form_risk_assessment_question(form_key) → form(key)
- form(key) → vendor_onboarding_form(key)
- service_product(service_id) → service(id)
- service(vendor_key) → vendor_profile(key)