Fivetran documentation

Search the docs

/

Ironclad

Explore the interactive ERD

Table & Field Reference

schema_attribute

Column	Type	Keys
`name`	String	PK
`schema_id`	String	PKFK
`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	PKFK
`reviewer_type`	String
`status`	String

workflow_participant

Column	Type	Keys
`user_id`	String	PKFK
`workflow_id`	String	PKFK

record_link

Column	Type	Keys
`link_record_id`	String	PKFK
`record_id`	String	PKFK

record_property

Column	Type	Keys
`name`	Unknown	PK
`record_id`	String	PKFK
`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	PKFK
`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	PKFK
`value`	Unknown

workflow_schema

Column	Type	Keys
`id`	String	PK
`name`	String

workflow_record

Column	Type	Keys
`record_id`	String	PKFK
`workflow_id`	String	PKFK

workflow_role_assignee

Column	Type	Keys
`user_id`	String	PKFK
`workflow_role_id`	String	PKFK
`workflow_role_workflow_id`	String	PKFK

workflow_role

Column	Type	Keys
`id`	String	PK
`workflow_id`	String	PKFK
`display_name`	String

workflow_attribute

Column	Type	Keys
`name`	Unknown	PK
`workflow_id`	String	PKFK
`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	PKFK
`schema_id`	String	PKFK

group_member

Column	Type	Keys
`groups_id`	String	PKFK
`user_id`	String	PKFK
`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	PKFK
`users_id`	String	PKFK

user_email

Column	Type	Keys
`value`	String	PK
`users_id`	String	PKFK
`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	PKFK
`workflow_signer_workflow_id`	String	PKFK
`delegate_name`	Unknown

workflow_signer

Column	Type	Keys
`email`	String	PK
`workflow_id`	String	PKFK
`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	PKFK
`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	PKFK

entity

Column	Type	Keys
`id`	Unknown	PK
`ironclad_id`	Unknown
`last_updated`	Unknown
`name`	Unknown
`status`	Unknown
`properties_`