# Concord schema ERD

Table and field reference for the Fivetran Concord connector.

## Table & Field Reference

### organization_group_user

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

### organization_group_invitation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_group_id | Unknown | PK, FK |
| created_at | Unknown |  |
| email | Unknown |  |
| uuid | Unknown |  |

### organization_group

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

### agreement_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreement_uuid | Unknown | FK |
| organization_id | Unknown | FK |
| created_at | Unknown |  |
| created_by_email | Unknown |  |
| created_by_has_mfa | Unknown |  |
| created_by_has_picture | Unknown |  |
| created_by_id | Unknown |  |
| created_by_name | Unknown |  |
| description | Unknown |  |
| file_name | Unknown |  |
| name | Unknown |  |
| url | Unknown |  |

### organization_detail_email_domain

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| organization_detail_id | Unknown | FK |
| domain | Unknown |  |
| verified | Unknown |  |

### organization_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| admin_oversight | Unknown |  |
| all_tags_visible | Unknown |  |
| ask_for_tag | Unknown |  |
| can_collaborator_sign | Unknown |  |
| contact_info_city | Unknown |  |
| contact_info_country | Unknown |  |
| contact_info_email | Unknown |  |
| contact_info_function | Unknown |  |
| contact_info_mobile | Unknown |  |
| contact_info_mobile_code | Unknown |  |
| contact_info_name | Unknown |  |
| contact_info_phone | Unknown |  |
| contact_info_phone_code | Unknown |  |
| contact_info_state | Unknown |  |
| contact_info_street | Unknown |  |
| contact_info_zip_code | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| password_strategy | Unknown |  |
| region | Unknown |  |
| send_invitation_with_document | Unknown |  |
| signing_authentication_colleague | Unknown |  |
| signing_authentication_third_party | Unknown |  |
| subscription | Unknown |  |
| subsidiary | Json |  |
| whilelisted_ip | Json |  |

### agreement_party

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| agreement_uuid | Unknown | PK, FK |
| party | Unknown |  |

### agreement_tag

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| agreement_uuid | Unknown | PK, FK |

### agreement_field

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agreement_uuid | Unknown | FK |
| organization_field_item_uuid | Unknown |  |
| value | Json |  |

### agreement_property

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreement_uuid | Unknown | PK, FK |
| content_metadata | Json |  |
| content_type | Unknown |  |
| content_value | Json |  |
| name | Unknown |  |
| property_source | Unknown |  |
| visibility | Unknown |  |

### agreement

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| organization_id | Unknown | FK |
| access_from_role | Unknown |  |
| access_type | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| created_by_is_active | Unknown |  |
| created_by_name | Unknown |  |
| description | Unknown |  |
| document_type | Unknown |  |
| end_date | Unknown |  |
| end_date_unknown | Unknown |  |
| has_signed | Unknown |  |
| id | Unknown |  |
| is_inboxed | Unknown |  |
| modified_at | Unknown |  |
| must_validate | Unknown |  |
| signature_block_enabled | Unknown |  |
| signature_count | Unknown |  |
| signature_date | Unknown |  |
| signature_date_unknown | Unknown |  |
| signature_required | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| unread | Unknown |  |
| validated | Unknown |  |
| validation_count | Unknown |  |
| validation_required | Unknown |  |

### agreement_version_last_field_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| agreement_uuid | Unknown | PK, FK |
| agreement_version_last_field_uuid | Unknown | PK, FK |
| value | Unknown |  |

### agreement_version_last_field_option

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| agreement_uuid | Unknown | PK, FK |
| agreement_version_last_field_uuid | Unknown | PK, FK |
| clause_id | Unknown |  |
| clause_version | Unknown |  |
| description | Unknown |  |
| title | Unknown |  |
| value | Unknown |  |

### agreement_version_last_field

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| agreement_uuid | Unknown | PK, FK |
| reservation_organization_id | Unknown | FK |
| reservation_user_id | Unknown | FK |
| locked | Unknown |  |
| metadata | Unknown |  |
| organization_field_item_uuid | Unknown |  |
| placeholder | Unknown |  |
| required | Unknown |  |
| reservation_email | Unknown |  |
| reservation_group | Unknown |  |
| reservation_group_id | Unknown |  |
| reservation_signature_slot | Unknown |  |
| reservation_slot_id | Unknown |  |
| reservation_type | Unknown |  |
| source_type | Unknown |  |
| type | Unknown |  |

