brokerage_db - Laravel Schema Designer

brands

id increments
name string (50)
image string
timestamps timestamps

boats

id increments
timestamps timestamps
model_id ^FK integer

boat_models

id increments
timestamps timestamps
brand_id ^FK integer

contacts

id increments
timestamps timestamps
first_name string (50)
last_name string (50)
company string (50)
address string (100)
address2 string (100)
city string (50)
postal_code string (20)
country string (50)
phone_work string (20)
phone_home string (20)
mail string (100)
newsletter boolean
yacht_owner boolean
type enum

boat_types

id increments
timestamps timestamps
name string (50)

requests

id increments
timestamps timestamps
contact_id ^FK integer
brand_id ^FK integer
boat_type_id ^FK integer
comments text

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