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

user (Untitled)