be - Laravel Schema Designer

users

id increments
email string
password string
role enum
first_name string
last_name string
phone string
timestamps timestamps

vehicles

id increments
name string
type string
user_id ^FK integer
reg_number string
seats string
timestamps timestamps

trips

id increments
user_id ^FK integer
vehicle_id ^FK integer
start_at datetime
end_at datetime
price decimal (8,2)
seats integer
timestamps timestamps

bookings

id increments
user_id ^FK integer
trip_id ^FK integer
status string
timestamps timestamps

routes

id increments
from string
to string
trip_id ^FK integer
timestamps timestamps

booking_route

id increments
route_id ^FK integer
booking_id ^FK integer

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