### user_authority

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| authority | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| current_organization_id | Unknown | FK |
| contact_cellphone | Unknown |  |
| contact_cellphone_code | Unknown |  |
| contact_workphone | Unknown |  |
| contact_workphone_code | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| full_name | Unknown |  |
| has_password | Unknown |  |
| has_picture | Unknown |  |
| name | Unknown |  |
| timezone | Unknown |  |

### tag_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| tags_id | Unknown | PK, FK |
| job | Unknown |  |
| pictures_normal | Unknown |  |
| pictures_small | Unknown |  |
| pictures_special | Unknown |  |

### tag_user_group_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| tag_user_group_id | Unknown | PK, FK |
| tags_id | Unknown | PK, FK |

### tag_uer_group_invitation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| tag_user_group_id | Unknown | PK, FK |
| tags_id | Unknown | PK, FK |

### tag_user_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tags_id | Unknown | PK, FK |
| description | Unknown |  |
| name | Unknown |  |

### tag_invitation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tags_id | Unknown | PK, FK |
| created_at | Unknown |  |
| email | Unknown |  |
| uuid | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| access_rule | Unknown |  |
| access_rule_all_user_organization_access | Unknown |  |
| access_rule_id | Unknown |  |
| count_contract_count | Unknown |  |
| count_draft_count | Unknown |  |
| count_id | Unknown |  |
| count_negotiation_count | Unknown |  |
| count_template_count | Unknown |  |
| counts | Unknown |  |
| in_access_rule | Unknown |  |
| name | Unknown |  |

### folder_user

| Column | Type | Keys |
| --- | --- | --- |
| folder_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| job | Unknown |  |
| pictures_normal | Unknown |  |
| pictures_small | Unknown |  |
| pictures_special | Unknown |  |

### folder_team_user

| Column | Type | Keys |
| --- | --- | --- |
| folder_id | Unknown | PK, FK |
| folder_team_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### folder_team_invitation

| Column | Type | Keys |
| --- | --- | --- |
| folder_id | Unknown | PK, FK |
| folder_team_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### folder_team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| folder_id | Unknown | FK |
| organization_id | Unknown | FK |
| description | Unknown |  |
| name | Unknown |  |

### folder_invitation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| folder_id | Unknown | PK, FK |
| created_at | Unknown |  |
| email | Unknown |  |
| uuid | Unknown |  |

### folder_children

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

### folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| parent_id | Unknown | FK |
| access_all_user_organization_access | Unknown |  |
| document_count | Unknown |  |
| name | Unknown |  |

### agreement_comment_reply

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agreement_comment_uuid | Unknown | FK |
| created_at | Unknown |  |
| created_by_haspicture | Unknown |  |
| created_by_id | Unknown |  |
| created_by_name | Unknown |  |
| display_version | Unknown |  |
| text | Unknown |  |
| version | Unknown |  |

### agreement_comment

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| agreement_uuid | Unknown | FK |
| organization_id | Unknown | FK |
| commented_text | Unknown |  |
| created_at | Unknown |  |
| created_by_has_picture | Unknown |  |
| created_by_id | Unknown |  |
| created_by_name | Unknown |  |
| display_version | Unknown |  |
| resolved | Unknown |  |
| text | Unknown |  |
| version | Unknown |  |
| visibility | Unknown |  |
| word_dataauthor | Unknown |  |
| word_datadate | Unknown |  |

### agreement_approval_validation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| agreement_approval_rule_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| user_organization_id | Unknown | FK |
| groups | Unknown |  |
| result | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| user_job | Unknown |  |

### agreement_approval_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| active | Unknown |  |
| condition | Json |  |
| request_sent | Unknown |  |
| result | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### agreement_approval

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agreement_uuid | Unknown | FK |
| organization_id | Unknown | FK |
| auto_notification_enabled | Unknown |  |
| block_thirdparty_signature | Unknown |  |
| organization_workflow_id | Unknown |  |
| organization_workflow_title | Unknown |  |
| status | Unknown |  |

