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