tab_holidays - Laravel Schema Designer

activities

id increments
name string
country_id integer
city_id integer
inclusions text
exclusions text
duration double (8,2)
timestamps timestamps
vendor_id integer

activity_package

id increments
activity_id integer
name string
status boolean
timestamps timestamps

pricing_scheme

id increments
activity_id ^FK integer
name string
attr_id integer
start_date date
end_date date
status boolean
timestamps timestamps

Pricing

id increments
activity_id ^FK integer
pricing_scheme_id ^FK integer
pax_count integer
adult integer
child integer
infant integer
timestamps timestamps

activity_specs

id increments
activity_id ^FK integer
name string
type string
timestamps timestamps

vendors

id increments
name string
contact_person string
contact_number string
alt_contact_num string
country_id string
address1 string
address2 string
timestamps timestamps

bookings

id increments
date date
amount decimal
country_id string
agent_id string
adults integer
children integer
infant integer
customer_name string
customer_contact_number string
customer_address string
timestamps timestamps

agents

id increments
name string
contact_number string
alt_contact_number string
adress1 string
address2 string
city_id integer
country_id integer
timestamps timestamps

booking_activities

id increments
booking_id integer
activity_id integer
date date
adult decimal
children_cost decimal
infant_cost string
total_cost decimal
timestamps timestamps

countries

id increments
name string
currency integer
status boolean
timestamps timestamps

cities

id increments
country_id integer
name string
status boolean
timestamps timestamps

booking_update

id increments
booking_id integer
message text
sent_by integer
timestamps timestamps

users

id increments
first_name string
last_name string
username string
password string
timestamps timestamps

activity_package_attr

id increments
package_id integer
attr_id integer
timestamps timestamps

activity_spec_attr

id increments
activity_id integer
spec_id integer
name string
status boolean
timestamps timestamps

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