tours_trip - Laravel Schema Designer

users

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

countries

id increments
type_id ^FK bigInteger
name string
timestamps timestamps

trips

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

activities

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

bookings

id increments
tripe_id ^FK bigInteger
email string
booking_date datetime
numberofpeople integer
totaL_price decimal
timestamps timestamps
hotel_id ^FK bigInteger

reviews

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

types

id increments
name string
timestamps timestamps
description text

hotels

id increments
image string
timestamps timestamps
tripe_id ^FK bigInteger

method_payments

id increments
method_name enum
timestamps timestamps

payments

id increments
method_payment_id ^FK bigInteger
booking_id ^FK bigInteger
amount decimal
timestamps timestamps

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