# Siemens Building X Openness schema ERD

Table and field reference for the Fivetran Siemens Building X Openness connector.

## Table & Field Reference

### country

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partition_id | Unknown | PK, FK |
| continent_code | Unknown |  |
| continent_label | Unknown |  |
| label | Unknown |  |

### medium_consumption_cost

| Column | Type | Keys |
| --- | --- | --- |
| timestamps | Instant | PK |
| medium_consumption_list_id | Unknown | PK, FK |
| partition_id | Unknown | PK, FK |
| value | Unknown |  |

### equipment_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partition_id | Unknown | PK, FK |
| parent_id | Unknown | FK |
| create_by | Unknown |  |
| created_at | Instant |  |
| deprecated | Unknown |  |
| description | Unknown |  |
| domain | Unknown |  |
| iri | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |
| updated_by | Unknown |  |

### medium_consumption_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partition_id | Unknown | PK, FK |
| base_discipline | Json |  |
| base_unit | Unknown |  |
| entity_name | Unknown |  |
| entity_reference_id | Unknown |  |
| entity_reference_type | Unknown |  |

### point

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| device_id | Unknown | PK, FK |
| partition_id | Unknown | PK, FK |
| commanding_semantic | Unknown |  |
| create_by | Unknown |  |
| created_at | Instant |  |
| data_type | Unknown |  |
| description | Unknown |  |
| enum | Json |  |
| function | Unknown |  |
| is_active | Unknown |  |
| maximum | Unknown |  |
| minimum | Unknown |  |
| name | Unknown |  |
| precision | Unknown |  |
| source_type | Unknown |  |
| system_attributes | Json |  |
| tags | Json |  |
| timestamps | Instant |  |
| unit | Unknown |  |
| updated_at | Instant |  |
| updated_by | Unknown |  |
| value | Unknown |  |

### point_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partition_id | Unknown | PK, FK |
| point_id | Unknown | PK, FK |
| quality_of_value | Unknown |  |
| target_value | Unknown |  |
| timestamps | Instant |  |
| value | Unknown |  |

### medium_consumption_emission

| Column | Type | Keys |
| --- | --- | --- |
| timestamps | Instant | PK |
| medium_consumption_list_id | Unknown | PK, FK |
| partition_id | Unknown | PK, FK |
| value | Unknown |  |

### point_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partition_id | Unknown | PK, FK |
| create_by | Unknown |  |
| created_at | Instant |  |
| entity_id | Unknown |  |
| entity_type | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |
| updated_by | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| device_id | Unknown | PK, FK |
| partition_id | Unknown | PK, FK |
| produced_by_id | Unknown | FK |
| source_id | Unknown | FK |
| active | Unknown |  |
| category | Unknown |  |
| created_at | Instant |  |
| message | Unknown |  |
| opens | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partition_id | Unknown | PK, FK |
| country_code | Unknown | FK |
| country_name | Unknown |  |
| create_by | Unknown |  |
| created_at | Instant |  |
| locality | Unknown |  |
| postal_code | Unknown |  |
| region | Unknown |  |
| street | Unknown |  |
| updated_at | Instant |  |
| updated_by | Unknown |  |
| additional_prop_** |  |  |

### team_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partition_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| type | Unknown |  |

### equipment_relationship_control

| Column | Type | Keys |
| --- | --- | --- |
| equipment_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### equipment_feed

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| equipment_id | Unknown | PK, FK |

### equipment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| equipment_type_id | Unknown | FK |
| location_id | Unknown | FK |
| partition_id | Unknown | FK |
| create_by | Unknown |  |
| created_at | Instant |  |
| external_id | Unknown |  |
| installation_date | Unknown |  |
| manufactured_by | Unknown |  |
| manufacturing_year | Unknown |  |
| model | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| part_of_id | Unknown |  |
| part_of_type | Unknown |  |
| partition_type | Unknown |  |
| serial_number | Unknown |  |
| updated_at | Instant |  |
| updated_by | Unknown |  |

### team_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| partition_id | Unknown | FK |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partition_id | Unknown | PK, FK |
| create_by | Unknown |  |
| created_at | Instant |  |
| customer_id | Unknown |  |
| customer_type | Unknown |  |
| description | Unknown |  |
| domain | Unknown |  |
| location_count | Unknown |  |
| member_count | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |
| updated_by | Unknown |  |

### time_zone

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partition_id | Unknown | PK, FK |
| label | Unknown |  |

### account_user_group_relationship_access

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_user_group_id | Unknown | PK, FK |
| type | Unknown |  |

### account_user_group_relationship_authorized_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_user_group_id | Unknown | PK, FK |
| type | Unknown |  |

