office booking - Laravel Schema Designer

User

id increments
timestamps timestamps
firstname string
lastname string
adresse string
city string
email string
password string
rememberToken rememberToken

Photos

id increments
timestamps timestamps
site_id ^FK integer
filepath string
is_main_photo boolean

Sites

id increments
timestamps timestamps
name string
adresse string
city string
availability boolean
description longText

Reservations

id increments
timestamps timestamps
client_id ^FK integer
site_id ^FK integer
period_id ^FK integer
number_visitors integer
note text
date date
montant decimal
payment_status boolean

Periods

id increments
timestamps timestamps
periodname string
timestart time
timeend time

Functionalities

id increments
timestamps timestamps
name string

Site_period_prices

site_id ^FK integer
period_id ^FK integer
price decimal

Products

id increments
timestamps timestamps
is_service boolean
name string
image_filepath string

Product_period_prices

id increments
timestamps timestamps
product_id ^FK integer
period_id ^FK integer
price decimal

Reservation_products

product_id ^FK integer
reservation_id ^FK integer

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