Home Travel & HospitalityCar Rental

Car Rental

Vehicle rental business with fleet inventory, multi-location pickups, damage reports, and insurance options

SchemaVerse

Travel & HospitalityPostgreSQLTravelNormalized

car-rental.dbml

11 tables|17 relations

vehicle_categories

idinteger

acriss_codevarchar(4)

namevarchar(50)

descriptiontext

example_modelsvarchar(255)

passenger_capacityinteger

luggage_capacityinteger

transmissionvarchar(20)

air_conditioningboolean

is_activeboolean

created_attimestamp

vehicles

idinteger

vehicle_category_idinteger

FK*

home_location_idinteger

FK*

makevarchar(50)

modelvarchar(50)

yearinteger

colorvarchar(50)

license_platevarchar(20)

*UQ

vinvarchar(17)

*UQ

fuel_typevarchar(20)

mileageinteger

statusvarchar(20)

last_service_datedate

next_service_datedate

notestext

created_attimestamp

updated_attimestamp

rental_locations

idinteger

location_codevarchar(20)

*UQ

namevarchar(255)

location_typevarchar(30)

address_line1varchar(255)

cityvarchar(100)

state_provincevarchar(100)

country_codevarchar(3)

postal_codevarchar(20)

latitudedecimal(10,7)

longitudedecimal(10,7)

phonevarchar(20)

emailvarchar(255)

airport_iatavarchar(3)

opening_hoursvarchar(255)

is_24_hoursboolean

is_activeboolean

created_attimestamp

customers

idinteger

customer_numbervarchar(20)

*UQ

first_namevarchar(100)

last_namevarchar(100)

emailvarchar(255)

*UQ

phonevarchar(20)

date_of_birthdate

driver_license_numbervarchar(50)

driver_license_statevarchar(10)

driver_license_expirydate

loyalty_numbervarchar(30)

loyalty_tiervarchar(20)

loyalty_pointsinteger

is_blacklistedboolean

blacklist_reasontext

created_attimestamp

updated_attimestamp

insurance_options

idinteger

codevarchar(30)

*UQ

namevarchar(100)

descriptiontext

coverage_typevarchar(50)

daily_ratedecimal(8,2)

deductible_amountdecimal(10,2)

is_activeboolean

created_attimestamp

reservations

idinteger

confirmation_numbervarchar(20)

*UQ

customer_idinteger

FK*

vehicle_category_idinteger

FK*

vehicle_idinteger

pickup_location_idinteger

FK*

return_location_idinteger

FK*

pickup_datetimetimestamp

return_datetimetimestamp

rental_daysinteger

daily_ratedecimal(10,2)

estimated_totaldecimal(10,2)

currencyvarchar(3)

statusvarchar(20)

sourcevarchar(30)

driver_countinteger

special_requeststext

created_attimestamp

updated_attimestamp

add_ons

idinteger

codevarchar(30)

*UQ

namevarchar(100)

descriptiontext

pricing_modelvarchar(20)

pricedecimal(8,2)

is_activeboolean

created_attimestamp

reservation_add_ons

idinteger

reservation_idinteger

FK*

add_on_idinteger

FK*

quantityinteger

price_at_bookingdecimal(8,2)

rental_agreements

idinteger

reservation_idinteger

FK*

agreement_numbervarchar(20)

*UQ

vehicle_idinteger

FK*

customer_idinteger

FK*

fuel_level_outvarchar(10)

mileage_outinteger

fuel_level_invarchar(10)

mileage_ininteger

actual_return_datetimetimestamp

extra_mileage_chargedecimal(10,2)

late_return_chargedecimal(10,2)

fuel_chargedecimal(10,2)

signed_attimestamp

closed_attimestamp

created_attimestamp

damage_reports

idinteger

rental_agreement_idinteger

FK*

vehicle_idinteger

FK*

reported_byvarchar(20)

report_typevarchar(20)

damage_locationvarchar(100)

damage_severityvarchar(20)

descriptiontext

estimated_repair_costdecimal(10,2)

actual_repair_costdecimal(10,2)

insurance_option_idinteger

customer_liabilitydecimal(10,2)

is_resolvedboolean

reported_attimestamp

resolved_attimestamp

invoices

idinteger

rental_agreement_idinteger

FK*

customer_idinteger

FK*

invoice_numbervarchar(20)

*UQ

base_rental_chargedecimal(10,2)

add_ons_totaldecimal(10,2)

insurance_totaldecimal(10,2)

extra_charges_totaldecimal(10,2)

taxes_totaldecimal(10,2)

total_amountdecimal(10,2)

amount_paiddecimal(10,2)

currencyvarchar(3)

payment_methodvarchar(30)

statusvarchar(20)

issued_attimestamp

paid_attimestamp

React Flow

About this Schema

Overview

Vehicle rental platform schema for companies like Hertz or Enterprise. Models fleet management, multi-location operations, rental agreements, and damage tracking.

Key Design Decisions

Vehicle Categories: Class-based pricing (economy, SUV, luxury) with specific vehicle assignment
Multi-location: Different pickup and drop-off locations with one-way fees
Damage Reports: Pre/post-rental inspection tracking with photo references
Add-ons: GPS, child seats, insurance packages as optional extras

Tables

10-12 tables covering vehicles, categories, locations, customers, reservations, rental agreements, add-ons, damage reports, invoices, and insurance options.

Comments

Loading comments...