hotrodeals - Laravel Schema Designer

users

id increments
username string (100)
password string (255)
email string (100)
meta text
status enum
role_id ^FK integer
no_delete tinyInteger
validated tinyInteger
remember_token string (100)
timestamps timestamps
softDeletes softDeletes

user_last_login

id increments
timestamps timestamps
user_id ^FK integer

roles

id increments
name string (20)
description string (100)
timestamps timestamps
softDeletes softDeletes

restrictions

id increments
name string (50)
description string (255)
timestamps timestamps
softDeletes softDeletes

user_restrictions

id increments
timestamps timestamps
user_id integer
restriction_id integer
expiration_date datetime
removal_date datetime
added_by integer
removed_by integer

restriction_comment

id increments
user_restriction_id integer
added_by integer
comment string (255)
timestamps timestamps
softDeletes softDeletes

user_social

id increments
timestamps timestamps

badges

id increments
name string (150)
slug string (100)
description string (255)
min_value integer
max_value integer
aplies_for enum
icon_url string (50)
timestamps timestamps

user_badge

user_id integer
badge_id integer
timestamps timestamps

user_visits

id increments
timestamps timestamps
page_id integer
page_type enum
user_id integer
count integer

images

id bigIncrements
name string (100)
extension string (20)
added_by ^FK integer
imaginable string (200)
storage string (100)
timestamps timestamps
softDeletes softDeletes

posts

id increments
title string (255)
body text
slug string (255)
user_id integer
type_id integer
status enum
expiry_date datetime
url string (512)
category_id integer
meta text
timestamps timestamps
softDeletes softDeletes

tags

id increments
name string (150)
slug string (100)
image_id integer
description text
timestamps timestamps
softDeletes softDeletes

post_tag

post_id integer
tag_id integer
timestamps timestamps

post_types

id increments
name string (255)
description text
slug string (255)
timestamps timestamps
softDeletes softDeletes

post_categories

id increments
name string (255)
description text
slug string (255)
timestamps timestamps
softDeletes softDeletes

related_tags

tag_id integer
timestamps timestamps
softDeletes softDeletes
ralated_tag_id integer

comments

id increments
post_id ^FK integer
user_id ^FK integer
comment text
status enum
parent_id integer
timestamps timestamps

votes

id bigIncrements
post_id ^FK integer
value integer
timestamps timestamps
softDeletes softDeletes

report_reasons

id increments
name string (100)
description string (255)
softDeletes softDeletes
timestamps timestamps

post_report

id increments
timestamps timestamps
softDeletes softDeletes

merchants

id increments
timestamps timestamps
softDeletes softDeletes

user_saved_posts

id increments
timestamps timestamps
softDeletes softDeletes

user_follow

id bigIncrements
timestamps timestamps
softDeletes softDeletes

post_reports

id increments
post_id ^FK integer
user_id ^FK integer
report_reason_id ^FK integer
timestamps timestamps

login_attempts

id increments
timestamps timestamps
user_id integer
login_status enum
ip string (30)
browser string (50)
os string (50)

saved_posts

id increments
timestamps timestamps

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