trendTaxiApp - Laravel Schema Designer

trend_taxi_app_users

id increments
timestamps timestamps
softDeletes softDeletes
user_phone string (12)
user_verified_code string (6)
user_status tinyInteger
user_type enum
user_device string (255)
user_name string (64)
user_balance decimal (15,2)
user_score decimal (1,2)
last_latitude string (24)
last_longitude string (24)
last_activity string (24)
user_taxi_park string (64)

trend_taxi_app_user_data

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
user_image string (255)
car_image_1 string (255)
car_image_2 string (255)
license_image string (255)
driver_license_image string (255)
car_usage_license_image string (255)
car_type string (24)
car_plate string (24)
car_brand string (32)
car_model string (32)

trend_taxi_app_sss

id increments
timestamps timestamps
sss_order smallInteger
sss_title string (255)
sss_description string (255)
sss_lang string (2)

trend_taxi_app_settings

id increments
timestamps timestamps
option_group string (64)
option_type string (64)
option_data text
option_name string (128)
option_value string (255)

trend_taxi_app_prices

id increments
timestamps timestamps
title string (64)
lang string (2)
car_type string (24)
image string (255)
alt string (255)
start decimal (15,2)
km decimal (15,2)
paid decimal (15,2)
fee decimal (2,2)

trend_taxi_app_past_trips

id increments
timestamps timestamps
trip_id string (24)
driver_id ^FK integer
passenger_id ^FK integer
start_time integer
end_time integer
locations text
status enum
est_price decimal (15,2)
est_distance decimal (15,2)
est_duration string (24)
act_price decimal (15,2)
act_distance decimal (15,2)
act_duration string (24)
trip_reward decimal (15,2)
trip_fee decimal (15,2)

trend_taxi_app_active_trips

id increments
timestamps timestamps

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01