| id |
bigint(20)
|
|
|
|
| first_name |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| last_name |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| username |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| password |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| country_code |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| contact_number |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| gender |
enum('male', 'female', 'other')
|
utf8mb4_general_ci
|
|
|
| email_verified_at |
timestamp
|
|
|
|
| address |
text
|
utf8mb4_general_ci
|
|
|
| user_type |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| player_id |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| service_id |
bigint(20)
|
|
|
|
| fleet_id |
bigint(20)
|
|
|
|
| latitude |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| longitude |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| remember_token |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| last_notification_seen |
timestamp
|
|
|
|
| status |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| is_online |
tinyint(4)
|
|
|
|
| is_available |
tinyint(4)
|
|
|
|
| is_verified_driver |
tinyint(4)
|
|
|
|
| uid |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| fcm_token |
text
|
utf8mb4_general_ci
|
|
|
| display_name |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| login_type |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| timezone |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| last_actived_at |
datetime
|
|
|
|
| app_version |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| last_location_update_at |
datetime
|
|
|
|
| otp_verify_at |
timestamp
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|