wedding composer - Laravel Schema Designer

profiles

id increments
user_id ^FK integer
service_id ^FK integer
name string
legal_name string
address_one text
address_two text
city string
state string
zip_code string
phone_type_id ^FK integer
phone integer
hours integer
description text
insurance string
logo string
timestamps timestamps
softDeletes softDeletes

users

id increments
timestamps timestamps
first_name string
last_name string
opted_in boolean
accepted_at datetime
email string
email_verified_at datetime
password string

services

id increments
name string
timestamps timestamps

links

id increments
link morphs
image string
timestamps timestamps

service_informations

id increments
user_id ^FK integer
states_served string
lgbt_friendly boolean
pet_friendly boolean
handicap_accessible boolean
peak_season_month string
peak_season_booking_minimum double
peak_budget_below_minimum boolean
off_season_booking_minimum double
off_peak_budget_below_minimum boolean
timestamps timestamps

service_venue_informations

id increments
service_information_id ^FK integer
service_offered string
ceremony_reception_type string
service_location string
indoor_capacity string
outdoor_capacity string
adult_guest_minimum string
min_event_durations_hours string
coordinator_required boolean
can_host_more_event_at_a_time boolean
approved_outside_vendors_only boolean
require_outside_vendors_to_have_insurance boolean
timestamps timestamps

venue_types

id increments
Name string
timestamps timestamps

service_venue_types

id increments
timestamps timestamps
service_information_id ^FK integer
venue_type_id ^FK integer

facility_amenities

id increments
name string
options longText
timestamps timestamps

service_facility_amenities

id increments
service_information_id ^FK integer
facility_amenity_id ^FK integer
option string
timestamps timestamps

indoor_function_amenities

id increments
name string
options longText
timestamps timestamps

service_indoor_function_amenities

id increments
service_information_id ^FK integer
indoor_function_amenity_id ^FK integer
option string
timestamps timestamps

service_facility_restrictions

id increments
service_information_id ^FK integer
catering string
alcohol string
smoking string
special_decorations string
parking string
music string
indoor_music_end_by time
outdoor_music_end_by time
timestamps timestamps

service_venue_menu_choices

id increments
service_information_id ^FK integer
menu_type_choices string
special_dietary_preferences string
soft_drinks_juices_offered string
online_menu_link string
cocktail_hour_service_choices string
cocktail_hour_alcohol_offered string
alcohol_type string
menu_pricing_packages string
timestamps timestamps

contract_payments

id increments
user_id ^FK integer
deposit_policy string
balance_due string
multiple_payment_option string
payment_method_accepted string
timestamps timestamps

phone_types

id increments
timestamps timestamps
name string

insurances

id increments
name string
profile_id ^FK integer
timestamps timestamps

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