# IBACOS schema ERD

Table and field reference for the Fivetran IBACOS connector.

## 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 | PK, FK |
| type | Unknown |  |
| value | Unknown |  |

### scorecard_value_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| scorecard_id | Unknown | PK, FK |
| 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 | PK, FK |
| calculated_score | Unknown |  |
| display_value | Unknown |  |
| name | Unknown |  |
| score | Unknown |  |

### assessment_forecast_score

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| assessment_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- processed_task_count_value(realm_id) → realm(id)
- processed_task_count_values_resource(parent_id) → processed_task_count_values_resource(id)
- user_resource(parent_id) → user_resource(id)
- scorecard_order_override(scorecard_id) → scorecard(id)
- scorecard_value_label(scorecard_id) → scorecard(id)
- scorecard(owner_realm_id) → realm(id)
- scorecard_resource(parent_id) → scorecard_resource(id)
- scored_value(assessment_id) → assessment(id)
- scored_value(scorecard_id) → scorecard(id)
- task(scorecard_score_id) → scored_value(id)
- assessment_score(assessment_id) → assessment(id)
- assessment_forecast_score(assessment_id) → assessment(id)
- assessment(realm_id) → realm(id)
- assessment(access_realm_id) → realm(id)
- realm(realm_parent_id) → realm(id)