# Cube schema ERD

Table and field reference for the Fivetran Cube connector.

## Table & Field Reference

### drilldown

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account | Unknown |  |
| account_number | Unknown |  |
| application_of_origin | Unknown |  |
| batch | Unknown |  |
| data_warehouse_account_name | Unknown |  |
| data_warehouse_entity_name | Unknown |  |
| data_warehouse_location_name | Unknown |  |
| data_warehouse_memo | Unknown |  |
| data_warehouse_product_line_name | Unknown |  |
| data_warehouse_service_line_name | Unknown |  |
| department | Unknown |  |
| entity | Unknown |  |
| forecast_as_of | Unknown |  |
| job | Unknown |  |
| location | Unknown |  |
| product_line | Unknown |  |
| reference_1 | Unknown |  |
| reference_2 | Unknown |  |
| scenario | Unknown |  |
| service_line | Unknown |  |
| time | Unknown |  |
| transaction_description | Unknown |  |
| value | Unknown |  |

### dimension

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| active | Unknown |  |
| date | Unknown |  |
| formula | Unknown |  |
| has_children | Unknown |  |
| metadata | Json |  |
| name | Unknown |  |
| position | Unknown |  |
| rollup_type | Unknown |  |
| special_case_id | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| write_block_reason | Unknown |  |
| write_protection | Unknown |  |

### dimension_mapping

| Column | Type | Keys |
| --- | --- | --- |
| source_dimension_id | Unknown | PK |
| dimension_id | Unknown | PK, FK |
| dimension_tld_id | Unknown | FK |
| automapped | Unknown |  |
| created_at | Unknown |  |
| modified_at | Unknown |  |
| modified_by_created_at | Unknown |  |
| modified_by_first_name | Unknown |  |
| modified_by_id | Unknown |  |
| modified_by_is_cube_staff | Unknown |  |
| modified_by_is_staff | Unknown |  |
| modified_by_last_name | Unknown |  |
| modified_by_timezone | Unknown |  |
| sign_flip | Unknown |  |
| source_dimension_active | Unknown |  |
| source_dimension_date | Unknown |  |
| source_dimension_formula | Unknown |  |
| source_dimension_has_children | Unknown |  |
| source_dimension_metadata | Json |  |
| source_dimension_name | Unknown |  |
| source_dimension_parent_id | Unknown |  |
| source_dimension_position | Unknown |  |
| source_dimension_rollup_type | Unknown |  |
| source_dimension_special_case_id | Unknown |  |
| source_dimension_status | Unknown |  |
| source_dimension_tld_active | Unknown |  |
| source_dimension_tld_date | Unknown |  |
| source_dimension_tld_formula | Unknown |  |
| source_dimension_tld_has_children | Unknown |  |
| source_dimension_tld_id | Unknown |  |
| source_dimension_tld_metadata | Json |  |
| source_dimension_tld_name | Unknown |  |
| source_dimension_tld_parent_id | Unknown |  |
| source_dimension_tld_position | Unknown |  |
| source_dimension_tld_rollup_type | Unknown |  |
| source_dimension_tld_special_case_id | Unknown |  |
| source_dimension_tld_status | Unknown |  |
| source_dimension_tld_type | Unknown |  |
| source_dimension_tld_write_block_reason | Unknown |  |
| source_dimension_tld_write_protection | Unknown |  |
| source_dimension_type | Unknown |  |
| source_dimension_write_block_reason | Unknown |  |
| source_dimension_write_protection | Unknown |  |

## Relationships

- dimension(parent_id) → dimension(id)
- dimension_mapping(dimension_id) → dimension(id)
- dimension_mapping(dimension_tld_id) → dimension(id)