test

Tables (4)

Article

  • article_index (Key) — BIGINTEGER — Primary key — NOT NULL
  • article_user_index (Key2) — BIGINTEGER — Foreign key → User.user_index — NOT NULL
  • article_title (Field) — VARCHAR()
  • article_picture (Field2) — VARCHAR()
  • article_good (Field3) — INTEGER
  • article_bad (Field4) — INTEGER
  • article_soso (Field5) — INTEGER
  • article_hit (Field6) — INTEGER
  • article_regist_time (Field7) — DATE
  • article_visible (Field9) — BOOLEAN

Comment

  • comment_index (Key) — BIGINTEGER — Primary key — NOT NULL
  • comment_user_index (Key2) — BIGINTEGER — Foreign key → User.user_index — NOT NULL
  • comment_article_index (Key3) — BIGINTEGER — Foreign key → Article.article_index — NOT NULL
  • comment_content (Field) — VARCHAR()
  • comment_good (Field2) — INTEGER
  • comment_bad (Field3) — INTEGER
  • commnet_regist_time (Field4) — DATE

Reply

  • reply_index (Key) — BIGINTEGER — Primary key — NOT NULL
  • reply_user_index (Key2) — BIGINTEGER — Foreign key → User.user_index — NOT NULL
  • reply_comment_index (Key3) — BIGINTEGER — Foreign key → Comment.comment_index — NOT NULL
  • reply_content (Field3) — VARCHAR()
  • reply_good (Field) — INTEGER
  • reply_bad (Field2) — INTEGER
  • reply_regist_time (Field4) — DATE

User

  • user_index (Key) — BIGINTEGER — Primary key — NOT NULL
  • user_email (Field) — VARCHAR()
  • user_password (Field2) — VARCHAR()
  • user_nickname (Field3) — VARCHAR()
  • user_name (Field4) — VARCHAR()
  • user_phonenumber (Field5) — VARCHAR()
  • user_birthday (Field6) — DATE