modular-admin - Laravel Schema Designer

customers

id increments
customer_type char (2)
name string (45)
nickname string (45)
email string
password string (50)
cpf_cnpj string (14)
rg_ie string (13)
phone string (15)
active tinyInteger
softDeletes softDeletes

customer_addresses

id increments
customer_id ^FK integer
zipcode string (10)
street string (45)
number string (15)
district string
city string (45)
state char (2)
timestamps timestamps

categories

id increments
parent_id integer
name string (50)
description string (100)
timestamps timestamps

products

id increments
category_id ^FK integer
name string (50)
description string (100)
price decimal (8,2)
stock integer
weight float
length float
width float
height float
timestamps timestamps

customer_password_resets

id increments
customer_id ^FK integer
token string (100)
expire_at timestamps
timestamps timestamps

entity_images

id increments
timestamps timestamps
entity enum
entity_id integer
path string

freights

id increments
timestamps timestamps
name string
price_km string
distance_tolerated string

freight_categories

id increments
category_id ^FK integer
freight_id ^FK integer
timestamps timestamps

orders

id increments
customer_id ^FK integer
zipcode string (10)
street string (45)
number string (15)
district string (100)
city string (45)
state string (2)
note text
payment_method string
timestamps timestamps

order_products

id increments
order_id ^FK integer
product_id ^FK integer
timestamps timestamps

users

id increments
name string (100)
email string (100)
password string (100)
remember_token string (100)
timestamps timestamps

variants

id increments
product_id ^FK integer
timestamps timestamps

patrimonies

id increments
product_id ^FK integer
number bigInteger
available tinyInteger
timestamps timestamps
softDeletes softDeletes

variant_values

id increments
variant_id ^FK integer
key string
value string
timestamps timestamps

order_status

id increments
status string
timestamps timestamps
order_id ^FK integer

delivery_addresses

id increments
customer_id ^FK integer
zipcode integer
street string (45)
number string (15)
district string (100)
city string (45)
state string (2)
timestamps timestamps

banks

id increments
number integer
name string (50)
initials string (10)
timestamps timestamps

bank_accounts

id increments
description string
agency string
number string
wallet integer
bank_id ^FK integer
benefeciary_id ^FK integer
timestamps timestamps
title string (10)

beneficiaries

id increments
cprf string (14)
full_name string (100)
presentation_name string (50)
email string (100)
timestamps timestamps

beneficiary_addresses

id increments
beneficiary_id ^FK integer
zipcode string (10)
street string (45)
number string (15)
district string
city string (45)
state char (2)
timestamps timestamps

payment_slips

title string (10)
id increments
accept boolean
document string (15)
number string (50)
sequential integer
emission date
due_date date
value decimal (8,2)
timestamps timestamps
interest decimal (8,2)
mulct decimal (8,2)
instruction string
bank_account_id ^FK integer
customer_id ^FK integer

payment_methods

id increments
name string
timestamps timestamps

payment_slip

id increments
order_id ^FK integer
token_slip string
timestamps timestamps

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