Home
tourguide
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
tours
id
increments
timestamps
timestamps
title
string
(128)
author_id
FK
integer
short_description
text
description
text
thumbnail_id
FK
integer
timerange_hours
decimal
tourstops
id
increments
timestamps
timestamps
title
string
(128)
city_id
integer
state_id
FK
integer
zip
string
(12)
short_description
text
long_description
text
thumbnail_id
FK
integer
latitude
decimal
(8,3)
longitude
decimal
(8,3)
public
tinyInteger
tourlists
id
increments
timestamps
timestamps
title
string
(128)
author_id
FK
integer
users
id
increments
timestamps
timestamps
first_name
string
(64)
last_name
string
(64)
email
string
(128)
website
string
(128)
city
string
(1228)
state_id
FK
integer
zip
string
(12)
remember_token
string
(100)
password
string
(60)
api_key
string
(100)
display_name
string
mediaresources
id
increments
mediatype_id
FK
integer
timestamps
timestamps
title
string
(128)
filename
string
(128)
description
text
comments
id
increments
timestamps
timestamps
user_id
FK
integer
rating
smallInteger
text
text
useractivities
id
increments
timestamps
timestamps
user_id
FK
integer
activity_id
integer
tags
id
increments
timestamps
timestamps
tag
string
(64)
mediatypes
id
increments
timestamps
timestamps
states
id
increments
timestamps
timestamps
name
string
(128)
code
string
(2)
userfollows
id
increments
timestamps
timestamps
user_id
FK
integer
followed_user_id
FK
integer
taggables
id
increments
timestamps
timestamps
tag_id
integer
taggable_id
integer
taggable_type
string
(128)
tags_hack
id
increments
timestamps
timestamps
favoritables
id
increments
timestamps
timestamps
user_id
integer
favoritable_id
integer
favoritable_type
string
(128)
users_hack
id
increments
timestamps
timestamps
tours_hack
id
increments
timestamps
timestamps
tourstops_hack
id
increments
timestamps
timestamps
tourlists_hack
id
increments
timestamps
timestamps
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01