# Veeva Vault schema ERD

Table and field reference for the Fivetran Veeva Vault connector.

## Table & Field Reference

### group_security_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| group_id | Unknown | PK, FK |
| security_profile | Unknown |  |

### group_member

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| group_id | Unknown | PK, FK |
| member | Unknown | FK |

### implied_member

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| source_name | Unknown |  |
| source_type | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| active | Unknown |  |
| allow_delegation_among_member | Unknown |  |
| created_date | Unknown |  |
| editable | Unknown |  |
| group_description | Unknown |  |
| label | Unknown |  |
| modified_by | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| system_group | Unknown |  |
| type | Unknown |  |

### bulk_workflow_action_control_prompt

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| label | Unknown |  |
| multi_value | Unknown |  |
| name | Unknown |  |
| required | Unknown |  |

### bulk_workflow_action_detail

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| label | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### workflow_action_control

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| current_values | Json |  |
| label | Unknown |  |
| prompts | Json |  |
| type | Unknown |  |

### workflow_action

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| workflow_id | Unknown | PK, FK |
| label | Unknown |  |
| name | Unknown |  |

### object_record_role_user

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| users | Unknown | FK |

### object_record_role_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| groups | Unknown | FK |

### object_record_role

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| object_record_id | Unknown | PK |
| name | Unknown | FK |
| assignment_type | Unknown |  |

### workflow_task_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workflow_task_id | Unknown | PK, FK |
| status | Unknown |  |

### workflow_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| assignee | Unknown | FK |
| object | Unknown | FK |
| record_id | Unknown | FK |
| workflow_id | Unknown | FK |
| assigned_date | Unknown |  |
| completed_date | Unknown |  |
| created_date | Unknown |  |
| instructions | Unknown |  |
| label | Unknown |  |
| workflow_class | Unknown |  |

### document_language

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| languages | Unknown |  |

### document_medicinal_product

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| medicinal_product | Unknown |  |

### document_application

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| application | Unknown |  |

### document_product

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| product | Unknown |  |

### document_matching

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| ready_for_matching | Unknown |  |

### document_labeling_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| labeling_category | Unknown |  |

### document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| annotations_all | Unknown |  |
| annotations_anchors | Unknown |  |
| annotations_approved | Unknown |  |
| annotations_auto | Unknown |  |
| annotations_claim | Unknown |  |
| annotations_lines | Unknown |  |
| annotations_links | Unknown |  |
| annotations_notes | Unknown |  |
| annotations_permalink | Unknown |  |
| annotations_resolved | Unknown |  |
| annotations_suggested | Unknown |  |
| annotations_unresolved | Unknown |  |
| application | Json |  |
| approved_date | Unknown |  |
| attachment_version_date_for_submission | Unknown |  |
| attachment_version_for_submission | Unknown |  |
| binder | Unknown |  |
| bookmarks_edited | Unknown |  |
| classification | Unknown |  |
| clinical_site | Json |  |
| clinical_study | Json |  |
| country | Json |  |
| crosslink | Unknown |  |
| document_creation_date | Unknown |  |
| document_number | Unknown |  |
| drug_product | Json |  |
| drug_substance | Json |  |
| excipient | Json |  |
| filename | Unknown |  |
| format | Unknown |  |
| global_id | Unknown |  |
| global_version_id | Unknown |  |
| is_a_translation | Unknown |  |
| language_for_submission | Unknown |  |
| last_modified_by | Unknown |  |
| lifecycle | Unknown |  |
| locked | Unknown |  |
| major_version_number | Unknown |  |
| manufacturer | Json |  |
| md_5_checksum | Unknown |  |
| minor_version_number | Unknown |  |
| name | Unknown |  |
| nonclinical_study | Json |  |
| pages | Unknown |  |
| product_detail | Json |  |
| ready_for_publishing | Unknown |  |
| region | Json |  |
| size | Unknown |  |
| stage | Unknown |  |
| state_stage_id | Unknown |  |
| status | Unknown |  |
| submission | Json |  |
| subtype | Unknown |  |
| suppress_rendition | Unknown |  |
| type | Unknown |  |
| version_created_by | Unknown |  |
| version_creation_date | Unknown |  |
| version_id | Unknown |  |
| version_modified_date | Unknown |  |

