# Dropbox Sign schema ERD

Table and field reference for the Fivetran Dropbox Sign connector.

## Table & Field Reference

### template_document_field

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| template_id | String | PK |
| template_document_id | String | PK, FK |
| 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 | PK, FK |
| signer_order | Long |  |

### template_document

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| template_id | String | PK, FK |

### template_document_field_group

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| template_id | String | PK |
| template_document_id | String | PK, FK |
| 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 | PK, FK |

### template_cc_role

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| template_id | String | PK, FK |

### signature_request_template

| Column | Type | Keys |
| --- | --- | --- |
| template_id | String | PK |
| _fivetran_id | Unknown | PK, FK |

### signature_request_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| 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 | PK, FK |
| instructions | String |  |
| name | String |  |
| required | Boolean |  |
| signer | String |  |
| uploaded_at | Instant |  |

### signature_request_cc_email

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

### signature

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| _fivetran_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- template_document_field(template_document_id) → template_document(id)
- template_signer_role(template_id) → template(id)
- template_document(template_id) → template(id)
- template_document_field_group(template_document_id) → template_document(id)
- template_account(template_id) → template(id)
- template_cc_role(template_id) → template(id)
- signature_request_template(_fivetran_id) → signature_request(_fivetran_id)
- signature_request_custom_field(_fivetran_id) → signature_request(_fivetran_id)
- signature_request_attachment(_fivetran_id) → signature_request(_fivetran_id)
- signature_request_cc_email(_fivetran_id) → signature_request(_fivetran_id)
- signature(_fivetran_id) → signature_request(_fivetran_id)
- signature_response(signature_id) → signature(id)
- signature_response(_fivetran_id) → signature_request(_fivetran_id)
- signature_request(requester_email_address) → team_account(email_address)
- team_account(_fivetran_id) → team(_fivetran_id)