PandaDoc
Explore the interactive ERD
Table & Field Reference
contact
| Column | Type | Keys |
|---|---|---|
id | String | PK |
city | String | |
company | String | |
country | String | |
email | String | |
first_name | String | |
job_title | String | |
last_name | String | |
phone | String | |
postal_code | String | |
state | String | |
street_address | String |
content_library_item_token
| Column | Type | Keys |
|---|---|---|
name | String | PK |
content_library_item_id | String | PKFK |
value | String |
content_library_item_tag
| Column | Type | Keys |
|---|---|---|
name | String | PK |
content_library_item_id | String | PKFK |
content_library_item_role
| Column | Type | Keys |
|---|---|---|
id | String | PK |
content_library_item_id | String | PKFK |
name | String | |
preassigned_person | String | |
signing_order | Long |
content_library_item_field
| Column | Type | Keys |
|---|---|---|
id | String | PK |
content_library_item_id | String | PKFK |
assigned_to | String | |
field_identifier | Unknown | |
name | String | |
placeholder | String | |
title | String | |
type | Unknown | |
value | String |
content_library_item_pricing_table_item
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
content_library_item_id | String | PKFK |
content_library_item_pricing_table_id | Unknown | PKFK |
cost | Double | |
description | String | |
discount | String | |
id | String | |
name | String | |
price | Double | |
qty | Double | |
sale_price | Double | |
sku | String | |
subtotal | String | |
tax_first | String | |
tax_second | String | |
custom_** |
content_library_item_pricing_table
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
content_library_item_id | String | PKFK |
currency | Unknown | |
is_included_in_total | Unknown | |
name | Unknown | |
total | Unknown |
content_library_item_image_url
| Column | Type | Keys |
|---|---|---|
url | Unknown | PK |
content_library_item_id | String | PKFK |
content_library_item_image_block_uuid | Unknown | PKFK |
content_library_item_image
| Column | Type | Keys |
|---|---|---|
block_uuid | Unknown | PK |
content_library_item_id | String | PKFK |
name | Unknown |
content_library_item_content_placeholder
| Column | Type | Keys |
|---|---|---|
uuid | Unknown | PK |
content_library_item_id | String | PKFK |
block_id | Unknown | |
description | Unknown |
content_library_item
| Column | Type | Keys |
|---|---|---|
id | String | PK |
created_by | String | FK |
date_created | Instant | |
date_modified | Instant | |
name | String | |
version | String | |
custom_** |
template_token
| Column | Type | Keys |
|---|---|---|
name | String | PK |
template_id | String | PKFK |
value | String |
template_tag
| Column | Type | Keys |
|---|---|---|
name | String | PK |
template_id | String | PKFK |
template_role
| Column | Type | Keys |
|---|---|---|
id | String | PK |
template_id | String | PKFK |
name | String | |
preassigned_person | String | |
signing_order | Long |
template_field
| Column | Type | Keys |
|---|---|---|
id | String | PK |
template_id | String | PKFK |
assigned_to | String | FK |
field_identifier | Unknown | |
name | String | |
placeholder | String | |
title | String | |
type | Unknown | |
value | String |
template_pricing_table_item
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
template_id | String | PKFK |
template_pricing_table_id | Unknown | PKFK |
cost | Double | |
description | String | |
discount | String | |
id | String | |
name | String | |
price | Double | |
qty | Double | |
sale_price | Double | |
sku | String | |
subtotal | String | |
tax_first | String | |
tax_second | String | |
custom_** |
template_pricing_table_column
| Column | Type | Keys |
|---|---|---|
index | Long | PK |
template_id | String | PKFK |
template_pricing_table_id | Unknown | PKFK |
header | String | |
hidden | Boolean | |
merge_name | String | |
name | String |
template_pricing_table
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
template_id | String | PKFK |
currency | Unknown | |
is_included_in_total | Unknown | |
name | Unknown | |
total | Unknown |
template_pricing_quote_recurring_subtotal
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
template_id | String | PKFK |
template_pricing_quote_id | Unknown | PKFK |
billing_cycle | Unknown | |
value | Unknown |
template_pricing_quote_section_recurring_subtotal
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
template_id | String | PKFK |
template_pricing_quote_id | Unknown | PKFK |
template_pricing_quote_section_id | Unknown | PKFK |
billing_cycle | Unknown | |
value | Unknown |
template_pricing_quote_section
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
template_id | String | PKFK |
template_pricing_quote_id | Unknown | PKFK |
name | Unknown | |
summary_discounts | Json | |
summary_fees | Json | |
summary_one_time_subtotal | Unknown | |
summary_subtotal | Unknown | |
summary_taxes | Json | |
summary_total | Unknown | |
summary_total_qty | Unknown | |
summary_total_section_value | Unknown | |
total | Unknown |
template_pricing_quote_merge_rule_condition_comparison
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
template_id | String | PKFK |
template_pricing_quote_id | Unknown | PKFK |
template_pricing_quote_merge_rule_id | Unknown | PKFK |
type | Unknown | |
value | Unknown |
template_pricing_quote_merge_rule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
template_id | String | PKFK |
template_pricing_quote_id | Unknown | PKFK |
action_section_id | Unknown | |
action_type | Unknown | |
condition_field_name | Unknown | |
condition_type | Unknown | |
enabled | Unknown |
template_pricing_quote
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
template_id | String | PKFK |
currency | Unknown | |
settings_selection_type | Unknown | |
summary_fees | Json | |
summary_one_time_subtotal | Unknown | |
summary_subtotal | Unknown | |
summary_taxes | Json | |
summary_total | Unknown | |
summary_total_contract_value | Unknown | |
summary_total_discount | Unknown | |
summary_total_fee | Unknown | |
summary_total_qty | Unknown | |
summary_total_savings | Unknown | |
summary_total_tax | Unknown | |
total | Unknown |
template_image_url
| Column | Type | Keys |
|---|---|---|
url | Unknown | PK |
template_id | String | PKFK |
template_image_block_uuid | Unknown | PKFK |
template_image
| Column | Type | Keys |
|---|---|---|
block_uuid | Unknown | PK |
template_id | String | PKFK |
name | Unknown |
template_content_placeholder
| Column | Type | Keys |
|---|---|---|
uuid | Unknown | PK |
template_id | String | PKFK |
block_id | Unknown | |
description | Unknown |
template
| Column | Type | Keys |
|---|---|---|
id | String | PK |
created_by | String | FK |
content_date_modified | Unknown | |
date_created | Instant | |
date_modified | Instant | |
name | String | |
version | String | |
custom_** |
document_field
| Column | Type | Keys |
|---|---|---|
id | String | PK |
document_id | String | PKFK |
assigned_to | String | FK |
field_id | String | |
merge_field | String | |
name | String | |
placeholder | String | |
title | String | |
type | String | |
value | Unknown |
document_tag
| Column | Type | Keys |
|---|---|---|
name | String | PK |
document_id | String | PKFK |
document_token
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
document_id | String | PKFK |
name | String | |
value | String |
document_recipient_role
| Column | Type | Keys |
|---|---|---|
id | String | PK |
document_id | String | PKFK |
document_recipient_id | String | PKFK |
document_recipient
| Column | Type | Keys |
|---|---|---|
id | String | PK |
document_id | String | PKFK |
contact_id | String | FK |
has_completed | Boolean | |
passcode | Unknown | |
phone_verification | Unknown | |
redirect_is_enabled | Unknown | |
redirect_url | Unknown | |
shared_link | String | |
signature_date | Unknown | |
signing_order | Long | |
type | String | |
verification_place | Unknown |
document_pricing_table_item
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
document_id | String | PKFK |
document_pricing_table_id | Unknown | PKFK |
cost | Double | |
description | String | |
discount | String | |
id | String | |
name | String | |
price | Double | |
qty | Double | |
sale_price | Double | |
sku | String | |
subtotal | String | |
tax_first | String | |
tax_second | String | |
custom_** |
document_pricing_table_column
| Column | Type | Keys |
|---|---|---|
index | Long | PK |
document_id | String | PKFK |
document_pricing_table_id | Unknown | PKFK |
header | String | |
hidden | Boolean | |
merge_name | String | |
name | String |
document_pricing_table
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
document_id | String | PKFK |
currency | Unknown | |
is_included_in_total | Unknown | |
name | Unknown | |
summary_discount | Unknown | |
summary_subtotal | Unknown | |
summary_tax | Unknown | |
summary_total | Unknown | |
total | Unknown |
document_pricing_quote_recurring_subtotal
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
document_id | String | PKFK |
document_pricing_quote_id | Unknown | PKFK |
billing_cycle | Unknown | |
value | Unknown |
document_pricing_quote_section_recurring_subtotal
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
document_id | String | PKFK |
document_pricing_quote_id | Unknown | PKFK |
document_pricing_quote_section_id | Unknown | PKFK |
billing_cycle | Unknown | |
value | Unknown |
document_pricing_quote_section_column
| Column | Type | Keys |
|---|---|---|
index | Long | PK |
name | String | PK |
document_id | String | PKFK |
document_pricing_quote_id | Unknown | PKFK |
document_pricing_quote_section_id | Unknown | PKFK |
header | String | |
hidden | Boolean | |
merge_name | String |
document_pricing_quote_section_item
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
document_id | String | PKFK |
document_pricing_quote_id | Unknown | PKFK |
document_pricing_quote_section_id | Unknown | PKFK |
billing_frequency | Unknown | |
contract_term | Unknown | |
cost | Double | |
discounts_property_1_type | Unknown | |
discounts_property_1_value | Unknown | |
discounts_property_2_type | Unknown | |
discounts_property_2_value | Unknown | |
fees_property_1_type | Unknown | |
fees_property_1_value | Unknown | |
fees_property_2_type | Unknown | |
fees_property_2_value | Unknown | |
id | String | |
name | String | |
price | Double | |
pricing_method | Unknown | |
property_1 | Unknown | |
property_2 | Unknown | |
qty | Double | |
qty_editable | Unknown | |
reference_type | Unknown | |
selected | Unknown | |
sku | String | |
tax_property_1_type | Unknown | |
tax_property_1_value | Unknown | |
tax_property_2_type | Unknown | |
tax_property_2_value | Unknown | |
type | Unknown |
document_pricing_quote_section
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
document_id | String | PKFK |
document_pricing_quote_id | Unknown | PKFK |
name | Unknown | |
summary_discounts | Json | |
summary_fees | Json | |
summary_one_time_subtotal | Unknown | |
summary_subtotal | Unknown | |
summary_taxes | Json | |
summary_total | Unknown | |
summary_total_qty | Unknown | |
summary_total_section_value | Unknown | |
custom_** |
document_pricing_quote_merge_rule_condition_comparison
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
document_id | String | PKFK |
document_pricing_quote_id | Unknown | PKFK |
document_pricing_quote_merge_rule_id | Unknown | PKFK |
type | Unknown | |
value | Unknown |
document_pricing_quote_merge_rule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
document_id | String | PKFK |
document_pricing_quote_id | Unknown | PKFK |
action_section_id | Unknown | |
action_type | Unknown | |
condition_field_name | Unknown | |
condition_type | Unknown | |
enabled | Unknown |
document_pricing_quote
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
document_id | String | PKFK |
currency | Unknown | |
discounts_property_1_type | Unknown | |
discounts_property_1_value | Unknown | |
discounts_property_2_type | Unknown | |
discounts_property_2_value | Unknown | |
settings_selection_type | Unknown | |
summary_fees | Json | |
summary_one_time_subtotal | Unknown | |
summary_subtotal | Unknown | |
summary_taxes | Json | |
summary_total | Unknown | |
summary_total_contract_value | Unknown | |
summary_total_discount | Unknown | |
summary_total_fee | Unknown | |
summary_total_qty | Unknown | |
summary_total_savings | Unknown | |
summary_total_tax | Unknown | |
total | Unknown | |
custom_** |
document_linked_object
| Column | Type | Keys |
|---|---|---|
id | String | PK |
document_id | String | PKFK |
entity_id | String | |
entity_type | String | |
provider | String |
document
| Column | Type | Keys |
|---|---|---|
id | String | PK |
created_by | String | FK |
sent_by | String | FK |
template_id | String | FK |
approval_execution | Unknown | |
autonumbering_sequence_name_prefix | String | |
content_date_modified | Unknown | |
date_completed | Instant | |
date_created | Instant | |
date_modified | Instant | |
date_sent | Unknown | |
expiration_date | Instant | |
grand_total_amount | Double | |
grand_total_currency | String | |
name | String | |
ref_number | Unknown | |
status | Unknown | |
version | String | |
custom_** |
member
| Column | Type | Keys |
|---|---|---|
id | String | PK |
date_created | Instant | |
date_modified | Instant | |
email | String | |
email_verified | Boolean | |
first_name | String | |
is_active | Boolean | |
last_name | String | |
membership_id | String | |
role | String | |
user_license | String | |
workspace | String | |
workspace_name | String |
form
| Column | Type | Keys |
|---|---|---|
id | String | PK |
date_created | Instant | |
date_modified | Instant | |
name | String | |
status | String |