What is the relationship between a site and a facility?
The Active Places database base in structured so that a single site may have one or more facilities associated with it (a one to many relationship). Each site and each individual facility sub type will have a unique ID. As the below example shows these numbers may be very similar but never the same.
The below example for Aireville School in North Yorkshire CSP shows a single site (i.e. Aireville School - unique id of 1010263), which has three sports hall facilities - one main hall (2008384) and two activity halls (2026284 and 2026285).
Site Name |
Site Id |
Facility Type |
Facility Sub Type |
Facility Id |
Unit |
Number |
Facility Status |
… |
AIREVILLE SCHOOL |
1010263 |
Sports Hall |
Main |
2008384 |
Badminton courts |
3 |
Operational |
… |
AIREVILLE SCHOOL |
1010263 |
Sports Hall |
Activity Hall |
2026284 |
Badminton courts |
1 |
Operational |
… |
AIREVILLE SCHOOL |
1010263 |
Sports Hall |
Activity Hall |
2026285 |
Badminton courts |
1 |
Operational |
… |