TripOn

This module is used to manage driver details associated with transporters. Each driver belongs to a transporter and can be used for transportation services during trips. The system stores basic driver information such as driver name, contact number, and the transporter they belong to. Drivers can be activated or deactivated depending on their availability.

Table

driver_master

• driver_id (PK) INT AUTO_INCREMENT Unique driver ID
• driver_name VARCHAR(150) Name of the driver
• contact_no VARCHAR(15) Driver contact number
• transport_id (FK) INT References transporter_master.transporter_id
• is_active BOOLEAN DEFAULT TRUE Active / inactive status

Validations

Mandatory

• driver_name required
• contact_no required
• transport_id required

Driver Name

• Minimum 2 characters
• Maximum 150 characters
• Cannot be empty

Contact Number

• Must be numeric
• Must contain 10–15 digits

Duplicate

• Prevent duplicate driver under same transporter.

Transporter

• transport_id must exist in transporter_master
• transporter must be active

Edit

Allow edit:

• driver_name
• contact_no
• is_active

Do NOT allow edit:

• transport_id
• driver_id

Delete Rule

• Soft delete only
• is_active = FALSE
• Do not delete record permanently.