### signature

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreement_uuid | Unknown | PK, FK |
| reservation_organization_id | Unknown | FK |
| reservation_user_id | Unknown | FK |
| reservation_email | Unknown |  |
| reservation_group_deleted | Unknown |  |
| reservation_group_id | Unknown |  |
| reservation_group_name | Unknown |  |
| reservation_type | Unknown |  |
| signature_date | Unknown |  |
| signature_info_email | Unknown |  |
| signature_info_font | Unknown |  |
| signature_info_image | Unknown |  |
| signature_info_job | Unknown |  |
| signature_info_name | Unknown |  |
| signature_info_organization | Unknown |  |
| signature_info_signature | Unknown |  |
| signature_type | Unknown |  |

### agreement_summary_signed_with_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| agreement_summary_id | Unknown | PK, FK |
| signed_with_label | Unknown |  |

### agreement_summary_clause

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreement_summary_id | Unknown | PK, FK |
| deadline | Unknown |  |
| event_duration | Unknown |  |
| financial_data_amount_unit | Unknown |  |
| financial_data_amount_value | Unknown |  |
| financial_data_before_tax | Unknown |  |
| financial_data_credit | Unknown |  |
| financial_data_percent | Unknown |  |
| financial_data_percent_from | Unknown |  |
| financial_data_percent_value | Unknown |  |
| length_unit | Unknown |  |
| length_value | Unknown |  |
| period_custom_end | Unknown |  |
| period_custom_start | Unknown |  |
| period_type | Unknown |  |
| period_unit | Unknown |  |
| period_value | Unknown |  |
| title | Unknown |  |

### agreement_summary_link_permission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| agreement_summary_id | Unknown | PK, FK |
| agreement_summary_link_id | Unknown | PK, FK |
| link_permission | Unknown |  |

### agreement_summary_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreement_summary_id | Unknown | PK, FK |
| owner_has_access | Unknown |  |
| owner_id | Unknown |  |
| owner_status | Unknown |  |
| owner_title | Unknown |  |
| owner_uid | Unknown |  |
| target_has_access | Unknown |  |
| target_id | Unknown |  |
| target_status | Unknown |  |
| target_title | Unknown |  |
| target_uid | Unknown |  |
| type | Unknown |  |

### agreement_summary_end_clause

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreement_summary_id | Unknown | PK, FK |
| agreement_uid | Unknown | FK |
| after_renewal_auto_generate | Unknown |  |
| after_renewal_custom_start_date | Unknown |  |
| after_renewal_deadline | Unknown |  |
| after_renewal_duration_unit | Unknown |  |
| after_renewal_duration_value | Unknown |  |
| after_renewal_event | Unknown |  |
| auto_generated | Unknown |  |
| contract_id | Unknown |  |
| contract_renewal_type | Unknown |  |
| created_at | Unknown |  |
| created_by_full_name | Unknown |  |
| created_by_id | Unknown |  |
| createdby_email | Unknown |  |
| createdby_haspicture | Unknown |  |
| custom_start_date | Unknown |  |
| deadline | Unknown |  |
| early_termination_notice_period_unit | Unknown |  |
| early_termination_notice_period_value | Unknown |  |
| event_duration | Unknown |  |
| length_unit | Unknown |  |
| length_value | Unknown |  |
| modified_at | Unknown |  |
| modified_by_email | Unknown |  |
| modified_by_fullname | Unknown |  |
| modified_by_haspicture | Unknown |  |
| modified_by_id | Unknown |  |
| modified_by_name | Unknown |  |
| next_end_clause_id | Unknown |  |
| notice_period_unit | Unknown |  |
| notice_period_value | Unknown |  |
| period_custom_end | Unknown |  |
| period_custom_start | Unknown |  |
| period_type | Unknown |  |
| period_unit | Unknown |  |
| previous_end_clause_id | Unknown |  |
| renewal_count_remaining | Unknown |  |
| start_date | Unknown |  |
| type | Unknown |  |

### agreement_summary

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreement_uid | Unknown | FK |
| organization_id | Unknown | FK |
| description | Unknown |  |
| lifecycle_calculated_end | Unknown |  |
| lifecycle_effect_date | Unknown |  |
| lifecycle_effect_type | Unknown |  |
| lifecycle_signature_date | Unknown |  |
| lifecycle_signature_date_unknown | Unknown |  |
| lifecycle_terminate | Unknown |  |
| lifecycle_termination_at_end | Unknown |  |
| lifecycle_termination_date | Unknown |  |
| lifecycle_termination_notified_at | Unknown |  |
| lifecycle_termination_notified_by_email | Unknown |  |
| lifecycle_termination_notified_by_fullname | Unknown |  |
| lifecycle_termination_notified_by_id | Unknown |  |

