tourguide - Laravel Schema Designer

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