| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | id | int AUTO_INCREMENT | |
| * | activity_done_by | int | user id |
| * | activity_done_by_type | int | 1->Driver, 2->employer, 3->insurance_company |
| * | activity_description | text | |
| * | created_at | datetime | |
| * | updated_at | datetime | |
| Indexes | |||
| pk_activity_tracker | ON id | ||
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int AUTO_INCREMENT |
| * | full_name | varchar(250) |
| user_profile_img | varchar(255) | |
| * | uname | varchar(250) |
| * | mail_id | varchar(250) |
| * | pass | varchar(250) |
| * | contact_no | varchar(250) |
| * | is_active | int |
| created_at | datetime | |
| updated_at | datetime | |
| * | admin_type | varchar(255) |
| Indexes | ||
| pk_admin_users | ON id | |
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | id | int AUTO_INCREMENT | |
| * | admin_id | int | |
| * | menu_name | varchar(100) | |
| menu_link | text | ||
| menu_type | int DEFAULT 1 | 1 => Add, 2 => List | |
| select_parent | int DEFAULT 0 | ||
| order_no | int DEFAULT 0 | ||
| menu_class | varchar(200) | ||
| status | int DEFAULT 1 | ||
| created_at | datetime | ||
| updated_at | datetime | ||
| Indexes | |||
| pk_adminmenus | ON id | ||
| admin_id | ON admin_id | ||
| Foreign Keys | |||
| adminmenus_ibfk_1 | ( admin_id ) ref admin_users (id) | ||
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int AUTO_INCREMENT |
| * | admin_id | int |
| * | menuid | varchar(200) |
| facilities | text | |
| created_at | datetime | |
| updated_at | datetime | |
| Indexes | ||
| pk_assignmenus | ON id | |
| admin_id | ON admin_id | |
| Foreign Keys | ||
| assignmenus_ibfk_1 | ( admin_id ) ref admin_users (id) | |
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | id | int AUTO_INCREMENT | |
| name | varchar(250) | ||
| status | boolean DEFAULT true | 1=active, 2=inactive | |
| * | created_date | date | |
| Indexes | |||
| pk_countries | ON id | ||
| country_name | ON name | ||
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int AUTO_INCREMENT |
| * | type_name | int |
| created_at | datetime | |
| updated_at | datetime | |
| Indexes | ||
| pk_document_types | ON id | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int AUTO_INCREMENT |
| * | driver_id | int |
| * | rating | float(12,0) |
| * | review | text |
| * | created_at | datetime |
| * | updated_at | datetime |
| Indexes | ||
| pk_driver_reviews | ON id | |
| driver_id | ON driver_id | |
| Foreign Keys | ||
| driver_reviews_ibfk_1 | ( driver_id ) ref drivers (id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int AUTO_INCREMENT |
| * | driver_id | int |
| * | added_by | int |
| * | score | int |
| created_at | datetime | |
| updated_at | datetime | |
| Indexes | ||
| pk_driver_risk_scores | ON id | |
| added_by | ON added_by | |
| driver_id | ON driver_id | |
| Foreign Keys | ||
| driver_risk_scores_ibfk_2 | ( added_by ) ref admin_users (id) | |
| driver_risk_scores_ibfk_1 | ( driver_id ) ref drivers (id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int AUTO_INCREMENT |
| * | driver_id | int |
| * | suggestion | varchar(255) |
| * | reason | text |
| created_at | datetime | |
| updated_at | datetime | |
| Indexes | ||
| pk_driver_verification_reviews | ON id | |
| driver_id | ON driver_id | |
| Foreign Keys | ||
| driver_verification_reviews_ibfk_1 | ( driver_id ) ref drivers (id) | |
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | id | int AUTO_INCREMENT | |
| * | user_id | int | |
| * | added_by | int | |
| * | dob | datetime | |
| * | age | int | |
| * | gender | int | |
| * | state | int | |
| * | lga | int | |
| * | address | varchar(255) | |
| * | passport | varchar(255) | |
| * | identification | int | |
| * | license_no | varchar(255) | |
| * | license_issued_date | datetime | |
| * | license_expiry_date | datetime | |
| * | currently_employed | int | 1->Yes, 0->No |
| * | currently_employer_name | varchar(255) | |
| * | currently_employer_email | varchar(255) | |
| * | currently_employer_phone_no | varchar(255) | |
| * | previous_employer_name | varchar(255) | |
| * | previous_employer_email | varchar(255) | |
| * | previous_employer_phone_no | varchar(255) | |
| * | driver_experience_in_year | int | |
| * | drive_vehicle | varchar(255) | |
| * | frequest_drive_timing | int | 1->daily, 2->weekly,3->every two weeks, 4->monthly |
| * | is_approved | int | 0->No, 1->yes |
| * | approved_by | int | |
| * | employer_id | varchar(255) | |
| created_at | datetime | ||
| updated_at | datetime | ||
| Indexes | |||
| pk_drivers | ON id | ||
| added_by | ON added_by | ||
| approved_by | ON approved_by | ||
| identification | ON identification | ||
| lga | ON lga | ||
| state | ON state | ||
| user_id | ON user_id | ||
| Foreign Keys | |||
| drivers_ibfk_7 | ( added_by ) ref admin_users (id) | ||
| drivers_ibfk_8 | ( approved_by ) ref admin_users (id) | ||
| drivers_ibfk_4 | ( identification ) ref document_types (id) | ||
| drivers_ibfk_5 | ( added_by ) ref employers (id) | ||
| drivers_ibfk_6 | ( added_by ) ref insurance_companies (id) | ||
| drivers_ibfk_3 | ( lga ) ref lgas (id) | ||
| drivers_ibfk_2 | ( state ) ref states (id) | ||
| drivers_ibfk_1 | ( user_id ) ref users (id) | ||
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int AUTO_INCREMENT |
| * | user_id | int |
| * | state | int |
| * | lga | int |
| * | address | varchar(255) |
| * | company_phone_no | varchar(255) |
| * | industry | varchar(255) |
| * | full_address | text |
| * | identification | int |
| * | cac_registration_number | varchar(255) |
| created_at | datetime | |
| updated_at | datetime | |
| Indexes | ||
| pk_employers | ON id | |
| identification | ON identification | |
| lga | ON lga | |
| state | ON state | |
| user_id | ON user_id | |
| Foreign Keys | ||
| employers_ibfk_4 | ( identification ) ref document_types (id) | |
| employers_ibfk_3 | ( lga ) ref lgas (id) | |
| employers_ibfk_2 | ( state ) ref states (id) | |
| employers_ibfk_1 | ( user_id ) ref users (id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int AUTO_INCREMENT |
| * | user_id | int |
| * | full_address | text |
| * | identification | int |
| * | cac_registration_number | varchar(255) |
| * | other_documents | varchar(255) |
| * | insurance_number | varchar(255) |
| * | created_at | datetime |
| * | updated_at | datetime |
| Indexes | ||
| pk_insurance_companies | ON id | |
| identification | ON identification | |
| user_id | ON user_id | |
| Foreign Keys | ||
| insurance_companies_ibfk_2 | ( identification ) ref document_types (id) | |
| insurance_companies_ibfk_1 | ( user_id ) ref users (id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int AUTO_INCREMENT |
| state_id | int | |
| lga | varchar(255) | |
| created | datetime | |
| Indexes | ||
| pk_lgas | ON id | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int |
| * | membership_id | varchar(50) |
| * | driver_id | int |
| * | package_id | int |
| * | transaction_id | varchar(255) |
| * | amount | double |
| * | payment_status | int |
| * | start_date | datetime |
| * | expiry_date | datetime |
| * | craeted_at | datetime |
| * | updated_at | datetime |
| Indexes | ||
| driver_id | ON driver_id | |
| package_id | ON package_id | |
| Foreign Keys | ||
| member_subscriptions_ibfk_1 | ( driver_id ) ref drivers (id) | |
| member_subscriptions_ibfk_2 | ( package_id ) ref subscription_package (id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int AUTO_INCREMENT |
| * | message_from | int |
| * | message_to | int |
| message | text | |
| * | created_at | datetime |
| * | updated_at | datetime |
| Indexes | ||
| pk_messages | ON id | |
| message_from | ON message_from | |
| message_to | ON message_to | |
| Foreign Keys | ||
| messages_ibfk_1 | ( message_from ) ref users (id) | |
| messages_ibfk_2 | ( message_to ) ref users (id) | |
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | id | int AUTO_INCREMENT | |
| * | user_id | int | |
| * | user_type | int | 1->Driver, 2->Employer, 3->Insurance Company |
| * | notification_text | text | |
| * | notification_for | varchar(255) | |
| created_at | datetime | ||
| updated_at | datetime | ||
| Indexes | |||
| pk_notifications | ON id | ||
| user_id | ON user_id | ||
| Foreign Keys | |||
| notifications_ibfk_1 | ( user_id ) ref drivers (id) | ||
| notifications_ibfk_2 | ( user_id ) ref employers (id) | ||
| notifications_ibfk_3 | ( user_id ) ref insurance_companies (id) | ||
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | id | int AUTO_INCREMENT | |
| site_email | varchar(150) | ||
| sitelogo | varchar(255) | logo file path | |
| sitefavicon | varchar(255) | Favicon image path | |
| sitefooterlogo | varchar(255) | ||
| address | longtext | ||
| phone_number | varchar(40) | ||
| site_title | varchar(255) | Site Title if not override | |
| created_at | datetime | ||
| updated_at | datetime | ||
| Indexes | |||
| pk_sitesettings | ON id | ||
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int AUTO_INCREMENT |
| state | varchar(255) | |
| country_id | int | |
| zone | varchar(255) | |
| created | datetime | |
| Indexes | ||
| pk_states | ON id | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int AUTO_INCREMENT |
| * | title | varchar(255) |
| * | price | double |
| * | status | int |
| created_at | datetime | |
| updated_at | datetime | |
| Indexes | ||
| pk_subscription_package | ON id | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int |
| * | transaction_for | varchar(40) |
| * | transaction_id | varchar(250) |
| * | amount | double |
| * | created_at | datetime |
| * | updated_at | datetime |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int AUTO_INCREMENT |
| * | user_id | int |
| * | certificate | varchar(255) |
| created_at | datetime | |
| updated_at | datetime | |
| Indexes | ||
| pk_user_certificates | ON id | |
| user_id | ON user_id | |
| Foreign Keys | ||
| user_certificates_ibfk_1 | ( user_id ) ref drivers (id) | |
| Idx | Field Name | Data Type | Description |
|---|---|---|---|
| * | id | int AUTO_INCREMENT | |
| * | user_type | int | 1-> Driver, 2-> Employer, 3-> Insurance Company |
| * | name | varchar(255) | |
| middle_name | varchar(255) | ||
| last_name | varchar(255) | ||
| * | varchar(255) | ||
| * | phone_number | varchar(255) | |
| * | password | varchar(255) | |
| * | is_mail_confirm | int | 1->Verified , 0->Not Verified. |
| * | status | int | 0>In active, 1->active , 2->block, 3->leave |
| created_at | datetime | ||
| updated_at | datetime | ||
| Indexes | |||
| pk_users | ON id | ||
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int AUTO_INCREMENT |
| * | wallet_id | int |
| * | amount | double |
| * | transaction_id | varchar(255) |
| * | created_at | datetime |
| * | updated_at | datetime |
| Indexes | ||
| pk_wallet_transactions | ON id | |
| wallet_id | ON wallet_id | |
| Foreign Keys | ||
| wallet_transactions_ibfk_1 | ( wallet_id ) ref wallets (id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | int AUTO_INCREMENT |
| * | insurance_id | int |
| * | employer_id | int |
| * | balance | double |
| created_at | datetime | |
| updated_at | datetime | |
| Indexes | ||
| pk_wallets | ON id | |
| employer_id | ON employer_id | |
| user_id | ON insurance_id | |
| Foreign Keys | ||
| wallets_ibfk_5 | ( employer_id ) ref employers (id) | |
| wallets_ibfk_4 | ( insurance_id ) ref insurance_companies (id) | |