Home
Intranet
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (1)
users
id
increments
first_name
string
last_name
string
email
string
password
string
(60)
dob
date
phone
string
(100)
title
string
(255)
avatar_id
integer
timestamps
timestamps
post
id
increments
title
string
(255)
body
text
excerpt
text
slug
string
post_type
string
approved
boolean
publish_date
timestamp
is_approved
boolean
user_id
integer
tenant_id
integer
timestamps
timestamps
events
id
increments
title
string
body
string
start_time
timestamp
end_time
timestamp
excerpt
string
publish_date
timestamp
user_id
integer
tenant_id
integer
is_approved
boolean
timestamps
timestamps
groups
id
increments
member_name
string
timestamps
timestamps
tenant_id
integer
tenants
id
increments
name
string
city
string
state
string
site_logo
string
is_national
boolean
softDeletes
softDeletes
timestamps
timestamps
knowledge_base
id
increments
title
string
user_id
integer
content_type
string
body
text
timestamps
timestamps
S3_files_storage
id
increments
storable_id
integer
storable_type
string
(255)
file_name
string
file_hash
string
media_type
string
tenant_id
integer
timestamps
timestamps
tenant_meta
id
increments
metable_id
integer
metable_type
string
(255)
key
string
(128)
value
text
×
Comments for Intranet
tannermccoleman . 15 November 2016
Site and tenants are the same thing, use only one
Social_media should be a meta
Standardize the naming conventions
Simplify naming convention
video tables aren't needed as they will be hosted offsite
Images should be held in a single table using morph relations
All links tables should be a meta
Dropbox metadata should be cached outside of database to avoid excessive read/writes
Add body to events
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01