mole - Laravel Schema Designer

users

id increments
name string
email string
password string
rememberToken string
timestamps timestamps

password_resets

email string
token string
timestamps timestamps

roles

id increments
softDeletes softDeletes
name string
label string
timestamps timestamps

permissions

id increments
timestamps timestamps
softDeletes softDeletes
name string
label string

sites

id increments
softDeletes softDeletes
name string
slug string (10)
hex_color string (6)
url string
logo string
type string
trust string
timestamps timestamps

categories

id increments
name string
timestamps timestamps
softDeletes softDeletes

types

id increments
name string
category_id ^FK integer
timestamps timestamps
softDeletes softDeletes

posts

id increments
site_id ^FK integer
content_id integer
user_id ^FK integer
type_id ^FK integer
category_id integer
timestamps timestamps
softDeletes softDeletes

contents

id increments
post_id ^FK integer
title string
contents string
Venue string
start_date date
start_time time
end_date date
end_time time
timestamps timestamps
softDeletes softDeletes

resources

id increments
filename string
timestamps timestamps
softDeletes softDeletes
filesize integer
post_id ^FK integer

profiles

id increments
user_id ^FK integer
forename string
surname string
signature string
profile_pic string
timestamps timestamps
softDeletes softDeletes

permission_role

permission_id ^FK integer
role_id ^FK integer

role_user

role_id ^FK integer
user_id ^FK integer

site_user

site_id ^FK integer
user_id ^FK integer

social_accounts

id increments
timestamps timestamps
site_id ^FK integer

category_site

site_id ^FK integer
category_id ^FK integer

site_type

id increments
site_id ^FK integer
type_id ^FK integer

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