Ironclad Clickwrap

Explore the interactive ERD

Table & Field Reference

contract_version_field

Column	Type	Keys
`index`	Unknown	PK
`contract_version_id`	Unknown	PKFK
`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	PKFK
`text`	Unknown

contract_version_token

Column	Type	Keys
`index`	Unknown	PK
`contract_version_id`	Unknown	PKFK
`token`	Unknown

contract_version_merge_field

Column	Type	Keys
`index`	Unknown	PK
`contract_version_id`	Unknown	PKFK
`merge_field`	Unknown

contract_version_tag

Column	Type	Keys
`index`	Unknown	PK
`contract_version_id`	Unknown	PKFK
`tags`	Unknown

contract_version_country

Column	Type	Keys
`index`	Unknown	PK
`contract_version_id`	Unknown	PKFK
`country`	Unknown

contract_version_locale

Column	Type	Keys
`index`	Unknown	PK
`contract_version_id`	Unknown	PKFK
`locale`	Unknown

contract_version

Column	Type	Keys
`id`	Unknown	PK
`contract_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`tags`	Unknown

contract_country

Column	Type	Keys
`index`	Unknown	PK
`contract_id`	Unknown	PKFK
`country`	Unknown

contract_locale

Column	Type	Keys
`index`	Unknown	PK
`contract_id`	Unknown	PKFK
`locale`	Unknown

contract_used

Column	Type	Keys
`index`	Unknown	PK
`contract_id`	Unknown	PKFK
`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	PKFK
`contract_id`	Unknown	FK

group_tag

Column	Type	Keys
`index`	Unknown	PK
`groups_id`	Unknown	PKFK
`tags`	Unknown

group_target_jurisdiction

Column	Type	Keys
`index`	Unknown	PK
`groups_id`	Unknown	PKFK
`jurisdiction`	Unknown

group_validate_unique_classification

Column	Type	Keys
`index`	Unknown	PK
`groups_id`	Unknown	PKFK
`classification`	Unknown

group_snapshot_location

Column	Type	Keys
`index`	Unknown	PK
`groups_id`	Unknown	PKFK
`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	PKFK
`photo`	Unknown

user_profile_email

Column	Type	Keys
`index`	Unknown	PK
`user_profile_id`	Unknown	PKFK
`email`	Unknown

user_profile

Column	Type	Keys
`id`	Unknown	PK
`users_id`	Unknown	PKFK
`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