thanhdc - Laravel Schema Designer

users

id bigIncrements
username string (100)
email string (191)
password string (191)
remember_token string (191)
timestamps timestamps

roles

id increments
title string (191)
description string (191)
timestamps timestamps

permissions

id increments
title string (191)
description string (191)
timestamps timestamps

metas

id bigIncrements
firstname string (191)
lastname string (191)
avatar string (191)
banner string
description text
address string (191)
gender string (191)
company string (191)
favorite text
timestamps timestamps
user_id ^FK bigInteger

socials

id bigIncrements
social_user string (191)
link string (191)
user_id ^FK bigInteger
timestamps timestamps

messages

id bigIncrements
subject string (191)
from string (191)
to string (191)
content longText
timestamps timestamps
label string (191)
fold string (191)
user_id ^FK bigInteger

user_setting

id increments
timestamps timestamps
notification smallInteger
comment smallInteger
email smallInteger
phone smallInteger
address smallInteger
user_id ^FK bigInteger

login

id increments
ip string (191)
browser string (191)
attemps string (191)
timestamps timestamps
user_id ^FK bigInteger

user_role

user_id ^FK bigInteger
role_id ^FK integer

permission_role

role_id ^FK integer
permission_id ^FK integer

products

id bigIncrements
title string (191)
image string (191)
media string (191)
price decimal (10, 0)
short_text mediumText
description longText
download string (191)
category_id ^FK integer
user_id ^FK bigInteger
softDeletes softDeletes
timestamps timestamps

categories

id increments
name string (191)
slug string (191)
category_type string
timestamps timestamps

posts

id increments
title string (191)
slug string (191)
content longText
thumbnail string (191)
description text
timestamps timestamps
softDeletes softDeletes
category_id ^FK integer
user_id ^FK integer

orders

id bigIncrements
user_id ^FK integer
payment_id ^FK integer
transaction_id ^FK integer
timestamps timestamps
detail text

payments

id increments
timestamps timestamps
method string (191)
response string (50)
token string (70)

transactions

id increments
status string (100)
timestamps timestamps

order_product

order_id ^FK bigInteger
product_id ^FK bigInteger

pages

id increments
title string (191)
short_text text
content longText
thumbnail string (191)
status string (100)
timestamps timestamps
keywords string (100)
softDeletes softDeletes

settings

id increments
timestamps timestamps
key string (100)
value text
detail text
type string (191)
order integer

password_resets

email string (191)
timestamps timestamps
token string (70)

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