| id |
int(11)
|
|
|
|
| company_id |
int(11)
|
|
|
|
| branch_id |
int(11)
|
|
|
|
| driver_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| driver_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| driver_type |
enum('Driver', 'Helper', 'Supervisor')
|
utf8mb4_unicode_ci
|
|
|
| mobile_no |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| alternate_mobile_no |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| email |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| address |
text
|
utf8mb4_unicode_ci
|
|
|
| license_no |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| license_type |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| license_expiry_date |
date
|
|
|
|
| aadhaar_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| police_verification_status |
enum('Pending', 'Verified', 'Rejected')
|
utf8mb4_unicode_ci
|
|
|
| medical_fitness_status |
enum('Pending', 'Fit', 'Unfit')
|
utf8mb4_unicode_ci
|
|
|
| app_login_enabled |
tinyint(1)
|
|
|
|
| app_username |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| app_password_hash |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| last_login_at |
datetime
|
|
|
|
| driver_status |
enum('Active', 'Inactive', 'On Leave', 'Terminated')
|
utf8mb4_unicode_ci
|
|
|
| remarks |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| updated_by |
int(11)
|
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|