### agreement_version_pdf_field

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agreement_version_id | Unknown | FK |
| name | Unknown |  |
| placeholder | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### agreement_version_signature_field

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agreement_version_id | Unknown | FK |
| item_id | Unknown |  |
| name | Unknown |  |
| page | Unknown |  |
| x | Unknown |  |
| y | Unknown |  |

### agreement_version

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreement_uuid | Unknown | FK |
| organization_id | Unknown | FK |
| user_id | Unknown | FK |
| comment | Unknown |  |
| creation_creator_active | Unknown |  |
| creation_creator_id | Unknown |  |
| creation_creator_job | Unknown |  |
| creation_date | Unknown |  |
| date | Unknown |  |
| display_version | Unknown |  |
| fillable_field | Unknown |  |
| pdf | Unknown |  |
| type | Unknown |  |
| version | Unknown |  |
| visibility | Unknown |  |

### subscription_seat

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| subscription_id | Unknown | FK |
| invited | Unknown |  |
| subscribed | Unknown |  |
| type | Unknown |  |
| used | Unknown |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| billing_type | Unknown |  |
| customer_id | Unknown |  |
| feature_level | Unknown |  |
| status | Unknown |  |
| subscription_name | Unknown |  |
| type | Unknown |  |

### organization_workflow_rule_validation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_workflow_id | Unknown | PK, FK |
| organization_workflow_rule_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| user_organization_id | Unknown | FK |
| groups | Unknown |  |
| result | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| user_job | Unknown |  |

### organization_workflow_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_workflow_id | Unknown | PK, FK |
| active | Unknown |  |
| condition | Json |  |
| result | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### organization_workflow

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| block_thirdparty_signature | Unknown |  |
| deletable | Unknown |  |
| description | Unknown |  |
| title | Unknown |  |

### agreement_summary_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreement_uuid | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### organization_clause

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| content | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| number_of_templates_linked | Unknown |  |
| presigned_url | Unknown |  |
| title | Unknown |  |
| version | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| actor_email | Unknown |  |
| actor_has_avatar | Unknown |  |
| actor_id | Unknown |  |
| actor_job | Unknown |  |
| actor_name | Unknown |  |
| actor_organization | Unknown |  |
| actor_type | Unknown |  |
| created_at | Unknown |  |
| event_id | Unknown |  |
| event_name | Unknown |  |
| event_status | Unknown |  |
| event_type | Unknown |  |
| type | Unknown |  |

### agreement_track_change_amendment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agreement_track_change_id | Unknown | FK |
| created_at | Unknown |  |
| created_by_has_picture | Unknown |  |
| created_by_id | Unknown |  |
| created_by_name | Unknown |  |
| display_version | Unknown |  |
| text | Unknown |  |

### agreement_track_change

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreement_uuid | Unknown | FK |
| organization_id | Unknown | FK |
| amendment | Unknown |  |
| change_id | Unknown |  |
| created_at | Unknown |  |
| created_by_has_picture | Unknown |  |
| created_by_id | Unknown |  |
| created_by_name | Unknown |  |
| display_version | Unknown |  |
| modified_at | Unknown |  |
| modified_by_has_picture | Unknown |  |
| modified_by_id | Unknown |  |
| modified_by_name | Unknown |  |
| status | Unknown |  |
| text | Unknown |  |
| type | Unknown |  |
| version | Unknown |  |
| word_dataauthor | Unknown |  |
| word_datadate | Unknown |  |

### agreement_path_user

| Column | Type | Keys |
| --- | --- | --- |
| agreement_path_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| job | Unknown |  |
| pictures_normal | Unknown |  |
| pictures_small | Unknown |  |
| pictures_special | Unknown |  |

### agreement_path_team_user

| Column | Type | Keys |
| --- | --- | --- |
| agreement_path_id | Unknown | PK, FK |
| agreement_path_team_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### agreement_path_team_invitation

| Column | Type | Keys |
| --- | --- | --- |
| agreement_path_id | Unknown | PK, FK |
| agreement_path_team_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### agreement_path_team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreement_path_id | Unknown | PK, FK |
| organization_id | Unknown | FK |
| description | Unknown |  |
| name | Unknown |  |

### agreement_path_invitation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreement_path_id | Unknown | PK, FK |
| created_at | Unknown |  |
| email | Unknown |  |
| uuid | Unknown |  |

