Task #187
Updated by Dana Basheer about 2 months ago
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** c2b_driver_master 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.