A subset of the data stored in the Porowhitā Hauwha table called entity_bridge_table.
An entity is composed of at least two records in either the assets, spaces, or services tables. This table joins the entity to the assets, spaces, or service from which it is formed.
This data has been made available for use in package documentation examples, and for the user to explore the kind of information stored in the live Porowhita Hauwhā database.
Format
'test_entity_bridge_table'
A data frame with 4 rows and 7 columns:
- id
Unique identifier. This is the primary key for the table.
- facility_type
Describes whether this facility is an asset, a space, or an entity.
- facility_id
A foreign key for joining to the relevant facilities table, as defined by
facility_type.- entity_id
A foreign key for joining to the
entitiestable.- valid_from
A date defining a point in time from which this relationship was established.
- valid_to
A date defining a point in time from which this relationship was disestablished.
- notes
An explanation for why this relationship was disestablished.