Facility
Updated Nov 4, 2026
Primary Key
id
Columns
| Name | Definition | Type |
|---|---|---|
id
|
Unique identifier of the facility |
string
|
type
|
Kind of facility: showroom (sales site where cars are displayed, indoor or open-air), service (servicing, mechanical and body repair), warehouse (storage of stock not on display), delivery (handover or pick-up point), office (administrative site with no cars on site) Constraints
|
string
|
title
|
The name of the facility |
string
|
country
|
Country where the facility is located |
string
|
region
|
State or region within the country |
string
|
city
|
Closest city where the facility is located |
string
|
address
|
Street address of the facility |
string
|
postcode?
|
Postal code of the facility location |
string
|
phone?
|
Contact phone number for the facility |
string
|
email?
|
Contact email address for the facility |
email
|
url?
|
URL to the facility |
url
|
lon?
|
Longitude coordinate of the facility location |
number
|
lat?
|
Latitude coordinate of the facility location |
number
|
Facility types
| Value | Meaning |
|---|---|
showroom | Sales site where cars are displayed, indoor or open-air |
service | Servicing, mechanical and body repair |
warehouse | Storage of stock not on display |
delivery | Handover or pick-up point |
office | Administrative site with no cars on site |
Migrating from showroom
The showroom table is replaced by facility. To migrate, rename the
resource from showroom to facility, rename the car column
showroomId to facilityId, and add type: "showroom" to every
existing row. An old showroomId key on a car still validates, because unknown keys are
allowed, but it is no longer the foreign key: only facilityId is.
Created with ❤ and Livemark