# Statistics Netherlands CBS schema ERD

Table and field reference for the Fivetran Statistics Netherlands CBS connector.

## Table & Field Reference

### measure_group

| Column | Type | Keys |
| --- | --- | --- |
| catalog_identifier | String | PK |
| id | Unknown | PK |
| index | Unknown | PK |
| parent_id | Unknown | FK |
| description | Unknown |  |
| title | Unknown |  |

### provenance

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| catalog_identifier | String | PK, FK |
| property_identifier | Unknown | PK, FK |
| title | Unknown |  |
| url | Unknown |  |

### related_source

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| catalog_identifier | String | PK, FK |
| property_identifier | Unknown | PK, FK |
| title | Unknown |  |
| url | Unknown |  |

### distribution

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| catalog_identifier | String | PK, FK |
| property_identifier | Unknown | PK, FK |
| access_url | Unknown |  |
| download_url | Unknown |  |
| format | Unknown |  |
| languages | Unknown |  |
| media_type | Unknown |  |

### property

| Column | Type | Keys |
| --- | --- | --- |
| catalog_identifier | String | PK |
| identifier | Unknown | PK |
| authority | Unknown |  |
| catalog | Unknown |  |
| contact_point | Unknown |  |
| dataset_type | Unknown |  |
| description | Unknown |  |
| frequency | Unknown |  |
| graph_types | Unknown |  |
| languages | Unknown |  |
| license | Unknown |  |
| long_descrition | Unknown |  |
| modification_date | Unknown |  |
| modified | Unknown |  |
| observation_count | Unknown |  |
| observations_modified | Unknown |  |
| publisher | Unknown |  |
| release_date | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |
| summary | Unknown |  |
| temporal_coverage | Unknown |  |
| title | Unknown |  |
| version | Unknown |  |
| version_notes | Unknown |  |
| version_reason | Unknown |  |

### measure_code

| Column | Type | Keys |
| --- | --- | --- |
| catalog_identifier | String | PK |
| identifier | Unknown | PK |
| index | Unknown | PK |
| measure_group_id | Unknown | FK |
| data_type | Unknown |  |
| decimal | Unknown |  |
| description | Unknown |  |
| presentation_type | Unknown |  |
| title | Unknown |  |
| unit | Unknown |  |

### industries_branches_sbi_2008_code

| Column | Type | Keys |
| --- | --- | --- |
| catalog_identifier | String | PK |
| identifier | Unknown | PK |
| index | Unknown | PK |
| description | Unknown |  |
| dimention_group_id | Unknown |  |
| title | Unknown |  |

### perioden_codes

| Column | Type | Keys |
| --- | --- | --- |
| catalog_identifier | String | PK |
| identifier | Unknown | PK |
| index | Unknown | PK |
| description | Unknown |  |
| dimensions_group_id | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |

### dimensions

| Column | Type | Keys |
| --- | --- | --- |
| catalog_identifier | String | PK |
| identifier | Unknown | PK |
| contains_codes | Unknown |  |
| contains_groups | Unknown |  |
| description | Unknown |  |
| kind | Unknown |  |
| map_year | Unknown |  |
| release_policy | Unknown |  |
| title | Unknown |  |

### observation

| Column | Type | Keys |
| --- | --- | --- |
| catalog_identifier | String | PK |
| id | Unknown | PK |
| measure | Unknown | FK |
| perioden | Unknown | FK |
| industries_branches_sbi_2008 | Unknown |  |
| string_value | Unknown |  |
| value | Unknown |  |
| value_attribute | Unknown |  |

### industries_branches_sbi_2008_group

| Column | Type | Keys |
| --- | --- | --- |
| catalog_identifier | String | PK |
| id | Unknown | PK |
| index | Unknown | PK |
| parent_id | Unknown | FK |
| description | Unknown |  |
| title | Unknown |  |

### perioden_groups

| Column | Type | Keys |
| --- | --- | --- |
| catalog_identifier | String | PK |
| id | Unknown | PK |
| index | Unknown | PK |
| description | Unknown |  |
| parent_id | Unknown |  |
| title | Unknown |  |

## Relationships

- measure_group(parent_id) → measure_group(id)
- provenance(property_identifier) → property(identifier)
- provenance(catalog_identifier) → property(catalog_identifier)
- related_source(property_identifier) → property(identifier)
- related_source(catalog_identifier) → property(catalog_identifier)
- distribution(property_identifier) → property(identifier)
- distribution(catalog_identifier) → property(catalog_identifier)
- measure_code(measure_group_id) → measure_group(id)
- observation(measure) → measure_code(identifier)
- observation(perioden) → perioden_codes(identifier)
- industries_branches_sbi_2008_group(parent_id) → industries_branches_sbi_2008_group(id)