peteleta - Laravel Schema Designer

states

id integer
name string (50)
abbr string (5)

cities

id integer
state_id ^FK integer
name string (50)

companies

id increments
name string (50)
address string (50)
city_id ^FK integer
owner integer
phone string (50)
timestamps timestamps
softDeletes softDeletes

products

id increments
name string (100)
category_id ^FK integer
description text
status tinyInteger
value integer
unit string (50)
total integer
company_id ^FK integer
user_id ^FK integer
timestamps timestamps
softDeletes softDeletes

categories

id increments
name string (50)
details text

costumers

id increments
first_name string (50)
last_name string (50)
phone string (50)
address string (50)
city_id ^FK integer
timestamps timestamps
softDeletes softDeletes

sales

id increments
product_id ^FK integer
costumer_id ^FK integer
subtotal integer
taxes integer
total integer
timestamps timestamps
softDeletes softDeletes

products_sales

id increments
product_id ^FK integer
sale_id ^FK integer
amount integer
timestamps timestamps
softDeletes softDeletes

addresses

id increments
costumer_id ^FK integer
address string (50)
city_id ^FK integer
timestamps timestamps
softDeletes softDeletes

delivers

id increments
sale_id ^FK integer
costumer_id ^FK integer
address_id ^FK integer
deliver_at datetime
timestamps timestamps
softDeletes softDeletes

users

id increments
username string (50)
email string (50)
company_id ^FK integer
costumer_id ^FK integer
password string (255)
rememberToken rememberToken
softDeletes softDeletes
timestamps timestamps

images

id increments
name string (50)
type string (30)
url string (100)
timestamps timestamps

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