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