tours_trip - Laravel Schema Designer

users

id increments
name string (30)
role string (30)
email string (50)
timestamps timestamps

trips

id increments
type_id ^FK bigInteger
hotel_id ^FK bigInteger
name string
image string
description text
start_date date
end_date date
price decimal
available_seats integer
timestamps timestamps

activities

id increments
tripe_id ^FK bigInteger
name string
image string
time datetime
timestamps timestamps

bookings

id increments
tripe_id ^FK bigInteger
payment_id ^FK bigInteger
passport_number integer
email string
numberofpeople integer
booking_date datetime
timestamps timestamps

reviews

id increments
tripe_id ^FK bigInteger
rating enum
comment text
review_date datetime
timestamps timestamps

types

id increments
name string
description text
timestamps timestamps

hotels

id increments
name string
image string
rating enum
timestamps timestamps

payments

id increments
credit_card_number integer
totaL_price decimal
timestamps timestamps

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