# Ironclad Clickwrap schema ERD

Table and field reference for the Fivetran Ironclad Clickwrap connector.

## Table & Field Reference

### contract_version_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contract_version_id | Unknown | PK, FK |
| assigned_to | Unknown |  |
| assignment_value | Unknown |  |
| complete | Unknown |  |
| completed_time | Instant |  |
| completed_value | Unknown |  |
| default_value | Unknown |  |
| field_id | Unknown |  |
| input_value | Unknown |  |
| is_trigger | Unknown |  |
| label | Unknown |  |
| locations | Json |  |
| locked | Unknown |  |
| name | Unknown |  |
| options | Unknown |  |
| persona | Unknown |  |
| read_only | Unknown |  |
| required | Unknown |  |
| secure | Unknown |  |
| secure_value | Unknown |  |
| trigger_field | Unknown |  |
| trigger_match_value | Unknown |  |
| type | Unknown |  |

### contract_version_text

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contract_version_id | Unknown | PK, FK |
| text | Unknown |  |

### contract_version_token

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contract_version_id | Unknown | PK, FK |
| token | Unknown |  |

### contract_version_merge_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contract_version_id | Unknown | PK, FK |
| merge_field | Unknown |  |

### contract_version_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contract_version_id | Unknown | PK, FK |
| tags | Unknown |  |

### contract_version_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contract_version_id | Unknown | PK, FK |
| country | Unknown |  |

### contract_version_locale

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contract_version_id | Unknown | PK, FK |
| locale | Unknown |  |

### contract_version

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_id | Unknown | PK, FK |
| body | Unknown |  |
| body_language | Unknown |  |
| change_summary | Unknown |  |
| contract | Unknown |  |
| created_by | Unknown |  |
| created_time | Instant |  |
| deprecated_time | Instant |  |
| dynamic | Unknown |  |
| editor_version | Unknown |  |
| effective_time | Instant |  |
| effective_until_time | Instant |  |
| full_version_number | Unknown |  |
| is_major_version | Unknown |  |
| location | Unknown |  |
| major_version | Unknown |  |
| minor_version_number | Unknown |  |
| pages | Unknown |  |
| processing | Unknown |  |
| scheduled_by | Unknown |  |
| scheduled_time | Instant |  |
| status | Unknown |  |
| thumbnail_location | Unknown |  |
| updated_by | Unknown |  |
| updated_time | Instant |  |
| version_number | Unknown |  |
| merge_** |  |  |
| render_** |  |  |

### activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_id | Unknown | FK |
| group_id | Unknown | FK |
| signer_id | Unknown | FK |
| site | Unknown | FK |
| version | Unknown | FK |
| account | Unknown |  |
| batch | Unknown |  |
| cookies | Unknown |  |
| created_time | Instant |  |
| device_fingerprint | Unknown |  |
| environment | Unknown |  |
| event_type | Unknown |  |
| hostname | Unknown |  |
| operating_system | Unknown |  |
| page_domain | Unknown |  |
| page_path | Unknown |  |
| page_query | Unknown |  |
| page_title | Unknown |  |
| referrer | Unknown |  |
| remote_address | Unknown |  |
| screen_color_depth | Unknown |  |
| screen_resolution | Unknown |  |
| user_agent | Unknown |  |
| uuid | Unknown |  |
| custom_** |  |  |

### legal_contract

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| legal_id | Unknown | PK, FK |
| contract_id | Unknown | FK |

### legal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| site | Unknown | FK |
| account | Unknown |  |
| do_not_index | Unknown |  |
| hide_deprecated_versions | Unknown |  |
| is_default | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| pending_changes | Unknown |  |
| published | Unknown |  |
| published_time | Instant |  |
| updated_by | Unknown |  |
| updated_time | Instant |  |

### signer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| site | Unknown | FK |
| account | Unknown |  |
| additional_prop | Unknown |  |
| city | Unknown |  |
| company_name | Unknown |  |
| created_time | Instant |  |
| deliverable_email | Unknown |  |
| deliverable_email_status | Unknown |  |
| deliverable_mobile_number | Unknown |  |
| deliverable_mobile_number_status | Unknown |  |
| email | Unknown |  |
| email_hash | Unknown |  |
| is_valid | Unknown |  |
| last_action | Unknown |  |
| last_downloaded_by | Unknown |  |
| last_downloaded_time | Instant |  |
| latest_activity_time | Instant |  |
| mobile_number | Unknown |  |
| name | Unknown |  |
| notify | Unknown |  |
| screened_date | Unknown |  |
| sendable | Unknown |  |
| signer_source | Unknown |  |
| status | Unknown |  |
| test_mode | Unknown |  |
| title | Unknown |  |
| updated_time | Instant |  |
| uuid | Unknown |  |
| render_** |  |  |

