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