cmstatic - Laravel Schema Designer

post

id increments
category_id ^FK integer
title string
slug string
synopsis mediumText
description string
image string
status enum
published_at datetime
timestamps timestamps
softDeletes softDeletes
meta_title string
meta_description string

category

id increments
parent_id ^FK integer
name string
slug string
timestamps timestamps
softDeletes softDeletes
created_by ^FK integer

tag

id increments
name string
slug string
created_by ^FK integer
timestamps timestamps
softDeletes softDeletes

post_tag

id increments
post_id ^FK integer
tag_id ^FK integer
timestamps timestamps
softDeletes softDeletes

users

id increments
username string
password string
email string
fullname string
about string
pic string
level enum
timestamps timestamps
softDeletes softDeletes

post_activity

id increments
users_id ^FK integer
post_id ^FK integer
data_old text
data_new text
status enum
timestamps timestamps

setting

id increments
timestamps timestamps
site_title string
site_description string
homepage_title string
facebook_app_id string
facebook_app_secret string
is_static tinyInteger
google_analytics_id string
script_head text
script_body_start text
script_body_end text
logo string
favicon string

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