trip_map_api - Laravel Schema Designer

users

id increments
user_name string (255)
user_image string (255)
phone string (255)
email string (255)
password string (255)
kilo_share bigInteger
timestamps timestamps

tbl_cars

id increments
user_id ^FK integer
car_brand_id ^FK integer
car_model string (255)
city_id ^FK integer
plate_number integer
driving_license_imge string (255)
car_plate_img string (255)
timestamps timestamps

tbl_city

id increments
city_name string (255)
timestamps timestamps

tbl_car_brand

id increments
brand_name string (255)
timestamps timestamps

tbl_car_images

id increments
car_id ^FK integer
image string (255)
timestamps timestamps

tbl_groubs

id increments
name string (255)
type_id ^FK integer
discription text
created_by ^FK integer
timestamps timestamps

tbl_groub_member

id increments
groub_id ^FK integer
user_id ^FK integer
role_id integer
joind_at timestamps

roles

id increments
title string (255)
timestamps timestamps

tbl_groub_join_requests

id increments
groub_id ^FK integer
user_id ^FK integer
status enum
date timestamps
time datetime

tbl_trips

id increments
orginized_id ^FK integer
start_point double
end_point double
go_time time
return_time time
chairs_num string
appearance enum
passenger_type enum
from_date datetime
to_date datetime
back_status enum
trip_title string
trip_code bigInteger
timestamps timestamps
distance integer
kilo_share bigInteger

tbl_trip_join_request

id increments
trip_id ^FK integer
user_id ^FK integer
trip_day_id ^FK integer
groub_id ^FK integer
status enum
time timestamps

tbl_kiloshare_trans

id increments
trip_id ^FK integer
guest_id ^FK integer
owner_id ^FK integer
date date
kilo_share bigInteger
guest_status enum
owner_status enum
main_status enum

tbl_groub_type

id increments
name string (255)
timestamps timestamps

tbl_trip_days

id increments
trip_id ^FK integer
timestamps timestamps

tbl_trip_point

id increments
from_point double
to_point double
trip_id ^FK integer

tbl_trip_member

id increments
trip_id ^FK integer
user_id ^FK integer
joind_at timestamps

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