Siemens Building X Openness

Explore the interactive ERD

Table & Field Reference

country

Column	Type	Keys
`id`	Unknown	PK
`partition_id`	Unknown	PKFK
`continent_code`	Unknown
`continent_label`	Unknown
`label`	Unknown

medium_consumption_cost

Column	Type	Keys
`timestamps`	Instant	PK
`medium_consumption_list_id`	Unknown	PKFK
`partition_id`	Unknown	PKFK
`value`	Unknown

equipment_type

Column	Type	Keys
`id`	Unknown	PK
`partition_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`partition_id`	Unknown	PKFK
`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	PKFK
`point_id`	Unknown	PKFK
`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	PKFK
`partition_id`	Unknown	PKFK
`value`	Unknown

point_group

Column	Type	Keys
`id`	Unknown	PK
`partition_id`	Unknown	PKFK
`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	PKFK
`partition_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`team_id`	Unknown	PKFK
`type`	Unknown

equipment_relationship_control

Column	Type	Keys
`equipment_id`	Unknown	PKFK
`id`	Unknown	PKFK

equipment_feed

Column	Type	Keys
`id`	Unknown	PK
`equipment_id`	Unknown	PKFK

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	PKFK
`team_id`	Unknown	PKFK
`partition_id`	Unknown	FK

team

Column	Type	Keys
`id`	Unknown	PK
`partition_id`	Unknown	PKFK
`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	PKFK
`label`	Unknown

account_user_group_relationship_access

Column	Type	Keys
`id`	Unknown	PK
`account_user_group_id`	Unknown	PKFK
`type`	Unknown

account_user_group_relationship_authorized_role

Column	Type	Keys
`id`	Unknown	PK
`account_user_group_id`	Unknown	PKFK
`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	PKFK
`partition_id`	Unknown	PKFK
`value`	Unknown

location_tag_user_defined_value

Column	Type	Keys
`user_defined_value`	Unknown	PK
`location_id`	Unknown	PKFK
`partition_id`	Unknown	PKFK

location

Column	Type	Keys
`id`	Unknown	PK
`partition_id`	Unknown	PKFK
`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	PKFK
`device_partition_id`	Unknown	PKFK
`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	PKFK
`label`	Unknown