Fivetran documentation

Search the docs

/

IBACOS

Explore the interactive ERD

Table & Field Reference

processed_task_count_value

Column	Type	Keys
`id`	Unknown	PK
`realm_id`	Unknown	FK
`closed`	Unknown
`created_at`	Unknown
`latest_task_update_datetime`	Unknown
`oldest_open_task_datetime`	Unknown
`open_task_count`	Unknown
`pending`	Unknown
`realm_name`	Unknown
`realm_tier`	Unknown
`total`	Unknown
`type`	Unknown
`updated_at`	Unknown

processed_task_count_values_resource

Column	Type	Keys
`id`	Unknown	PK
`parent_id`	Unknown	FK
`explicit_value`	Unknown
`name`	Unknown
`tier`	Unknown
`type`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`email`	Unknown
`name`	Unknown
`status`	Unknown
`type`	Unknown
`updated`	Unknown
`updated_at`	Unknown

user_resource

Column	Type	Keys
`id`	Unknown	PK
`parent_id`	Unknown	FK
`explicit_value`	Unknown
`name`	Unknown
`tier`	Unknown
`type`	Unknown

scorecard_order_override

Column	Type	Keys
`id`	Unknown	PK
`scorecard_id`	Unknown	PKFK
`type`	Unknown
`value`	Unknown

scorecard_value_label

Column	Type	Keys
`index`	Unknown	PK
`scorecard_id`	Unknown	PKFK
`label`	Unknown
`value`	Unknown

scorecard

Column	Type	Keys
`id`	Unknown	PK
`owner_realm_id`	Unknown	FK
`active`	Unknown
`created_at`	Unknown
`edition_id`	Unknown
`has_assessments`	Unknown
`has_scores`	Unknown
`name`	Unknown
`type`	Unknown
`updated_at`	Unknown
`custom_`

scorecard_resource

Column	Type	Keys
`id`	Unknown	PK
`parent_id`	Unknown	FK
`config_display_percentage`	Unknown
`config_max_score`	Unknown
`config_min_score`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`edition_type`	Unknown
`explicit_value`	Unknown
`image`	Unknown
`latest_id`	Unknown
`links_self`	Unknown
`name`	Unknown
`owner_realm_id`	Unknown
`status`	Unknown
`tier`	Unknown
`type`	Unknown
`updated_at`	Unknown
`user_can_edit`	Unknown

scored_value

Column	Type	Keys
`id`	Unknown	PK
`assessment_id`	Unknown	FK
`scorecard_id`	Unknown	FK
`calculated_score`	Unknown
`checklist_id`	Unknown
`checkpoint_id`	Unknown
`created_at`	Unknown
`criteria`	Unknown
`depth`	Unknown
`display_score`	Unknown
`display_value`	Unknown
`filters`	Unknown
`images`	Unknown
`name`	Unknown
`notes`	Unknown
`orders`	Unknown
`status`	Unknown
`superset_id`	Unknown
`system_id`	Unknown
`template_score_id`	Unknown
`template_unchanged`	Unknown
`type`	Unknown
`updated_at`	Instant
`value`	Unknown

task

Column	Type	Keys
`id`	Unknown	PK
`scorecard_score_id`	Unknown	FK
`checkpoint_id`	Unknown
`client_id`	Unknown
`created_at`	Unknown
`description`	Unknown
`due_date`	Unknown
`meta_notes_required`	Unknown
`meta_photos_required`	Unknown
`name`	Unknown
`status`	Unknown
`type`	Unknown
`updated_at`	Unknown
`vendor_id`	Unknown

task_resource

Column	Type	Keys
`id`	Unknown	PK
`collection_name`	Unknown
`created_at`	Unknown
`custom_properties_generated_conversions_thumb`	Unknown
`download_url`	Unknown
`file_name`	Unknown
`full_url`	Unknown
`media_id`	Unknown
`name`	Unknown
`order_column`	Unknown
`thumb_url`	Unknown
`type`	Unknown
`updated_at`	Unknown
`url`	Unknown

assessment_score

Column	Type	Keys
`index`	Unknown	PK
`assessment_id`	Unknown	PKFK
`calculated_score`	Unknown
`display_value`	Unknown
`name`	Unknown
`score`	Unknown

assessment_forecast_score

Column	Type	Keys
`index`	Unknown	PK
`assessment_id`	Unknown	PKFK
`calculated_score`	Unknown
`display_value`	Unknown
`forecast_score`	Unknown
`name`	Unknown

assessment

Column	Type	Keys
`id`	Unknown	PK
`access_realm_id`	Unknown	FK
`realm_id`	Unknown	FK
`client_id`	Unknown
`completion_date`	Unknown
`created_at`	Unknown
`description`	Unknown
`end_date`	Unknown
`forecast_origin_id`	Unknown
`locked`	Unknown
`name`	Unknown
`start_date`	Unknown
`status`	Unknown
`type`	Unknown
`updated_at`	Instant
`vendor_id`	Unknown
`visibility`	Unknown

realm

Column	Type	Keys
`id`	Unknown	PK
`realm_parent_id`	Unknown	FK
`explicit_value`	Unknown
`name`	Unknown
`tier`	Unknown
`type`	Unknown