### agreement_path

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreement_uuid | Unknown | FK |
| organization_id | Unknown | FK |
| parent_id | Unknown | FK |
| access_all_user_in_organization_access | Unknown |  |
| document_count | Unknown |  |
| name | Unknown |  |

### organization_member_group

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| organization_id | Unknown | FK |

### organization_member

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| organization_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| invitation | Unknown |  |
| invitation_created_at | Unknown |  |
| invitation_email | Unknown |  |
| invitation_id | Unknown |  |
| invitation_uuid | Unknown |  |
| job | Unknown |  |
| type | Unknown |  |

### organization_subsidary

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| name | Unknown |  |
| subscription | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| featuresaccess_rule | Unknown |  |
| featuresadmin_oversight | Unknown |  |
| featuresamendment | Unknown |  |
| featuresanalytics | Unknown |  |
| featuresapi | Unknown |  |
| featuresaudit_trail | Unknown |  |
| featuresauto_template | Unknown |  |
| featuresbulk_upload | Unknown |  |
| featuresclause_library | Unknown |  |
| featurescomplex_password | Unknown |  |
| featurescustom_branding | Unknown |  |
| featurescustom_role | Unknown |  |
| featuresdata_localization | Unknown |  |
| featuresdedicated_encryption_key | Unknown |  |
| featuresdrafting | Unknown |  |
| featuresexecution | Unknown |  |
| featuresinternal_workflow | Unknown |  |
| featuresorganization_field_item | Unknown |  |
| featuresreport | Unknown |  |
| featuressend_invitation_with_document | Unknown |  |
| featuressignature | Unknown |  |
| featuressubsidiaries | Unknown |  |
| featuresuser_group | Unknown |  |
| featuresversioning | Unknown |  |
| featureswhitelisted_ip | Unknown |  |
| featuresworkflow_center | Unknown |  |
| is_parent | Unknown |  |
| is_subsidiary | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| rightsaccess_all_agreement | Unknown |  |
| rightscontract_access | Unknown |  |
| rightscontract_attachment | Unknown |  |
| rightscontract_create | Unknown |  |
| rightscontract_create_bulk | Unknown |  |
| rightscontract_delete | Unknown |  |
| rightscontract_update | Unknown |  |
| rightsdraft_comment_add | Unknown |  |
| rightsdraft_comment_reply | Unknown |  |
| rightsdraft_comment_resolve | Unknown |  |
| rightsdraft_organization_workflow_use | Unknown |  |
| rightsdraft_workflow_create | Unknown |  |
| rightsdraft_workflow_delete | Unknown |  |
| rightsdraft_workflow_update | Unknown |  |
| rightsfill_field | Unknown |  |
| rightsfolder_create | Unknown |  |
| rightsfolder_delete | Unknown |  |
| rightsfolder_list | Unknown |  |
| rightsfolder_update | Unknown |  |
| rightsgroup_create | Unknown |  |
| rightsgroup_delete | Unknown |  |
| rightsgroup_update | Unknown |  |
| rightsgroup_update_user | Unknown |  |
| rightsnegotiation_add_comment | Unknown |  |
| rightsnegotiation_attachment | Unknown |  |
| rightsnegotiation_break | Unknown |  |
| rightsnegotiation_comment_add | Unknown |  |
| rightsnegotiation_comment_reply | Unknown |  |
| rightsnegotiation_comment_resolve | Unknown |  |
| rightsnegotiation_create | Unknown |  |
| rightsnegotiation_invite | Unknown |  |
| rightsnegotiation_organization_workflow_use | Unknown |  |
| rightsnegotiation_sign | Unknown |  |
| rightsnegotiation_update | Unknown |  |
| rightsnegotiation_update_metadata | Unknown |  |
| rightsnegotiation_workflow_create | Unknown |  |
| rightsnegotiation_workflow_delete | Unknown |  |
| rightsnegotiation_workflow_update | Unknown |  |
| rightsorg_access_all_contract | Unknown |  |
| rightsorg_access_all_negotiation | Unknown |  |
| rightsorg_access_all_template | Unknown |  |
| rightsorg_access_rule_modify | Unknown |  |
| rightsorg_access_rule_view | Unknown |  |
| rightsorg_add_user | Unknown |  |
| rightsorg_billing | Unknown |  |
| rightsorg_create | Unknown |  |
| rightsorg_invite_user | Unknown |  |
| rightsorg_remove_user | Unknown |  |
| rightsorg_update | Unknown |  |
| rightsorganization_clause_create | Unknown |  |
| rightsorganization_clause_delete | Unknown |  |
| rightsorganization_clause_list | Unknown |  |
| rightsorganization_clause_update | Unknown |  |
| rightsorganization_field_item_create | Unknown |  |
| rightsorganization_field_item_delete | Unknown |  |
| rightsorganization_field_item_get | Unknown |  |
| rightsorganization_field_item_update | Unknown |  |
| rightsorganization_workflow_create | Unknown |  |
| rightsorganization_workflow_delete | Unknown |  |
| rightsorganization_workflow_list | Unknown |  |
| rightsorganization_workflow_update | Unknown |  |
| rightsrole_create | Unknown |  |
| rightsrole_delete | Unknown |  |
| rightsrole_update | Unknown |  |
| rightsrole_update_user | Unknown |  |
| rightstag_create | Unknown |  |
| rightstag_delete | Unknown |  |
| rightstag_list_all | Unknown |  |
| rightstag_update | Unknown |  |
| rightstemplate_attachment | Unknown |  |
| rightstemplate_comment_add | Unknown |  |
| rightstemplate_comment_reply | Unknown |  |
| rightstemplate_comment_resolve | Unknown |  |
| rightstemplate_create | Unknown |  |
| rightstemplate_delete | Unknown |  |
| rightstemplate_organization_workflow_use | Unknown |  |
| rightstemplate_update | Unknown |  |
| rightstemplate_update_tag | Unknown |  |
| rightstemplate_update_user | Unknown |  |
| rightstemplate_use | Unknown |  |
| rightstemplate_workflow_create | Unknown |  |
| rightstemplate_workflow_delete | Unknown |  |
| rightstemplate_workflow_update | Unknown |  |
| sign_double_authcoworker | Unknown |  |
| sign_double_auththird_party | Unknown |  |
| subscription | Unknown |  |
| user_features_exports_advanced | Unknown |  |
| user_features_exports_simple | Unknown |  |
| user_features_integrations_box | Unknown |  |
| user_features_integrations_docusign | Unknown |  |
| user_features_integrations_dropbox | Unknown |  |
| user_features_integrations_facebook | Unknown |  |
| user_features_integrations_gdrive | Unknown |  |
| user_features_integrations_google | Unknown |  |
| user_features_integrations_linkedin | Unknown |  |
| user_features_integrations_salesforce | Unknown |  |
| user_features_integrations_saml | Unknown |  |
| user_features_integrations_webhook | Unknown |  |
| user_role_description | Unknown |  |
| user_role_id | Unknown |  |
| user_role_name | Unknown |  |
| user_role_type | Unknown |  |

