# LinkSquares schema ERD

Table and field reference for the Fivetran LinkSquares connector.

## Table & Field Reference

### finalize_template_question_id

| Column | Type | Keys |
| --- | --- | --- |
| finalize_template_id | Unknown | PK, FK |
| question_id | Unknown | PK, FK |

### finalize_template_token_id

| Column | Type | Keys |
| --- | --- | --- |
| finalize_template_id | Unknown | PK, FK |
| token_id | Unknown | PK, FK |

### finalize_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| description | Unknown |  |
| instructions | Unknown |  |
| kind | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### finalize_template_question_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| finalize_template_id | Unknown | PK, FK |
| finalize_template_question_id | Unknown | PK, FK |
| description | Unknown |  |

### finalize_template_question

| Column | Type | Keys |
| --- | --- | --- |
| finalize_template_id | Unknown | PK |
| id | Unknown | PK |
| answer_type | Unknown |  |
| attachment_id | Json |  |
| description | Unknown |  |
| required | Unknown |  |

### finalize_template_token_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| finalize_template_id | Unknown | PK, FK |
| finalize_template_token_id | Unknown | PK, FK |
| value | Unknown |  |

### finalize_template_token

| Column | Type | Keys |
| --- | --- | --- |
| finalize_template_id | Unknown | PK |
| id | Unknown | PK |
| clause_category_id | Unknown |  |
| clause_category_name | Unknown |  |
| kind | Unknown |  |
| question | Unknown |  |
| required | Unknown |  |

### finalize_agreement_collaborator

| Column | Type | Keys |
| --- | --- | --- |
| collaborator_id | Unknown | PK |
| finalize_agreement_id | Unknown | PK, FK |

### finalize_agreement_question

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| finalize_agreement_id | Unknown | PK, FK |

### finalize_agreement_token_value

| Column | Type | Keys |
| --- | --- | --- |
| token_value_id | Unknown | PK |
| finalize_agreement_id | Unknown | PK, FK |

### finalize_agreement_embedded_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| finalize_agreement_id | Unknown | PK, FK |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |

### finalize_agreement_embedded_question_answer_selected_option

| Column | Type | Keys |
| --- | --- | --- |
| finalize_agreement_embedded_question_id | Unknown | PK, FK |
| finalize_agreement_id | Unknown | PK, FK |
| selected_option_id | Unknown | PK, FK |

### finalize_agreement_embedded_question_attachment

| Column | Type | Keys |
| --- | --- | --- |
| attachment_id | Unknown | PK |
| finalize_agreement_embedded_question_id | Unknown | PK, FK |
| finalize_agreement_id | Unknown | PK, FK |

### finalize_agreement_embedded_question_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| finalize_agreement_embedded_question_id | Unknown | PK, FK |
| finalize_agreement_id | Unknown | PK, FK |
| description | Unknown |  |

### finalize_agreement_embedded_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| finalize_agreement_id | Unknown | PK, FK |
| answer_id | Unknown |  |
| answer_type | Unknown |  |
| answer_value | Unknown |  |
| description | Unknown |  |
| required | Unknown |  |

### finalize_agreement_embedded_token_value_selected_option

| Column | Type | Keys |
| --- | --- | --- |
| selected_option_id | Unknown | PK |
| finalize_agreement_embedded_token_value_id | Unknown | PK, FK |
| finalize_agreement_id | Unknown | PK, FK |

### finalize_agreement_embedded_token_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| finalize_agreement_id | Unknown | PK, FK |
| token_id | Unknown |  |
| value | Unknown |  |

### finalize_agreement_embedded_status

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

### finalize_agreement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| status_id | Unknown | FK |
| template_id | Unknown | FK |
| analyze_agreement_id | Unknown |  |
| author_id | Unknown |  |
| created_at | Unknown |  |
| kind | Unknown |  |
| name | Unknown |  |
| owner_id | Unknown |  |
| status_updated_at | Instant |  |

### analyze_clause_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### finalize_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| internal_enum | Unknown |  |
| name | Unknown |  |

### finalize_agreement_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| finalize_agreement_id | Unknown | PK, FK |
| created_at | Unknown |  |
| file_name | Unknown |  |

### analyze_agreement_child_agreement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| index | Unknown | PK |
| analyze_agreement_id | Unknown | PK, FK |

### analyze_agreement_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| analyze_agreement_id | Unknown | PK, FK |
| name | Unknown |  |