### contract_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contract_id | Unknown | PK, FK |
| tags | Unknown |  |

### contract_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contract_id | Unknown | PK, FK |
| country | Unknown |  |

### contract_locale

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contract_id | Unknown | PK, FK |
| locale | Unknown |  |

### contract_used

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contract_id | Unknown | PK, FK |
| value | Unknown |  |

### contract

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| latest_version | Unknown | FK |
| published_version | Unknown | FK |
| site | Unknown | FK |
| account | Unknown |  |
| archived | Unknown |  |
| archived_by | Unknown |  |
| archived_time | Instant |  |
| classification | Unknown |  |
| created_by | Unknown |  |
| created_time | Instant |  |
| deleted | Unknown |  |
| deleted_by | Unknown |  |
| deleted_time | Instant |  |
| description | Unknown |  |
| enabled | Unknown |  |
| key | Unknown |  |
| language_direction | Unknown |  |
| private | Unknown |  |
| protected | Unknown |  |
| public | Unknown |  |
| published | Unknown |  |
| published_by | Unknown |  |
| published_time | Instant |  |
| record_type | Unknown |  |
| shared | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| updated_by | Unknown |  |
| updated_time | Instant |  |
| render_** |  |  |

### group_contract

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| groups_id | Unknown | PK, FK |
| contract_id | Unknown | FK |

### group_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| groups_id | Unknown | PK, FK |
| tags | Unknown |  |

### group_target_jurisdiction

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| groups_id | Unknown | PK, FK |
| jurisdiction | Unknown |  |

### group_validate_unique_classification

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| groups_id | Unknown | PK, FK |
| classification | Unknown |  |

### group_snapshot_location

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| groups_id | Unknown | PK, FK |
| location_id | Unknown | FK |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| published_by | Unknown | FK |
| site | Unknown | FK |
| updated_by | Unknown | FK |
| acceptance_language | Unknown |  |
| account | Unknown |  |
| alert_message | Unknown |  |
| always_visible | Unknown |  |
| auto_run | Unknown |  |
| badge_text | Unknown |  |
| block_submission | Unknown |  |
| confirmation_email | Unknown |  |
| container_selector | Unknown |  |
| created_time | Instant |  |
| custom_styles | Unknown |  |
| deleted | Unknown |  |
| deleted_by | Unknown |  |
| deleted_time | Instant |  |
| description | Unknown |  |
| display_all | Unknown |  |
| download_contract | Unknown |  |
| dynamic | Unknown |  |
| expect_agreed_click | Unknown |  |
| expect_disagreed | Unknown |  |
| force_scroll | Unknown |  |
| form_selector | Unknown |  |
| hide_record_summary | Unknown |  |
| image_path | Unknown |  |
| instructions | Unknown |  |
| is_associated_with_location | Unknown |  |
| key | Unknown |  |
| last_captured_time | Unknown |  |
| latest | Unknown |  |
| name | Unknown |  |
| notification_email | Unknown |  |
| open_legal_center | Unknown |  |
| opt_out_language | Unknown |  |
| paused | Unknown |  |
| paused_by | Unknown |  |
| paused_time | Instant |  |
| pending_changes | Unknown |  |
| position | Unknown |  |
| published | Unknown |  |
| published_endpoint | Unknown |  |
| published_time | Instant |  |
| rendered_by_user | Unknown |  |
| signer_id_selector | Unknown |  |
| snapshot_config | Unknown |  |
| snapshots_enabled | Unknown |  |
| style | Unknown |  |
| target_selector | Unknown |  |
| type | Unknown |  |
| updated_time | Instant |  |
| render_** |  |  |

### user_profile_photo

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_profile_id | Unknown | PK, FK |
| photo | Unknown |  |

### user_profile_email

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_profile_id | Unknown | PK, FK |
| email | Unknown |  |