### report_filter_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| report_id | Unknown | PK, FK |
| status | Unknown |  |

### report_filter_created_by

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| report_id | Unknown | PK, FK |
| created_by | Unknown | FK |

### report

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| description | Unknown |  |
| filter_created_at_is_after | Unknown |  |
| filter_created_at_is_before | Unknown |  |
| filter_created_at_is_between_from | Unknown |  |
| filter_created_at_is_between_to | Unknown |  |
| filter_created_at_is_blank | Unknown |  |
| filter_created_at_is_more_than | Unknown |  |
| filter_created_at_is_within_the_last | Unknown |  |
| filter_created_at_is_within_the_next | Unknown |  |
| filter_end_at_is_after | Unknown |  |
| filter_end_at_is_before | Unknown |  |
| filter_end_at_is_between_from | Unknown |  |
| filter_end_at_is_between_to | Unknown |  |
| filter_end_at_is_blank | Unknown |  |
| filter_end_at_is_more_than | Unknown |  |
| filter_end_at_is_within_the_last | Unknown |  |
| filter_end_at_is_within_the_next | Unknown |  |
| filter_modified_at_is_after | Unknown |  |
| filter_modified_at_is_before | Unknown |  |
| filter_modified_at_is_between_from | Unknown |  |
| filter_modified_at_is_between_to | Unknown |  |
| filter_modified_at_is_blank | Unknown |  |
| filter_modified_at_is_more_than | Unknown |  |
| filter_modified_at_is_within_the_last | Unknown |  |
| filter_modified_at_is_within_the_next | Unknown |  |
| filter_signature_date_is_after | Unknown |  |
| filter_signature_date_is_before | Unknown |  |
| filter_signature_date_is_between_from | Unknown |  |
| filter_signature_date_is_between_to | Unknown |  |
| filter_signature_date_is_blank | Unknown |  |
| filter_signature_date_is_more_than | Unknown |  |
| filter_signature_date_is_within_the_last | Unknown |  |
| filter_signature_date_is_within_the_next | Unknown |  |
| filters_inboxed | Unknown |  |
| filters_no_tag | Unknown |  |
| filters_search | Unknown |  |
| filters_tag_name | Json |  |
| last_updated_at | Unknown |  |
| name | Unknown |  |

