lwhiker - Laravel Schema Designer

brands

id increments
name string (255)
url string (766)
description string (1024)
related_keywords string (1024)
youtube_cache binary
youtube_cache_updated date
reddit_cache binary
reddit_cache_updated date
submitted_by_user_id ^FK integer
timestamps timestamps

products

id increments
name string (255)
brand_id ^FK integer
description text
url string (512)
price float
weight float
upc string (255)
submitted_by_user_id ^FK integer
timestamps timestamps

Users

id increments
firstname string (40)
lastname string (40)
email string (100)
password string (64)
timestamps timestamps

reviews

id increments
user_id ^FK integer
product_id ^FK integer
review text
rating float
timestamps timestamps

keywords

id increments
keyword string (255)
timestamps timestamps

keyword_product

id increments
keyword_id ^FK integer
product_id ^FK integer
timestamps timestamps

brand_keyword

id increments
keyword_id ^FK integer
brand_id ^FK integer
timestamps timestamps

notifications

id increments
notification_rule_id ^FK integer
emailed boolean
email binary
timestamps timestamps

notification_rules

id increments
search_type string (10)
match_string string (255)
user_id ^FK integer
timestamps timestamps

sources

id increments
name string (64)
thread_id_prefix string (3)
type string (12)
base_url string (1024)
thread_url string (1024)
threads_last_updated datetime
timestamps timestamps

threads

id increments
source_id ^FK integer
title string (766)
content text
thread_identifier string (256)
date_posted datetime
attempted integer
tweeted integer
timestamps timestamps

tweets

id increments
tweet string (160)
thread_id ^FK integer
timestamps timestamps

searchs

id increments
search_type string (4)
keyword_id ^FK integer
ip_address_id ^FK integer
user_id integer
timestamps timestamps

ips

id increments
ip_address string (46)
hostname string (255)
ignore boolean
timestamps timestamps

pageviews

id increments
uri string (512)
user_id integer
ip_address_id ^FK integer
timestamps timestamps

keyword_review

id increments
keyword_id integer
review_id integer
timestamps timestamps

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