Concord
Explore the interactive ERD
Table & Field Reference
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 | PKFK |
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 |
signature
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agreement_uuid | Unknown | PKFK |
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 |
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 |
organization_member_group
| Column | Type | Keys |
|---|---|---|
_fivetran_id | Unknown | PKFK |
id | Unknown | PKFK |
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 |
folder_user
| Column | Type | Keys |
|---|---|---|
folder_id | Unknown | PKFK |
id | Unknown | PKFK |
job | Unknown | |
pictures_normal | Unknown | |
pictures_small | Unknown | |
pictures_special | Unknown |
folder_team_user
| Column | Type | Keys |
|---|---|---|
folder_id | Unknown | PKFK |
folder_team_id | Unknown | PKFK |
id | Unknown | PKFK |
folder_team_invitation
| Column | Type | Keys |
|---|---|---|
folder_id | Unknown | PKFK |
folder_team_id | Unknown | PKFK |
id | Unknown | PKFK |
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 | PKFK |
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 |
organization_group_user
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
organization_group_id | Unknown | PKFK |
organization_group_invitation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_group_id | Unknown | PKFK |
created_at | Unknown | |
email | Unknown | |
uuid | Unknown |
organization_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | FK |
name | Unknown |
organization_workflow_rule_validation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_workflow_id | Unknown | PKFK |
organization_workflow_rule_id | Unknown | PKFK |
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 | PKFK |
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_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_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 |
user_authority
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
users_id | Unknown | PKFK |
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 | PKFK |
tags_id | Unknown | PKFK |
job | Unknown | |
pictures_normal | Unknown | |
pictures_small | Unknown | |
pictures_special | Unknown |
tag_user_group_member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
tag_user_group_id | Unknown | PKFK |
tags_id | Unknown | PKFK |
tag_uer_group_invitation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
tag_user_group_id | Unknown | PKFK |
tags_id | Unknown | PKFK |
tag_user_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
tags_id | Unknown | PKFK |
description | Unknown | |
name | Unknown |
tag_invitation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
tags_id | Unknown | PKFK |
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 |
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 |
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 |
agreement_summary_signed_with_label
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
agreement_summary_id | Unknown | PKFK |
signed_with_label | Unknown |
agreement_summary_clause
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agreement_summary_id | Unknown | PKFK |
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 | PKFK |
agreement_summary_link_id | Unknown | PKFK |
link_permission | Unknown |
agreement_summary_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agreement_summary_id | Unknown | PKFK |
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 | PKFK |
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 |
organization_subsidary
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
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 |
agreement_summary_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agreement_uuid | Unknown | PKFK |
organization_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
agreement_party
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
agreement_uuid | Unknown | PKFK |
party | Unknown |
agreement_tag
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
agreement_uuid | Unknown | PKFK |
agreement_field
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
agreement_uuid | Unknown | FK |
organization_field_item_uuid | Unknown | |
value | Json |
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 | PKFK |
agreement_version_last_field_uuid | Unknown | PKFK |
value | Unknown |
agreement_version_last_field_option
| Column | Type | Keys |
|---|---|---|
key | Unknown | PK |
agreement_uuid | Unknown | PKFK |
agreement_version_last_field_uuid | Unknown | PKFK |
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 | PKFK |
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 |
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 |
report_filter_status
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
organization_id | Unknown | PKFK |
report_id | Unknown | PKFK |
status | Unknown |
report_filter_created_by
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
organization_id | Unknown | PKFK |
report_id | Unknown | PKFK |
created_by | Unknown | FK |
report
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
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_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 |
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_approval_validation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
_fivetran_id | Unknown | PKFK |
agreement_approval_rule_id | Unknown | PKFK |
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 | PKFK |
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 |
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 |
agreement_path_user
| Column | Type | Keys |
|---|---|---|
agreement_path_id | Unknown | PKFK |
id | Unknown | PKFK |
job | Unknown | |
pictures_normal | Unknown | |
pictures_small | Unknown | |
pictures_special | Unknown |
agreement_path_team_user
| Column | Type | Keys |
|---|---|---|
agreement_path_id | Unknown | PKFK |
agreement_path_team_id | Unknown | PKFK |
id | Unknown | PKFK |
agreement_path_team_invitation
| Column | Type | Keys |
|---|---|---|
agreement_path_id | Unknown | PKFK |
agreement_path_team_id | Unknown | PKFK |
id | Unknown | PKFK |
agreement_path_team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agreement_path_id | Unknown | PKFK |
organization_id | Unknown | FK |
description | Unknown | |
name | Unknown |
agreement_path_invitation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agreement_path_id | Unknown | PKFK |
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 |