### agreement_member

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agreement_uuid | Unknown | FK |
| organization_id | Unknown | FK |
| user_id | Unknown | FK |
| last_access_at | Unknown |  |
| permission | Unknown |  |
| relation | Unknown |  |
| status | Unknown |  |
| user_sign_status | Unknown |  |

### organization_branding

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| organization_id | Unknown | FK |
| custom_agreement_view_enabled | Unknown |  |
| custom_email_content_enabled | Unknown |  |
| custom_email_content_organization_name | Unknown |  |
| custom_email_content_url | Unknown |  |
| custom_email_sender_email | Unknown |  |
| custom_email_sender_enabled | Unknown |  |
| custom_email_sender_name | Unknown |  |

## Relationships

- organization_group_user(id) → users(id)
- organization_group_user(organization_group_id) → organization_group(id)
- organization_group_invitation(organization_group_id) → organization_group(id)
- organization_group(organization_id) → organization(id)
- agreement_attachment(agreement_uuid) → agreement(uuid)
- agreement_attachment(organization_id) → organization(id)
- organization_detail_email_domain(organization_detail_id) → organization_detail(id)
- organization_detail(id) → organization(id)
- agreement_party(agreement_uuid) → agreement(uuid)
- agreement_tag(agreement_uuid) → agreement(uuid)
- agreement_field(agreement_uuid) → agreement(uuid)
- agreement_property(agreement_uuid) → agreement(uuid)
- agreement(organization_id) → organization(id)
- agreement_version_last_field_value(agreement_version_last_field_uuid) → agreement_version_last_field(uuid)
- agreement_version_last_field_value(agreement_uuid) → agreement_version_last_field(agreement_uuid)
- agreement_version_last_field_option(agreement_version_last_field_uuid) → agreement_version_last_field(uuid)
- agreement_version_last_field_option(agreement_uuid) → agreement_version_last_field(agreement_uuid)
- agreement_version_last_field(reservation_organization_id) → organization(id)
- agreement_version_last_field(reservation_user_id) → users(id)
- agreement_version_last_field(agreement_uuid) → agreement(uuid)
- user_authority(users_id) → users(id)
- users(current_organization_id) → organization(id)
- tag_user(id) → users(id)
- tag_user(tags_id) → tags(id)
- tag_user_group_member(id) → tag_user(id)
- tag_user_group_member(tags_id) → tags(id)
- tag_user_group_member(tag_user_group_id) → tag_user_group(id)
- tag_uer_group_invitation(id) → tag_invitation(id)
- tag_uer_group_invitation(tags_id) → tags(id)
- tag_uer_group_invitation(tag_user_group_id) → tag_user_group(id)
- tag_user_group(tags_id) → tags(id)
- tag_invitation(tags_id) → tags(id)
- tags(organization_id) → organization(id)
- folder_user(id) → users(id)
- folder_user(folder_id) → folder(id)
- folder_team_user(id) → folder_user(id)
- folder_team_user(folder_id) → folder(id)
- folder_team_user(folder_team_id) → folder_team(id)
- folder_team_invitation(id) → folder_invitation(id)
- folder_team_invitation(folder_id) → folder(id)
- folder_team_invitation(folder_team_id) → folder_team(id)
- folder_team(folder_id) → folder(id)
- folder_team(organization_id) → organization(id)
- folder_invitation(folder_id) → folder(id)
- folder_children(parent_id) → folder(id)
- folder(parent_id) → folder(id)
- folder(organization_id) → organization(id)
- agreement_comment_reply(agreement_comment_uuid) → agreement_comment(uuid)
- agreement_comment(agreement_uuid) → agreement(uuid)
- agreement_comment(organization_id) → organization(id)
- agreement_approval_validation(user_id) → users(id)
- agreement_approval_validation(user_organization_id) → organization(id)
- agreement_approval_validation(_fivetran_id) → agreement_approval_rule(_fivetran_id)
- agreement_approval_validation(agreement_approval_rule_id) → agreement_approval_rule(id)
- agreement_approval_rule(_fivetran_id) → agreement_approval(_fivetran_id)
- agreement_approval(agreement_uuid) → agreement(uuid)
- agreement_approval(organization_id) → organization(id)
- signature(reservation_user_id) → users(id)
- signature(reservation_organization_id) → organization(id)
- signature(agreement_uuid) → agreement(uuid)
- agreement_summary_signed_with_label(agreement_summary_id) → agreement_summary(id)
- agreement_summary_clause(agreement_summary_id) → agreement_summary(id)
- agreement_summary_link_permission(agreement_summary_id) → agreement_summary(id)
- agreement_summary_link_permission(agreement_summary_link_id) → agreement_summary_link(id)
- agreement_summary_link(agreement_summary_id) → agreement_summary(id)
- agreement_summary_end_clause(agreement_uid) → agreement(uuid)
- agreement_summary_end_clause(agreement_summary_id) → agreement_summary(id)
- agreement_summary(agreement_uid) → agreement(uuid)
- agreement_summary(organization_id) → organization(id)
- agreement_version_pdf_field(agreement_version_id) → agreement_version(id)
- agreement_version_signature_field(agreement_version_id) → agreement_version(id)
- agreement_version(user_id) → users(id)
- agreement_version(organization_id) → organization(id)
- agreement_version(agreement_uuid) → agreement(uuid)
- subscription_seat(subscription_id) → subscription(id)
- subscription(organization_id) → organization(id)
- organization_workflow_rule_validation(user_id) → users(id)
- organization_workflow_rule_validation(user_organization_id) → organization(id)
- organization_workflow_rule_validation(organization_workflow_id) → organization_workflow(id)
- organization_workflow_rule_validation(organization_workflow_rule_id) → organization_workflow_rule(id)
- organization_workflow_rule(organization_workflow_id) → organization_workflow(id)
- organization_workflow(organization_id) → organization(id)
- agreement_summary_field(agreement_uuid) → agreement(uuid)
- agreement_summary_field(organization_id) → organization(id)
- organization_clause(organization_id) → organization(id)
- event(organization_id) → organization(id)
- agreement_track_change_amendment(agreement_track_change_id) → agreement_track_change(id)
- agreement_track_change(agreement_uuid) → agreement(uuid)
- agreement_track_change(organization_id) → organization(id)
- agreement_path_user(id) → users(id)
- agreement_path_user(agreement_path_id) → agreement_path(id)
- agreement_path_team_user(id) → agreement_path_user(id)
- agreement_path_team_user(agreement_path_id) → agreement_path(id)
- agreement_path_team_user(agreement_path_team_id) → agreement_path_team(id)
- agreement_path_team_invitation(id) → agreement_path_invitation(id)
- agreement_path_team_invitation(agreement_path_id) → agreement_path(id)
- agreement_path_team_invitation(agreement_path_team_id) → agreement_path_team(id)
- agreement_path_team(organization_id) → organization(id)
- agreement_path_team(agreement_path_id) → agreement_path(id)
- agreement_path_invitation(agreement_path_id) → agreement_path(id)
- agreement_path(parent_id) → agreement_path(id)
- agreement_path(agreement_uuid) → agreement(uuid)
- agreement_path(organization_id) → organization(id)
- organization_member_group(id) → organization_group(id)
- organization_member_group(_fivetran_id) → organization_member(_fivetran_id)
- organization_member_group(organization_id) → organization_member(organization_id)
- organization_member(user_id) → users(id)
- organization_member(organization_id) → organization(id)
- organization_subsidary(organization_id) → organization(id)
- report_filter_status(report_id) → report(id)
- report_filter_status(organization_id) → report(organization_id)
- report_filter_created_by(created_by) → users(id)
- report_filter_created_by(report_id) → report(id)
- report_filter_created_by(organization_id) → report(organization_id)
- report(organization_id) → organization(id)
- agreement_member(user_id) → users(id)
- agreement_member(organization_id) → organization(id)
- agreement_member(agreement_uuid) → agreement(uuid)
- organization_branding(organization_id) → organization(id)