### user_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| users_id | Unknown | PK, FK |
| created_time | Instant |  |
| display_name | Unknown |  |
| family_name | Unknown |  |
| provider | Unknown |  |
| updated_time | Instant |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| department | Unknown |  |
| email | Unknown |  |
| locale | Unknown |  |
| name | Unknown |  |
| systems | Unknown |  |
| time_zone | Unknown |  |
| verified | Unknown |  |
| verified_time | Instant |  |

### site

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| acceptance_language | Unknown |  |
| access_id | Unknown |  |
| account | Unknown |  |
| adoption_level | Unknown |  |
| approval_order | Unknown |  |
| base_publish_url | Unknown |  |
| company_city | Unknown |  |
| company_country | Unknown |  |
| company_name | Unknown |  |
| company_postal_code | Unknown |  |
| company_state | Unknown |  |
| company_street | Unknown |  |
| created_time | Instant |  |
| deleted | Unknown |  |
| deleted_by | Unknown |  |
| deleted_time | Instant |  |
| disabled | Unknown |  |
| email_allow_override | Unknown |  |
| email_display_name | Unknown |  |
| email_reply_address | Unknown |  |
| enable_allowed_domains | Unknown |  |
| enforce_limits | Unknown |  |
| first_acceptance_time | Instant |  |
| is_primary | Unknown |  |
| key | Unknown |  |
| legal_center_url | Unknown |  |
| locale | Unknown |  |
| mobile_acceptance_language | Unknown |  |
| mobile_friendly | Unknown |  |
| name | Unknown |  |
| require_signer_verification | Unknown |  |
| sandbox | Unknown |  |
| time_zone | Unknown |  |
| updated_time | Instant |  |
| verified | Unknown |  |
| verified_time | Instant |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| published_by | Unknown | FK |
| site | Unknown | FK |
| updated_by | Unknown | FK |
| account | Unknown |  |
| archived | Unknown |  |
| archived_reason | Unknown |  |
| capture_attempt | Unknown |  |
| created_time | Unknown |  |
| description | Unknown |  |
| error_message | Unknown |  |
| frequency | Unknown |  |
| key | Unknown |  |
| last_acceptance | Unknown |  |
| location_type | Unknown |  |
| name | Unknown |  |
| platform | Unknown |  |
| published | Unknown |  |
| published_time | Unknown |  |
| status | Unknown |  |
| updated_time | Unknown |  |

## Relationships

- contract_version_field(contract_version_id) → contract_version(id)
- contract_version_text(contract_version_id) → contract_version(id)
- contract_version_token(contract_version_id) → contract_version(id)
- contract_version_merge_field(contract_version_id) → contract_version(id)
- contract_version_tag(contract_version_id) → contract_version(id)
- contract_version_country(contract_version_id) → contract_version(id)
- contract_version_locale(contract_version_id) → contract_version(id)
- contract_version(contract_id) → contract(id)
- activity(signer_id) → signer(id)
- activity(group_id) → groups(id)
- activity(contract_id) → contract(id)
- activity(site) → site(id)
- activity(version) → contract_version(id)
- legal_contract(contract_id) → contract(id)
- legal_contract(legal_id) → legal(id)
- legal(site) → site(id)
- signer(site) → site(id)
- contract_tag(contract_id) → contract(id)
- contract_country(contract_id) → contract(id)
- contract_locale(contract_id) → contract(id)
- contract_used(contract_id) → contract(id)
- contract(site) → site(id)
- contract(latest_version) → contract_version(id)
- contract(published_version) → contract_version(id)
- group_contract(contract_id) → contract(id)
- group_contract(groups_id) → groups(id)
- group_tag(groups_id) → groups(id)
- group_target_jurisdiction(groups_id) → groups(id)
- group_validate_unique_classification(groups_id) → groups(id)
- group_snapshot_location(location_id) → location(id)
- group_snapshot_location(groups_id) → groups(id)
- groups(created_by) → users(id)
- groups(site) → site(id)
- groups(published_by) → users(id)
- groups(updated_by) → users(id)
- user_profile_photo(user_profile_id) → user_profile(id)
- user_profile_email(user_profile_id) → user_profile(id)
- user_profile(users_id) → users(id)
- site(created_by) → users(id)
- site(updated_by) → users(id)
- location(created_by) → users(id)
- location(site) → site(id)
- location(published_by) → users(id)
- location(updated_by) → users(id)