add to bookmark
report abuse
document
doc_id INT
title VARCHAR(255)
content_text TEXT
thumbnail VARCHAR(255)
file_size INT
user_id INT
views_count INT
download_count INT
rating_count FLOAT
is_public INT
page_count INT
category VARCHAR(45)
tags VARCHAR(45)
is_deleted BOOLEAN
Indexes
views
view_id INT
ip_address VARCHAR(15)
user_agent VARCHAR(255)
doc_id INT
date DATETIME
uid INT
is_download INT
Indexes
comments
comment_id INT
user_id INT
comment VARCHAR(255)
doc_id INT
date DATETIME
ip VARCHAR(15)
user_agent VARCHAR(255)
Indexes
ref_category
ref_category_id INT
parent_id INT
category_name VARCHAR(50)
category_slug VARCHAR(100)
Indexes
rating
rating_id INT
doc_id INT
rate_value INT
date DATETIME
ip_address VARCHAR(15)
user_agent VARCHAR(255)
user_id INT
Indexes
search_terms
search_term_id INT
ip_address VARCHAR(15)
user_agent VARCHAR(255)
term_id INT
date DATETIME
doc_id INT
Indexes
ref_term
ref_term_id INT
term VARCHAR(255)
term_slug VARCHAR(255)
Indexes
ref_tags
ref_tag_id INT
tag VARCHAR(255)
tag_slug VARCHAR(255)
Indexes
tags
tag_id INT
doc_id INT
ref_tag_id INT
Indexes
users
user_id INT
name VARCHAR(255)
email VARCHAR(255)
password VARCHAR(255)
prof_pic VARCHAR(255)
bio VARCHAR(255)
Indexes
category
category_id INT
ref_category_id INT
doc_id INT
Indexes
