Car

Primary Key

url

Foreign Keys

Columns	Reference Resource	Reference Columns
showroomId	showroom	id

Columns

Name	Definition	Type
showroomId?	Unique identifier for the showroom where the car is located. If not provided the car is considered located at the dealers's main address	string
title	The title or name of the car listing	string
url	URL to the car listing	url
price	The price of the car in the currency specified Constraints minimum: 0	number
currency	Currency of the price	string
year?	Year of first registration (1900-2100) Constraints minimum: 1900	integer
mileage	Odometer reading in kilometers Constraints minimum: 0	number
brand	Car brand/manufacturer	string
model	Car model name	string
version	Specific version or trim level	string
fuel	Fuel type Constraints enum: diesel, petrol, hybrid, electric	string
gearbox	Transmission type Constraints enum: manual, auto	string
category	Vehicle category/body type Constraints enum: small, estate, saloon, suv, van, sport, cabrio	string
color	Exterior color Constraints enum: grey, black, white, blue, red, green, yellow, orange	string
door	Number of doors identifier Constraints enum: twothree, fourfive, sixseven	string
power?	Engine power in horsepower	integer
cubics?	Engine displacement in cubic centimeters	integer
seats?	Number of seats	integer
owners?	Number of previous owners	integer
month?	Month of first registration (1-12) Constraints minimum: 1 maximum: 12	integer
warranty?	Warranty duration in months	integer
range?	Electric vehicle range in kilometers	integer
battery?	Battery capacity in kWh for electric vehicles	integer
plate?	License plate number	string
vin?	Vehicle Identification Number	string