milspots - Laravel Schema Designer

base

base_id increments
name string
image string
address string
city string
postal_code string
x_coord float
y_coord float
description text
website string
timestamps timestamps

business

business_id increments
name string
image string
category integer
address string
phone string
postal_code string
x_coord float (10,6)
y_coord float (10,6)
score_average float
description text
website string
base_id ^FK integer
timestamps timestamps
softDeletes softDeletes

review

review_id increments
timestamps timestamps
comment_score float
comment text
user_id ^FK integer
business_id ^FK integer

favorites

fav_id increments
business_id ^FK integer
user_id ^FK integer
timestamps timestamps

followers

userA_id ^FK integer
userB_id ^FK integer
timestamps timestamps

users

user_id increments
timestamps timestamps
softDeletes softDeletes
base_id ^FK integer
name string
surname string
email string
password string
day_birth integer
month_birth string
year_birth string
image string

category

cat_id ^FK integer
cat_name string

owner

user_id ^FK integer
timestamps timestamps
business_id ^FK integer

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