comment

Tables (7)

cmt_category

  • Key (categoryId) — bigint(20) — Primary key — NOT NULL
  • Field (categoryNm) — varchar(50)
  • Field (createId) — bigint(20)
  • Field (createDate) — datetime
  • Field (modifyId) — bigint(20)
  • Field (modifyDate) — datetime

cmt_comment

  • Key (commentId) — bigint(20) — Primary key — NOT NULL
  • Field (contentsId) — bigint(20)
  • Field (userId) — bigint(20)
  • Field (contents) — varchar(6000)
  • Field (likeCnt) — bigint(20)
  • Field (isDelete) — bigint(1)
  • Field (reportCnt) — bigint(20)
  • Field (depth) — int(20)
  • Field2 (parentsId) — bigint(20)
  • Field (createDate) — datetime
  • Field (modifyDate) — datetime

cmt_community

  • Key (communityId) — bigint(20) — Primary key — NOT NULL
  • Field (commnunityNm) — varchar(50)
  • Field (categoryId) — bigint(20)
  • Field (createId) — bigint(20)
  • Field (createDate) — datetime
  • Field (modifyId) — bigint(20)
  • Field (modifyDate) — datetime

cmt_contents (Untitled)

  • Key (contentsId) — bigint(20) — Primary key — NOT NULL
  • Field (contentsNm) — varchar(50)
  • Field (communityId) — bigint(20)
  • Field (contents) — varchar(6000)
  • Field (createId) — bigint(20)
  • Field (createDate) — datetime
  • Field (modifyId) — bigint(20)
  • Field (modifyDate) — datetime

cmt_like

  • Key (likeId) — bigint(20) — Primary key — NOT NULL
  • Field (commentId) — bigint(20)
  • Field (userId) — bigint(20)
  • Field (createDate) — datetime

cmt_report

  • Key (reportId) — bigint(20) — Primary key — NOT NULL
  • Field (commentId) — bigint(20)
  • Field (replyId) — bigint(20)
  • Field (reason) — varchar(6000)
  • Field (userId) — bigint(20)
  • Field (createDate) — datetime
  • Field (modifyDate) — datetime

cmt_user

  • Key (userId) — bigint(20) — Primary key — NOT NULL
  • Field (userNm) — varchar(20)
  • Field (adminYn) — varchar(1)
  • Field (isDelete) — bigint(1)
  • Field (createDate) — datetime
  • Field (modifyDate) — datetime