### document_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| groups | Unknown | FK |
| type | String |  |

### document_user

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| users | Unknown | FK |
| type | String |  |

### user_vault

| Column | Type | Keys |
| --- | --- | --- |
| vault_id | Unknown | PK |
| user_id | Unknown | PK, FK |

### user_group

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| active | Unknown |  |
| created_date | Unknown |  |
| domain_active | Unknown |  |
| domain_id | Unknown |  |
| domain_name | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| is_domain_admin | Unknown |  |
| last_login | Unknown |  |
| last_name | Unknown |  |
| license_type | Unknown |  |
| locale | Unknown |  |
| modified_by | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| security_policy_id | Unknown |  |
| security_profile | Unknown |  |
| timezone | Unknown |  |
| user_language | Unknown |  |
| user_needs_to_change_password | Unknown |  |

### workflow_task_action_control

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| label | Unknown |  |
| type | Unknown |  |

### workflow_task_action_detail

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| workflow_id | Unknown | PK, FK |
| description | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### object_collection_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| object_name | Unknown | PK, FK |
| status | Unknown |  |

### object_collection

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| configuration_state | Unknown |  |
| in_menu | Unknown |  |
| label | Unknown |  |
| label_plural | Unknown |  |
| orders | Unknown |  |
| prefix | Unknown |  |
| source | Unknown |  |
| url | Unknown |  |

### object_record_data

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| created_by | Unknown | FK |
| created_date | Unknown |  |
| modified_by | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |

### object_record

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown | FK |

### object_metadata_relationship

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| object_name | Unknown | FK |
| field | Unknown |  |
| relationship_deletion | Unknown |  |
| relationship_label | Unknown |  |
| relationship_name | Unknown |  |
| relationship_type | Unknown |  |

### object_metadata_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| created_by | Unknown | FK |
| create_object_inline | Unknown |  |
| created_date | Unknown |  |
| editable | Unknown |  |
| encrypted | Unknown |  |
| help_content | Unknown |  |
| label | Unknown |  |
| list_column | Unknown |  |
| lookup_relationship_name | Unknown |  |
| lookup_source_field | Unknown |  |
| max_length | Unknown |  |
| modified_by | Unknown |  |
| modified_date | Unknown |  |
| multi_value | Unknown |  |
| name | Unknown |  |
| no_copy | Unknown |  |
| object_label | Unknown |  |
| object_label_plural | Unknown |  |
| object_name | Unknown |  |
| object_prefix | Unknown |  |
| object_url | Unknown |  |
| orders | Unknown |  |
| picklist | Unknown |  |
| relationship_criteria | Unknown |  |
| relationship_deep_copy | Unknown |  |
| relationship_deletion | Unknown |  |
| relationship_inbound_label | Unknown |  |
| relationship_inbound_name | Unknown |  |
| relationship_outbound_name | Unknown |  |
| relationship_type | Unknown |  |
| required | Unknown |  |
| secure_relationship | Unknown |  |
| sequential_naming | Unknown |  |
| source | Unknown |  |
| system_managed_name | Unknown |  |
| type | Unknown |  |
| uniques | Unknown |  |
| value_format | Unknown |  |

### object_metadata_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| status | Unknown |  |

