EasyPages - Laravel Schema Designer

accounts

id increments
timestamps timestamps
username string (32)
email string (255)
password string (255)
type string (1)

profiles

profile_id increments
timestamps timestamps
user_id ^FK integer
fname string (255)
lname string (255)
dob date
address_id integer
sex string (1)

reviews

review_id increments
timestamps timestamps
description string (1024)
rating integer
profile_id ^FK integer
service_id ^FK integer

services

service_id increments
timestamps timestamps
title string (255)
price decimal
description string (1024)
company_id ^FK integer

r_pictures

picture_id increments
timestamps timestamps
review_id ^FK integer
path string (1024)

s_pictures

picture_id increments
timestamps timestamps
service_id ^FK integer

p_pictures

picture_id increments
timestamps timestamps
profile_id ^FK integer
pathsmall string (1024)
pathmed string (1024)
pathlarge string (1024)

companies

company_id increments
timestamps timestamps
user_id ^FK integer
name string (250)
website string (250)
description string (512)

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