Scribd
Upload
11 views2 pages

Database Schema

The document outlines a database schema for a vehicle management system, detailing tables for users, vehicle details, and servicing information. Key fields include user identification, vehicle registration details, and service history with associated costs and specifications. It also includes warranty and maintenance contract details for vehicles.

Uploaded by

Hyouka
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
11 views2 pages

Database Schema

The document outlines a database schema for a vehicle management system, detailing tables for users, vehicle details, and servicing information. Key fields include user identification, vehicle registration details, and service history with associated costs and specifications. It also includes warranty and maintenance contract details for vehicles.

Uploaded by

Hyouka
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

users vehicle_details basic_details

id integer * id hex
reg_num varchar

username varchar phone_num varchar make varchar

password varchar owner varchar model varchar

is_admin bool reg_date date fuel_type varchar

warranty_start date Rated Power Varchar

warranty_end date Peak Power varchar

basic_details hex 1 Seat Height varchar

servicing_details amc_details hex 1 Loading capacity varchar

id hex * 1 servicing_details hex Speedometer varchar

last_service_date date Battery Type varchar

last_service_km integer Controller varchar


amc_details
services varchar Brake System varchar
id hex *
bill_number varchar Dimensions varchar
type varchar
total_cost integer Tyre varchar
start_date date
Charging Time varchar
end_date date
Charger Spec varchar
scope_of_work varchar
Voltage varchar
details varchar
Suspension varchar
frequency varchar
Range/Mileage varchar
TAT integer
Ground Clearance varchar
contract_length varchar
ARAI/ICAT Approved varchar
company_name varchar
Floor Mat varchar

Top Speed varchar

Wheel varchar

Headlight varchar

Backlight varchar

Brake Lever varchar

Battery Warranty varchar


users vehicle_details basic_details

id integer * id hex
reg_num varchar

username varchar phone_num varchar make varchar

password varchar owner varchar model varchar

is_admin bool reg_date date fuel_type varchar

warranty_start date Rated Power Varchar

warranty_end date Peak Power varchar

basic_details hex 1 Seat Height varchar

servicing_details amc_details hex 1 Loading capacity varchar

id hex * 1 servicing_details hex Speedometer varchar

last_service_date date Battery Type varchar

last_service_km integer Controller varchar


amc_details
services varchar Brake System varchar
id hex *
bill_number varchar Dimensions varchar
type varchar
total_cost integer Tyre varchar
start_date date
Charging Time varchar
end_date date
Charger Spec varchar
scope_of_work varchar
Voltage varchar
details varchar
Suspension varchar
frequency varchar
Range/Mileage varchar
TAT integer
Ground Clearance varchar
contract_length varchar
ARAI/ICAT Approved varchar
company_name varchar
Floor Mat varchar

Top Speed varchar

Wheel varchar

Headlight varchar

Backlight varchar

Brake Lever varchar

Battery Warranty varchar

You might also like