Porowhita Hauwhā test data: facilities_attributes_bridge_table — test_facilities_attributes_bridge

A subset of the data stored in the Porowhitā Hauwha table called facilities_attributes_bridge_table.

When information about a facility is updated, an entry is created in this table to note what changed, when the change occurred, and why it changed.

Usage

test_facilities_attributes_bridge_table

A data frame with 2 rows and 9 columns:

id: Unique identifier. This is the primary key for the table.
facility_attribute_id: Foreign key to join on the facilities_attributes table.
facility_type: Is the facility an asset, a space, or an entity?
facility_id: Foreign key for joining on the assets, spaces, or entities table.
attribute: Which field has changed its value?
value: What is the changed value?
valid_from: On which date did this change take effect?
valid_to: Until when is this change valid?
notes: What is the reason for this change?