dynamic_travels - Laravel Schema Designer

countries

id increments
name string (255)
code string (255)
timestamps timestamps
softDeletes softDeletes

city

id increments
city_code string (255)
city_name string (255)
country_id ^FK integer
timestamps timestamps
softDeletes softDeletes

airports

id increments
airport_name string (255)
city_id ^FK integer
iata_code integer
timestamps timestamps
softDeletes softDeletes

customers

id increments
name string (255)
email string (255)
phone string (255)
address text
password string (255)
remember_token string (255)
softDeletes softDeletes
timestamps timestamps

airline_packages

id increments
timestamps timestamps
softDeletes softDeletes
flying_from string (255)
flying_to string (255)
baggage string (100)
airline_id ^FK integer
airline_classes_id ^FK integer

airline

id increments
timestamps timestamps
softDeletes softDeletes
airline_name string (255)
airline_code string (255)

airline_classes

id increments
timestamps timestamps
softDeletes softDeletes
name string

users

id increments
name string (255)
email string (255)
password string (255)
remember_token string (255)
phone string (255)
softDeletes softDeletes
timestamps timestamps

comments

id increments
message text
reference string (255)
customer_id ^FK integer
softDeletes softDeletes
timestamps timestamps

bookings

id increments
timestamps timestamps
softDeletes softDeletes
customer_id ^FK integer
airline_packages_id ^FK integer
booking_token integer

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