POST
Tables (3)
POST (Untitled4)
- id (Field) — bigint — Primary key
- author_id(user_id) (Field8) — bigint — Primary key
- category — enum
- title (Field3) — longtext
- date_created (Field4) — datetime(6)
- date_edited (Field5) — datetime(6)
- view_count (Field6) — int
- comment_count (Field7) — int
- author_nickname (Field10) — varchar(255)
- isCompleted (Field11) — tinyint(1)
- text(body) (Field12) — longtext
- create_ip (Field2) — varchar(255)
- vote_count (Field9) — int
PostComment (Untitled5)
- id (Field) — bigint — Primary key
- article_id (Field3) — bigint
- author_id (Field4) — bigint
- author_nickname (Field5) — varchar(255)
- isReply (Field6) — tinyint(1)
- reply_comment_id (Field7) — bigint(self-referencing)
- recommend_count (Field8) — int
- nonrecommend_count (Field9) — int
- text (Field2) — longtext