A subset of the data stored in the Porowhitā Hauwha table called
partners_bridge_table.
This table records the relationship between partners and facilities. Not
every partner is associated with a facility, but the majority who are will
be included here. Full details on partners are found in the partners
table, and full details on facilities can be found either in assets,
spaces, or entities, together with their common attributes
recorded in the facilities_attributes table.
Format
'test_partners_bridge_table'
A data frame with 1 row and 4 columns:
- id
Unique identifier. This is the primary key for the table.
- partner_id
Foreign key for joining to the
partnerstable.- 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.