### account_user_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| is_machine_enabled | Unknown |  |
| is_system_defined | Unknown |  |
| name | Unknown |  |
| owned_by_id | Unknown |  |
| owned_by_type | Unknown |  |

### medium_consumption

| Column | Type | Keys |
| --- | --- | --- |
| timestamps | Instant | PK |
| medium_consumption_list_id | Unknown | PK, FK |
| partition_id | Unknown | PK, FK |
| value | Unknown |  |

### location_tag_user_defined_value

| Column | Type | Keys |
| --- | --- | --- |
| user_defined_value | Unknown | PK |
| location_id | Unknown | PK, FK |
| partition_id | Unknown | PK, FK |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partition_id | Unknown | PK, FK |
| postal_address_id | Unknown | FK |
| create_by | Unknown |  |
| created_at | Instant |  |
| description | Unknown |  |
| external_id | Unknown |  |
| geo_area_geometry_coordinates | Json |  |
| geo_area_geometry_type | Unknown |  |
| geo_location_geometry_coordinates | Json |  |
| geo_location_geometry_type | Unknown |  |
| label | Unknown |  |
| primary_contact_email | Unknown |  |
| primary_contact_name | Unknown |  |
| primary_contact_phone | Unknown |  |
| time_zone | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |
| updated_by | Unknown |  |
| user_defined_marker_tag | Unknown |  |

### device_feature

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| device_id | Unknown | PK, FK |
| device_partition_id | Unknown | PK, FK |
| type | Unknown |  |

### device

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partition_id | Unknown | PK |
| location_id | Unknown | FK |
| gateway_id | Unknown |  |
| gateway_type | Unknown |  |
| model_name | Unknown |  |
| profile_external_id | Unknown |  |
| profile_name | Unknown |  |
| profile_notes | Unknown |  |
| serial_number | Unknown |  |

### device_connectivity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partition_id | Unknown | PK |
| device_id | Unknown | FK |
| last_seen_at | Instant |  |
| status | Unknown |  |
| status_note | Unknown |  |

### building_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partition_id | Unknown | PK, FK |
| label | Unknown |  |

## Relationships

- country(partition_id) → account_user_group_relationship_access(id)
- medium_consumption_cost(medium_consumption_list_id) → medium_consumption_list(id)
- medium_consumption_cost(partition_id) → account_user_group_relationship_access(id)
- equipment_type(parent_id) → equipment_type(id)
- equipment_type(partition_id) → account_user_group_relationship_access(id)
- medium_consumption_list(partition_id) → account_user_group_relationship_access(id)
- point(partition_id) → account_user_group_relationship_access(id)
- point(device_id) → device(id)
- point_value(point_id) → point(id)
- point_value(partition_id) → account_user_group_relationship_access(id)
- medium_consumption_emission(medium_consumption_list_id) → medium_consumption_list(id)
- medium_consumption_emission(partition_id) → account_user_group_relationship_access(id)
- point_group(partition_id) → account_user_group_relationship_access(id)
- event(produced_by_id) → device(id)
- event(source_id) → point(id)
- event(device_id) → device(id)
- event(partition_id) → account_user_group_relationship_access(id)
- address(country_code) → country(id)
- address(partition_id) → account_user_group_relationship_access(id)
- team_member(team_id) → team(id)
- team_member(partition_id) → account_user_group_relationship_access(id)
- equipment_relationship_control(id) → device(id)
- equipment_relationship_control(equipment_id) → equipment(id)
- equipment_feed(equipment_id) → equipment(id)
- equipment(equipment_type_id) → equipment_type(id)
- equipment(location_id) → location(id)
- equipment(partition_id) → account_user_group_relationship_access(id)
- team_location(id) → location(id)
- team_location(partition_id) → account_user_group_relationship_access(id)
- team_location(team_id) → team(id)
- team(partition_id) → account_user_group_relationship_access(id)
- time_zone(partition_id) → account_user_group_relationship_access(id)
- account_user_group_relationship_access(account_user_group_id) → account_user_group(id)
- account_user_group_relationship_authorized_role(account_user_group_id) → account_user_group(id)
- medium_consumption(medium_consumption_list_id) → medium_consumption_list(id)
- medium_consumption(partition_id) → account_user_group_relationship_access(id)
- location_tag_user_defined_value(location_id) → location(id)
- location_tag_user_defined_value(partition_id) → location(partition_id)
- location(postal_address_id) → address(id)
- location(partition_id) → account_user_group_relationship_access(id)
- device_feature(device_id) → device(id)
- device_feature(device_partition_id) → device(partition_id)
- device(location_id) → location(id)
- device_connectivity(device_id) → device(id)
- building_type(partition_id) → account_user_group_relationship_access(id)