247 - Laravel Schema Designer

users

id increments
store_id integer
timestamps timestamps
active_at timestamp
softDeletes softDeletes
rememberToken rememberToken
activation_key string
password string
email string (255)
firstname string (255)
lastname string (255)
latitude decimal
longitude decimal

products

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
rating_value float
rating_count integer
sku bigInteger
slug string (255)
store_id string

reviews

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
product_id ^FK integer
rating float
comment text

users_logs

id increments
timestamps timestamps
site_id ^FK integer
user_id ^FK integer
business_id ^FK integer
type enum
location string (255)

pages

id increments
timestamps timestamps
softDeletes softDeletes
store_id ^FK integer
user_id ^FK integer
title string (255)
content text
slug string (255)
header string (255)
icon string (255)

news

id increments
timestamps timestamps
softDeletes softDeletes
site_id ^FK integer
user_id ^FK integer
title string (255)
subtitle string (255)
slug string (255)
content text
visible datetime

user_product

id increments
timestamps timestamps
user_id ^FK integer
product_id ^FK integer

indexes

index_id increments
timestamps timestamps
id integer
model string
keywords text
site_id ^FK integer

categories

id increments
timestamps timestamps
softDeletes softDeletes
name string
parent ^FK integer
store_id ^FK integer

products_categories

id increments
timestamps timestamps
product_id ^FK integer
category_id ^FK integer

shops

id increments
timestamps timestamps
softDeletes softDeletes
name string
domain string
lang string

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