LinkSquares
Explore the interactive ERD
Table & Field Reference
finalize_template_question_id
| Column | Type | Keys |
|---|---|---|
finalize_template_id | Unknown | PKFK |
question_id | Unknown | PKFK |
finalize_template_token_id
| Column | Type | Keys |
|---|---|---|
finalize_template_id | Unknown | PKFK |
token_id | Unknown | PKFK |
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 | PKFK |
finalize_template_question_id | Unknown | PKFK |
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 | PKFK |
finalize_template_token_id | Unknown | PKFK |
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 | PKFK |
finalize_agreement_question
| Column | Type | Keys |
|---|---|---|
question_id | Unknown | PK |
finalize_agreement_id | Unknown | PKFK |
finalize_agreement_token_value
| Column | Type | Keys |
|---|---|---|
token_value_id | Unknown | PK |
finalize_agreement_id | Unknown | PKFK |
finalize_agreement_embedded_user
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
finalize_agreement_id | Unknown | PKFK |
email | Unknown | |
first_name | Unknown | |
last_name | Unknown |
finalize_agreement_embedded_question_answer_selected_option
| Column | Type | Keys |
|---|---|---|
finalize_agreement_embedded_question_id | Unknown | PKFK |
finalize_agreement_id | Unknown | PKFK |
selected_option_id | Unknown | PKFK |
finalize_agreement_embedded_question_attachment
| Column | Type | Keys |
|---|---|---|
attachment_id | Unknown | PK |
finalize_agreement_embedded_question_id | Unknown | PKFK |
finalize_agreement_id | Unknown | PKFK |
finalize_agreement_embedded_question_option
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
finalize_agreement_embedded_question_id | Unknown | PKFK |
finalize_agreement_id | Unknown | PKFK |
description | Unknown |
finalize_agreement_embedded_question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
finalize_agreement_id | Unknown | PKFK |
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 | PKFK |
finalize_agreement_id | Unknown | PKFK |
finalize_agreement_embedded_token_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
finalize_agreement_id | Unknown | PKFK |
token_id | Unknown | |
value | Unknown |
finalize_agreement_embedded_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
finalize_agreement_id | Unknown | PKFK |
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 | PKFK |
created_at | Unknown | |
file_name | Unknown |
analyze_agreement_child_agreement
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
index | Unknown | PK |
analyze_agreement_id | Unknown | PKFK |
analyze_agreement_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
analyze_agreement_id | Unknown | PKFK |
name | Unknown |
analyze_agreement_term
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
analyze_agreement_id | Unknown | PKFK |
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 | PKFK |
status_id | Unknown | FK |
created_at | Unknown | |
deleted_at | Unknown | |
file_name | Unknown |