Fivetran documentation

Search the docs

/

Dropbox Sign

Explore the interactive ERD

Table & Field Reference

template_document_field

Column	Type	Keys
`id`	String	PK
`template_id`	String	PK
`template_document_id`	String	PKFK
`avg_text_length_num_chars_per_line`	Long
`avg_text_length_num_lines`	Long
`field_group`	String
`field_kind`	Unknown
`font_family`	String
`height`	Long
`is_multiline`	Boolean
`name`	String
`original_font_size`	Long
`required`	Boolean
`signer`	String
`type`	String
`validation_type`	String
`width`	Long
`x`	Long
`y`	Long

template_signer_role

Column	Type	Keys
`id`	String	PK
`template_id`	String	PKFK
`signer_order`	Long

template_document

Column	Type	Keys
`id`	String	PK
`template_id`	String	PKFK

template_document_field_group

Column	Type	Keys
`id`	String	PK
`template_id`	String	PK
`template_document_id`	String	PKFK
`rule_group_label`	String
`rule_requirement`	String

template

Column	Type	Keys
`id`	Unknown	PK
`can_edit`	Unknown
`is_creator`	Unknown
`is_embedded`	Unknown
`is_locked`	Unknown
`message`	Unknown
`metadata`	Unknown
`title`	Unknown
`updated_at`	Unknown

template_account

Column	Type	Keys
`account_id`	String	PK
`template_id`	String	PKFK

template_cc_role

Column	Type	Keys
`id`	String	PK
`template_id`	String	PKFK

signature_request_template

Column	Type	Keys
`template_id`	String	PK
`_fivetran_id`	Unknown	PKFK

signature_request_custom_field

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`api_id`	String
`editor`	String
`name`	String
`required`	Boolean
`type`	String
`value`	String

signature_request_attachment

Column	Type	Keys
`id`	String	PK
`_fivetran_id`	Unknown	PKFK
`instructions`	String
`name`	String
`required`	Boolean
`signer`	String
`uploaded_at`	Instant

signature_request_cc_email

Column	Type	Keys
`id`	String	PK
`_fivetran_id`	Unknown	PKFK

signature

Column	Type	Keys
`id`	String	PK
`_fivetran_id`	Unknown	PKFK
`decline_reason`	String
`error`	String
`has_pin`	String
`has_sms_auth`	Boolean
`has_sms_delivery`	Boolean
`last_reminded_at`	Instant
`last_viewed_at`	Instant
`reassigned_by`	String
`reassigned_from`	String
`reassignment_reason`	String
`signed_at`	Instant
`signer_email_address`	String
`signer_group_guid`	String
`signer_name`	String
`signer_order`	Long
`signer_role`	String
`sms_phone_number`	String
`status_code`	String

signature_response

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`signature_id`	String	FK
`field_id`	String
`name`	String
`required`	Boolean
`type`	String
`value`	String

signature_request

Column	Type	Keys
`_fivetran_id`	String	PK
`requester_email_address`	String	FK
`created_at`	Instant
`details_url`	String
`expires_at`	Instant
`files_url`	String
`has_error`	Boolean
`id`	String
`is_complete`	Boolean
`is_declined`	Boolean
`message`	String
`metadata`	Json
`original_title`	String
`signing_url`	String
`subject`	String
`title`	String

team_account

Column	Type	Keys
`id`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`email_address`	Unknown
`is_locked`	Unknown
`is_paid_hf`	Unknown
`is_paid_hs`	Unknown
`locale`	Unknown
`quotas_api_signature_requests_left`	Unknown
`quotas_documents_left`	Unknown
`quotas_sms_verifications_left`	Unknown
`quotas_templates_left`	Unknown
`role_code`	Unknown
`team_id`	Unknown

team

Column	Type	Keys
`_fivetran_id`	String	PK
`invited_account`	Json
`name`	String