### analyze_agreement_term

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| analyze_agreement_id | Unknown | PK, FK |
| kind | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| value | Unknown |  |

### analyze_agreement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| type_id | Unknown | FK |
| name | Unknown |  |
| original_name | Unknown |  |
| parent_agreement_id | Unknown |  |
| updated_date | Instant |  |
| upload_date | Unknown |  |
| uploaded_by | Unknown |  |

### analyze_user

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| status | Unknown |  |
| timestamps | Unknown |  |
| users | Unknown |  |

### finalize_user

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| status | Unknown |  |
| timestamps | Unknown |  |
| users | Unknown |  |

### analyze_agreement_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| is_smart | Unknown |  |
| name | Unknown |  |

### analyze_clause

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreement_id | Unknown | FK |
| clause_category_id | Unknown | FK |
| author_name | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| text | Unknown |  |
| updated_at | Unknown |  |

### finalize_agreement_version

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| finalize_agreement_id | Unknown | PK, FK |
| status_id | Unknown | FK |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| file_name | Unknown |  |

## Relationships

- finalize_template_question_id(question_id) → finalize_template_question(id)
- finalize_template_question_id(finalize_template_id) → finalize_template(id)
- finalize_template_token_id(token_id) → finalize_template_token(id)
- finalize_template_token_id(finalize_template_id) → finalize_template(id)
- finalize_template_question_option(finalize_template_question_id) → finalize_template_question(id)
- finalize_template_question_option(finalize_template_id) → finalize_template_question(finalize_template_id)
- finalize_template_token_option(finalize_template_token_id) → finalize_template_token(id)
- finalize_template_token_option(finalize_template_id) → finalize_template_token(finalize_template_id)
- finalize_agreement_collaborator(finalize_agreement_id) → finalize_agreement(id)
- finalize_agreement_question(finalize_agreement_id) → finalize_agreement(id)
- finalize_agreement_token_value(finalize_agreement_id) → finalize_agreement(id)
- finalize_agreement_embedded_user(finalize_agreement_id) → finalize_agreement(id)
- finalize_agreement_embedded_question_answer_selected_option(selected_option_id) → finalize_agreement_embedded_question_option(id)
- finalize_agreement_embedded_question_answer_selected_option(finalize_agreement_id) → finalize_agreement_embedded_question(finalize_agreement_id)
- finalize_agreement_embedded_question_answer_selected_option(finalize_agreement_embedded_question_id) → finalize_agreement_embedded_question(id)
- finalize_agreement_embedded_question_attachment(finalize_agreement_id) → finalize_agreement_embedded_question(finalize_agreement_id)
- finalize_agreement_embedded_question_attachment(finalize_agreement_embedded_question_id) → finalize_agreement_embedded_question(id)
- finalize_agreement_embedded_question_option(finalize_agreement_id) → finalize_agreement_embedded_question(finalize_agreement_id)
- finalize_agreement_embedded_question_option(finalize_agreement_embedded_question_id) → finalize_agreement_embedded_question(id)
- finalize_agreement_embedded_question(finalize_agreement_id) → finalize_agreement(id)
- finalize_agreement_embedded_token_value_selected_option(finalize_agreement_id) → finalize_agreement_embedded_token_value(finalize_agreement_id)
- finalize_agreement_embedded_token_value_selected_option(finalize_agreement_embedded_token_value_id) → finalize_agreement_embedded_token_value(id)
- finalize_agreement_embedded_token_value(finalize_agreement_id) → finalize_agreement(id)
- finalize_agreement_embedded_status(finalize_agreement_id) → finalize_agreement(id)
- finalize_agreement(template_id) → finalize_template(id)
- finalize_agreement(status_id) → finalize_status(id)
- finalize_agreement_attachment(finalize_agreement_id) → finalize_agreement(id)
- analyze_agreement_child_agreement(analyze_agreement_id) → analyze_agreement(id)
- analyze_agreement_tag(analyze_agreement_id) → analyze_agreement(id)
- analyze_agreement_term(analyze_agreement_id) → analyze_agreement(id)
- analyze_agreement(type_id) → analyze_agreement_type(id)
- analyze_clause(agreement_id) → analyze_agreement(id)
- analyze_clause(clause_category_id) → analyze_clause_category(id)
- finalize_agreement_version(status_id) → finalize_status(id)
- finalize_agreement_version(finalize_agreement_id) → finalize_agreement(id)