Home
lwhiker
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
brands
id
increments
name
string
(255)
url
string
(766)
description
string
(1024)
related_keywords
string
(1024)
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
brand_type
id
increments
timestamps
timestamps
softDeletes
softDeletes
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01