TripOn

The Vehicle Management module is used to manage vehicles available for transportation services in the system. This module stores vehicle details such as seating capacity, transporter information, daily rent, distance limits, and extra kilometer charges, which are later used for pricing and itinerary calculations.

***Table

vehicle_master

Field Name Type Description

• id (PK) INT Vehicle ID
• vehicle_name VARCHAR(100) Name of the vehicle
• seat_capacity INT Number of seats
• geog_id (FK) INT Location from Geography Master
• transporter_name VARCHAR(100) Transporter / vendor name
• transporter_contact_number VARCHAR(20) Transporter contact number
• max_km_day DECIMAL(6,2) Maximum km allowed per day
• day_rent DECIMAL(10,2) Daily rent amount
• extra_km_rate DECIMAL(10,2) Extra charge per km
• is_active BOOLEAN Active / Inactive (soft delete)
• created_at DATETIME Created date
• updated_at DATETIME Updated

***Validations

• Vehicle Name is mandatory
• Vehicle Name must have minimum 3 characters
• Vehicle Name must be unique under the same location
• Duplicate validation must be case-insensitive
• Seat Capacity:
  * Mandatory
  * Must be a positive integer
• Location:
  * Mandatory
  * Must be selected from Geography Master
• Transporter Name:
  * Mandatory
  * Minimum 3 characters
• Transporter Contact Number:
  * Mandatory
  * Numeric only
  * Length between 10–15 digits
• Max KM per Day:
  * Must be a positive number
• Day Rent:
  * Must be greater than 0
• Extra KM Rate:
  * Can be 0 or greater
• All validations must apply on Add and Edit

*All numeric fields must accept valid decimal values only

*Soft delete should be used instead of hard delete