### object_metadata

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| created_by | Unknown | FK |
| name | Unknown | FK |
| url_metadata | Unknown | FK |
| allow_attachment | Unknown |  |
| allow_type | Unknown |  |
| auditable | Unknown |  |
| available_lifecycles | Json |  |
| created_date | Unknown |  |
| data_store | Unknown |  |
| default_obj_type | Unknown |  |
| description | Unknown |  |
| dynamic_security | Unknown |  |
| enable_e_signature | Unknown |  |
| help_content | Unknown |  |
| in_menu | Unknown |  |
| label | Unknown |  |
| label_plural | Unknown |  |
| modified_by | Unknown |  |
| modified_date | Unknown |  |
| multi_select | Unknown |  |
| object_class | Unknown |  |
| orders | Unknown |  |
| prefix | Unknown |  |
| prevent_record_overwrite | Unknown |  |
| role_override | Unknown |  |
| secure_attachment | Unknown |  |
| secure_audit_trail | Unknown |  |
| secure_sharing_setting | Unknown |  |
| source | Unknown |  |
| system_managed | Unknown |  |
| url_field | Unknown |  |
| url_list | Unknown |  |
| url_record | Unknown |  |
| user_role_label | Unknown |  |
| user_role_label_plural | Unknown |  |
| user_role_name | Unknown |  |
| user_role_prefix | Unknown |  |
| user_role_setup_object | Unknown |  |
| user_role_url | Unknown |  |

### workflow_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workflow_id | Unknown | PK, FK |
| status | Unknown |  |

### workflow

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| initiator | Unknown | FK |
| object | Unknown | FK |
| record_id | Unknown | FK |
| completed_date | Unknown |  |
| label | Unknown |  |
| started_date | Unknown |  |

## Relationships

- group_security_profile(group_id) → groups(id)
- group_member(member) → users(id)
- group_member(group_id) → groups(id)
- implied_member(id) → users(id)
- implied_member(group_id) → groups(id)
- groups(created_by) → users(id)
- bulk_workflow_action_control_prompt(_fivetran_id) → bulk_workflow_action_detail(_fivetran_id)
- workflow_action_control(_fivetran_id) → workflow_action(_fivetran_id)
- workflow_action(workflow_id) → workflow(id)
- object_record_role_user(users) → users(id)
- object_record_role_user(_fivetran_id) → object_record_role(_fivetran_id)
- object_record_role_group(groups) → groups(id)
- object_record_role_group(_fivetran_id) → object_record_role(_fivetran_id)
- object_record_role(name) → object_record(name)
- workflow_task_status(workflow_task_id) → workflow_task(id)
- workflow_task(object) → object_collection(name)
- workflow_task(record_id) → object_record(id)
- workflow_task(assignee) → users(id)
- workflow_task(workflow_id) → workflow(id)
- workflow_task(user_id) → users(id)
- document_language(document_id) → document(id)
- document_medicinal_product(document_id) → document(id)
- document_application(document_id) → document(id)
- document_product(document_id) → document(id)
- document_matching(document_id) → document(id)
- document_labeling_category(document_id) → document(id)
- document(created_by) → users(id)
- document_group(groups) → groups(id)
- document_group(document_id) → document(id)
- document_user(users) → users(id)
- document_user(document_id) → document(id)
- user_vault(user_id) → users(id)
- user_group(group_id) → groups(id)
- user_group(user_id) → users(id)
- users(created_by) → users(id)
- workflow_task_action_control(_fivetran_id) → workflow_task_action_detail(_fivetran_id)
- workflow_task_action_detail(workflow_id) → workflow(id)
- object_collection_status(object_name) → object_collection(name)
- object_record_data(id) → object_record(id)
- object_record_data(created_by) → users(id)
- object_record(name) → object_collection(name)
- object_metadata_relationship(object_name) → object_collection(name)
- object_metadata_relationship(_fivetran_id) → object_metadata(_fivetran_id)
- object_metadata_field(created_by) → users(id)
- object_metadata_field(_fivetran_id) → object_metadata(_fivetran_id)
- object_metadata_status(_fivetran_id) → object_metadata(_fivetran_id)
- object_metadata(created_by) → users(id)
- object_metadata(name) → object_collection(name)
- object_metadata(url_metadata) → object_collection(url)
- workflow_status(workflow_id) → workflow(id)
- workflow(object) → object_collection(name)
- workflow(record_id) → object_record(id)
- workflow(initiator) → users(id)
- workflow(user_id) → users(id)