temp
Tables (15)
article
- article_index — bigint — Primary key — NOT NULL
- article_user_index — bigint — NOT NULL
- article_title — varchar(100) — NOT NULL
- article_picture — varchar(100) — NOT NULL
- article_hit — int — NOT NULL
- article_regist_time — datetime — NOT NULL
- article_visible — tinyint — NOT NULL
block
- block_user_index — bigint — Foreign key → user.user_index — NOT NULL
- block_target_index — bigint — Foreign key → user.user_index — NOT NULL
comment
- comment_index — bigint — Primary key — NOT NULL
- comment_user_index — bigint — Foreign key → user.user_index — NOT NULL
- comment_article_index — bigint — Foreign key → article.article_index — NOT NULL
- comment_content — varchar(1000) — NOT NULL
- comment_good — int
- comment_bad — int
- comment_regist_time — datetime
comment_like
- comment_like_index — bigint — Primary key — NOT NULL
- comment_like_user_index — bigint — Foreign key → user.user_index — NOT NULL
- comment_like_comment_index — bigint — Foreign key → comment.comment_index — NOT NULL
- commnet_like_valuate — tinyint(1) — NOT NULL
evaluate
- evaluate_article_index — bigint — Foreign key → article.article_index — NOT NULL
- evaluate_user_index — bigint — Foreign key → user.user_index — NOT NULL
- evaluate_value — char(1) — NOT NULL
follow
- follow_user_index — bigint — Foreign key → user.user_index — NOT NULL
- follow_target_index — bigint — Foreign key → user.user_index — NOT NULL
hashtag
- tagname — varchar(20) — Primary key — NOT NULL
hashtagging
- hashtagging_index — bigint — Primary key — NOT NULL
- hashtagging_article_index — bigint — Foreign key → article.article_index — NOT NULL
- hashtagging_tagname — varchar(20) — Foreign key → hashtag.tagname — NOT NULL
recent_view
- recent_view_article_index — bigint — Foreign key → article.article_index — NOT NULL
- recent_view_user_index — bigint — Foreign key → user.user_index — NOT NULL
- recent_view_time — datetime
reply
- reply_index — bigint — Primary key — NOT NULL
- reply_user_index — bigint — Foreign key → user.user_index — NOT NULL
- reply_comment_index — bigint — Foreign key → comment.comment_index — NOT NULL
- reply_content — varchar(1000) — NOT NULL
- reply_good — int
- reply_bad — int
- reply_regist_time — datetime
reply_like
- reply_like_index — bigint — Primary key — NOT NULL
- reply_like_user_index — bigint — Foreign key → user.user_index — NOT NULL
- reply_like_reply_index — bigint — Foreign key → reply.reply_index — NOT NULL
- reply_like_valuate — tinyint(1) — NOT NULL
report_article
- report_article_article_index — bigint — Foreign key → article.article_index — NOT NULL
- report_article_user_index — bigint — Foreign key → user.user_index — NOT NULL
- report_article_content — varchar(200)
report_comment
- report_comment_comment_index — bigint — Foreign key → comment.comment_index — NOT NULL
- report_comment_user_index — bigint — Foreign key → user.user_index — NOT NULL
- report_comment_content — varchar(200)
report_reply
- report_reply_reply_index — bigint — Foreign key → reply.reply_index — NOT NULL
- report_reply_user_index — bigint — Foreign key → user.user_index — NOT NULL
- report_reply_content — varchar(200)
user
- user_index — bigint — Primary key — NOT NULL
- user_email — varchar(100) — NOT NULL
- user_password — varchar(100) — NOT NULL
- user_nickname — varchar(100) — NOT NULL
- user_name — varchar(100) — NOT NULL
- user_phonenumber — varchar(100) — NOT NULL
- user_birthday — date — NOT NULL
- user_reported — int — NOT NULL
- user_picture — varchar(100)
- user_picture_src — varchar(100)
- user_token — varchar(100) — NOT NULL