# Ironclad schema ERD

Table and field reference for the Fivetran Ironclad connector.

## Table & Field Reference

### schema_attribute

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| schema_id | String | PK, FK |
| description | String |  |
| multi_valued | Boolean |  |
| mutability | String |  |
| required | Boolean |  |
| returned | String |  |
| sub_attributes | Json |  |
| type | String |  |

### schema

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| description | String |  |
| meta_location | String |  |
| meta_resource_type | String |  |
| name | String |  |

### workflow_reviewer

| Column | Type | Keys |
| --- | --- | --- |
| display_name | String | PK |
| role | String | PK |
| workflow_id | String | PK, FK |
| reviewer_type | String |  |
| status | String |  |

### workflow_participant

| Column | Type | Keys |
| --- | --- | --- |
| user_id | String | PK, FK |
| workflow_id | String | PK, FK |

### record_link

| Column | Type | Keys |
| --- | --- | --- |
| link_record_id | String | PK, FK |
| record_id | String | PK, FK |

### record_property

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| record_id | String | PK, FK |
| value | Unknown |  |

### record

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| source_workflow_id | String | FK |
| _fivetran_file_path | String |  |
| ironclad_id | Unknown |  |
| last_updated | Instant |  |
| name | String |  |
| signed_copy_content_type | String |  |
| signed_copy_filename | String |  |
| signed_copy_href | String |  |
| source_type | String |  |
| type | String |  |

### record_type_metadata

| Column | Type | Keys |
| --- | --- | --- |
| record_type_key | Unknown | PK |
| record_type | Unknown |  |

### record_property_metadata

| Column | Type | Keys |
| --- | --- | --- |
| property_key | Unknown | PK |
| property | Unknown |  |

### record_attachment_metadata

| Column | Type | Keys |
| --- | --- | --- |
| attachment_key | Unknown | PK |
| attachment | Unknown |  |

### record_link_metadata

| Column | Type | Keys |
| --- | --- | --- |
| link_key | Unknown | PK |
| link | Unknown |  |

### turn_history

| Column | Type | Keys |
| --- | --- | --- |
| turn_number | Unknown | PK |
| turn_start_time | Unknown | PK |
| workflow_id | String | PK, FK |
| turn_end_time | Unknown |  |
| turn_location | Unknown |  |
| turn_party | Unknown |  |
| turn_user_email | Unknown |  |
| turn_user_id | Unknown |  |

### workflow_schema_property

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| workflow_schema_id | String | PK, FK |
| value | Unknown |  |

### workflow_schema

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| name | String |  |

### workflow_record

| Column | Type | Keys |
| --- | --- | --- |
| record_id | String | PK, FK |
| workflow_id | String | PK, FK |

### workflow_role_assignee

| Column | Type | Keys |
| --- | --- | --- |
| user_id | String | PK, FK |
| workflow_role_id | String | PK, FK |
| workflow_role_workflow_id | String | PK, FK |

### workflow_role

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| workflow_id | String | PK, FK |
| display_name | String |  |

### workflow_attribute

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| workflow_id | String | PK, FK |
| value | Unknown |  |

### workflow

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| creator_id | String | FK |
| template | String | FK |
| approvals_state | Unknown |  |
| approvals_url | Unknown |  |
| contract_approval_timestamp | Instant |  |
| contract_execution_date | Instant |  |
| created | Instant |  |
| ironclad_id | Unknown |  |
| is_cancelled | Boolean |  |
| is_complete | Boolean |  |
| is_revertible_to_review | Boolean |  |
| last_updated | Instant |  |
| signatures_state | String |  |
| signatures_url | String |  |
| status | String |  |
| step | String |  |
| title | String |  |

### group_schema

| Column | Type | Keys |
| --- | --- | --- |
| groups_id | String | PK, FK |
| schema_id | String | PK, FK |

### group_member

| Column | Type | Keys |
| --- | --- | --- |
| groups_id | String | PK, FK |
| user_id | String | PK, FK |
| ref | String |  |
| type | String |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| display_name | String |  |
| external_id | String |  |

### user_schema

| Column | Type | Keys |
| --- | --- | --- |
| schema_id | String | PK, FK |
| users_id | String | PK, FK |

### user_email

| Column | Type | Keys |
| --- | --- | --- |
| value | String | PK |
| users_id | String | PK, FK |
| is_primary | Boolean |  |
| type | String |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| active | Boolean |  |
| family_name | String |  |
| given_name | String |  |
| user_name | String |  |

### workflow_signer_delegate

| Column | Type | Keys |
| --- | --- | --- |
| delegate_email | Unknown | PK |
| workflow_signer_email | String | PK, FK |
| workflow_signer_workflow_id | String | PK, FK |
| delegate_name | Unknown |  |

### workflow_signer

| Column | Type | Keys |
| --- | --- | --- |
| email | String | PK |
| workflow_id | String | PK, FK |
| role_name | String |  |
| signature_status | String |  |

### approval_request

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| workflow_id | String | FK |
| actor_id | Unknown |  |
| actor_type | Unknown |  |
| aggregate_duration | Unknown |  |
| approval_type | Unknown |  |
| duration | Unknown |  |
| end_time | Unknown |  |
| role | Unknown |  |
| role_name | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |

### type_hash_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| entity_relationship_type_id | Unknown | PK, FK |
| data | Unknown |  |

### entity_relationship_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown |  |
| description | Unknown |  |
| display_name | Unknown |  |
| kind | Unknown |  |
| name | Unknown |  |
| type_hash_type | Unknown |  |
| properties_** |  |  |

### entity_named_type_id

| Column | Type | Keys |
| --- | --- | --- |
| named_type_id | Unknown | PK |
| entity_id | Unknown | PK, FK |

### entity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ironclad_id | Unknown |  |
| last_updated | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| properties_** |  |  |

## Relationships

- schema_attribute(schema_id) → schema(id)
- workflow_reviewer(workflow_id) → workflow(id)
- workflow_participant(user_id) → users(id)
- workflow_participant(workflow_id) → workflow(id)
- record_link(link_record_id) → record(id)
- record_link(record_id) → record(id)
- record_property(record_id) → record(id)
- record(source_workflow_id) → workflow(id)
- turn_history(workflow_id) → workflow(id)
- workflow_schema_property(workflow_schema_id) → workflow_schema(id)
- workflow_record(record_id) → record(id)
- workflow_record(workflow_id) → workflow(id)
- workflow_role_assignee(user_id) → users(id)
- workflow_role_assignee(workflow_role_id) → workflow_role(id)
- workflow_role_assignee(workflow_role_workflow_id) → workflow_role(workflow_id)
- workflow_role(workflow_id) → workflow(id)
- workflow_attribute(workflow_id) → workflow(id)
- workflow(template) → workflow_schema(id)
- workflow(creator_id) → users(id)
- group_schema(schema_id) → schema(id)
- group_schema(groups_id) → groups(id)
- group_member(user_id) → users(id)
- group_member(groups_id) → groups(id)
- user_schema(schema_id) → schema(id)
- user_schema(users_id) → users(id)
- user_email(users_id) → users(id)
- workflow_signer_delegate(workflow_signer_workflow_id) → workflow_signer(workflow_id)
- workflow_signer_delegate(workflow_signer_email) → workflow_signer(email)
- workflow_signer(workflow_id) → workflow(id)
- approval_request(workflow_id) → workflow(id)
- type_hash_data(entity_relationship_type_id) → entity_relationship_type(id)
- entity_named_type_id(entity_id) → entity(id)