KB - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
fullname string (255)
slug string (255)
email string (255)
password string
timezone string
avatar string
phone string

companies

id increments
timestamps timestamps
softDeletes softDeletes
name string
logo string
slug string
user_id integer
employee_size integer
visibility enum
description string
support_email string

user_companies

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
company_id integer

templates

id increments
timestamps timestamps
softDeletes softDeletes
name string
slug string
description string

company_templates

id increments
timestamps timestamps
softDeletes softDeletes
company_id integer
template_id integer

categories

id increments
timestamps timestamps
softDeletes softDeletes
name string
slug string
description string

company_categories

id increments
timestamps timestamps
softDeletes softDeletes
company_id integer
category_id integer

sections

id increments
timestamps timestamps
softDeletes softDeletes
name string
slug string
visibility enum

category_sections

id increments
timestamps timestamps
softDeletes softDeletes
category_id integer
section_id integer

articles

id increments
timestamps timestamps
softDeletes softDeletes
title string
slug string
content longText
status enum
user_id integer
company_id integer
visibility enum

section_articles

id increments
timestamps timestamps
softDeletes softDeletes
section_id integer
article_id integer

tags

id increments
timestamps timestamps
softDeletes softDeletes
name string
slug string

article_tags

id increments
timestamps timestamps
softDeletes softDeletes
article_id integer
tag_id integer

user_articles

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
article_id integer

permissions

id increments
timestamps timestamps
softDeletes softDeletes
name string

roles

id increments
timestamps timestamps
softDeletes softDeletes
name string
user_id integer
company_id integer

role_permissions

id increments
timestamps timestamps
softDeletes softDeletes
role_id integer
permission_id integer

user_roles

id increments
timestamps timestamps
softDeletes softDeletes
role_id integer
user_id integer
company_id integer

article_suggestions

id increments
timestamps timestamps
softDeletes softDeletes
article_id integer
suggestions string
name string
email string

support

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
question string
description string

article_analytics

id increments
timestamps timestamps
softDeletes softDeletes
article_id integer
views integer
helpful integer
not_helpful integer

search_analytics

id increments
timestamps timestamps
softDeletes softDeletes
query string
found boolean
read boolean
bounced boolean

category_analytics

id increments
timestamps timestamps
softDeletes softDeletes
category_id integer
views integer

plans

id increments
timestamps timestamps
softDeletes softDeletes
name string
months integer
price float

company_plan

id increments
timestamps timestamps
softDeletes softDeletes
company_id integer
plan_id integer

billing

id increments
timestamps timestamps
softDeletes softDeletes
company_id integer
plan_id integer
price float
month enum
type enum

domains

id increments
timestamps timestamps
softDeletes softDeletes
name string

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