Summary
- Information standards
- Technical standards and specifications
- Government organisations
- Public sector bodies
- NHS trusts
- NHS foundation trusts
- Integrated care boards
- Vendors
- Digital Health Agencies and NGOs
- Data
- Data definitions and terminologies
- Form
- Open
- Referrals
- Service
- Community health
- Social care
- Record and share information about public services in local authorities
- ORUK
- Human Services Data Specification (HSDS)
Contact Point
Documentation
Data Model Diagram for the Open Referral UK data model v3.0
///mermaid erDiagram accTitle: Data Model Diagram for the Open Referral UK data model v3.0 accDescr: Entity relationship diagram illustrating the Open Referral UK v3.0 data standard schema. ORGANIZATION { string id PK string name string description string email string url string logo string uri } SERVICE { string id PK string organization_id FK string name string description string url string email string status } LOCATION { string id PK string location_type string name string description float latitude float longitude string external_identifier } SERVICE_LOCATION { string service_id PK,FK string location_id PK,FK } ADDRESS { string id PK string location_id FK string address_1 string city string state_province string postal_code string country string address_type } CONTACT { string id PK string organization_id FK string service_id FK string location_id FK string name string title } PHONE { string id PK string contact_id FK string service_id FK string location_id FK string number string description } SCHEDULE { string id PK string service_id FK string location_id FK string service_at_location_id FK int opens_at int closes_at string valid_from string valid_to } TAXONOMY { string id PK string name string vocabulary string description } TAXONOMY_TERM { string id PK string taxonomy_id FK string name string description string parent_id FK } ORGANIZATION ||--o{ SERVICE : provides ORGANIZATION ||--o{ CONTACT : has SERVICE ||--o{ SERVICE_LOCATION : delivered_at LOCATION ||--o{ SERVICE_LOCATION : hosts LOCATION ||--o{ ADDRESS : has LOCATION ||--o{ CONTACT : has SERVICE ||--o{ CONTACT : has CONTACT ||--o{ PHONE : has SERVICE ||--o{ PHONE : has LOCATION ||--o{ PHONE : has SERVICE ||--o{ SCHEDULE : has LOCATION ||--o{ SCHEDULE : has TAXONOMY ||--o{ TAXONOMY_TERM : contains TAXONOMY_TERM ||--o{ TAXONOMY_TERM : parent_of
- Explain the Open Referral UK v3.0 Entity Relationship Diagram
Overview
This entity relationship diagram illustrates the Open Referral UK version 3.0 standard schema. It specifies 10 core entities and 14 directed one-to-many relationships connecting organizations, services, locations, contacts, schedules, and taxonomies.
Entities and Attributes
Organization
Represents an umbrella body or provider offering community services.
- •
id: string (Primary Key) - •
name: string - •
description: string - •
email: string - •
url: string - •
logo: string - •
uri: string
Service
Represents a specific service delivered by an organization.
- •
id: string (Primary Key) - •
organization_id: string (Foreign Key referencing Organization) - •
name: string - •
description: string - •
url: string - •
email: string - •
status: string
Location
Represents a physical place where services are hosted or administered.
- •
id: string (Primary Key) - •
location_type: string - •
name: string - •
description: string - •
latitude: float - •
longitude: float - •
external_identifier: string
Service Location
A join entity linking services to the physical locations where they are delivered.
- •
service_id: string (Composite Primary Key, Foreign Key referencing Service) - •
location_id: string (Composite Primary Key, Foreign Key referencing Location)
Address
Represents the postal address for a specific location.
- •
id: string (Primary Key) - •
location_id: string (Foreign Key referencing Location) - •
address_1: string - •
city: string - •
state_province: string - •
postal_code: string - •
country: string - •
address_type: string
Contact
Represents an individual point of contact tied to an organization, service, or location.
- •
id: string (Primary Key) - •
organization_id: string (Foreign Key referencing Organization) - •
service_id: string (Foreign Key referencing Service) - •
location_id: string (Foreign Key referencing Location) - •
name: string - •
title: string
Phone
Represents phone numbers associated with contacts, services, or locations.
- •
id: string (Primary Key) - •
contact_id: string (Foreign Key referencing Contact) - •
service_id: string (Foreign Key referencing Service) - •
location_id: string (Foreign Key referencing Location) - •
number: string - •
description: string
Schedule
Represents opening hours, operating times, or validity dates.
- •
id: string (Primary Key) - •
service_id: string (Foreign Key referencing Service) - •
location_id: string (Foreign Key referencing Location) - •
service_at_location_id: string (Foreign Key) - •
opens_at: integer - •
closes_at: integer - •
valid_from: string - •
valid_to: string
Taxonomy
Represents a categorization system or controlled vocabulary.
- •
id: string (Primary Key) - •
name: string - •
vocabulary: string - •
description: string
Taxonomy Term
Represents individual tags or categories within a taxonomy, supporting hierarchical trees.
- •
id: string (Primary Key) - •
taxonomy_id: string (Foreign Key referencing Taxonomy) - •
name: string - •
description: string - •
parent_id: string (Foreign Key referencing Taxonomy Term for parent hierarchy)
Entity Relationships
- • Organization to Service: One Organization provides one or more Services (
provides). - • Organization to Contact: One Organization has one or more Contacts (
has). - • Service to Service Location: One Service connects to one or more Service Locations (
delivered_at). - • Location to Service Location: One Location hosts one or more Service Locations (
hosts). - • Location to Address: One Location has one or more Addresses (
has). - • Location to Contact: One Location has one or more Contacts (
has). - • Service to Contact: One Service has one or more Contacts (
has). - • Contact to Phone: One Contact has one or more Phone numbers (
has). - • Service to Phone: One Service has one or more Phone numbers (
has). - • Location to Phone: One Location has one or more Phone numbers (
has). - • Service to Schedule: One Service has one or more Schedules (
has). - • Location to Schedule: One Location has one or more Schedules (
has). - • Taxonomy to Taxonomy Term: One Taxonomy contains one or more Taxonomy Terms (
contains). - • Taxonomy Term to Taxonomy Term: One Taxonomy Term acts as the parent of one or more sub-terms (
parent_of, recursive self-reference).
- •
Benefit 1
Benefit 2
Benefit 3
Benefit 4
Benefit 5
Benefit 6
Benefit 7
Benefit 8
Benefit 9
Benefit 10
Benefit 11
Benefit 12
Requirement 1
Requirement 2
Requirement 3
Requirement 4
Requirement 5
Requirement 6
Review & Status
- Ministry of Housing, Communities and Local Government (MHCLG)
- iStand UK