reviewmeta - Laravel Schema Designer

users

id increments
name string (45)
gender enum
timestamps timestamps
softDeletes softDeletes

brands

id increments
name string (150)

products

id increments
brand_id integer
qid string (20)
asin string (25)
title string (255)
description text

product_categories

id increments
product_id integer
category_id integer

categories

id increments
timestamps timestamps
parent_id integer
name string (150)

reviews

id increments
user_id integer
user_ip string (45)
product_id integer
price decimal (15,2)
discounted_price double (15,2)
site_origin string (255)
search_origin string (45)
timestamps timestamps
total_reviews integer
original_ratting double (5,2)
reviewers integer
removed_reviewers integer
ratting double (5,2)

user_reviews

id increments
user_id integer
month integer
year integer
count integer

reviewers

id increments
slug string (200)
total_reviews integer
sum_ratting double (5,2)
location string (4)
verified tinyInteger
deleted_reviews integer
undescore_ratting integer
upperscore_ratting integer

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