11
Tables (8)
cmt_comment
- Key (commentId) — bigint(20) — Primary key — NOT NULL
- Field (parentId) — bigint(20)
- Field (commentGroupId) — bigint(20)
- Field2 (serviceId) — bigint(20)
- Field (platformId) — bigint(20)
- Field (content) — varchar(6000)
- Field3 (release) — varchar(3)
- Field (userId) — bigint(20)
- Field (userName) — varchar(50)
- Field (createDate) — datetime
- Field (modifyDate) — datetime
cmt_comment_emotion
- Key (emotionId) — bigint(20) — Primary key — NOT NULL
- Field (commentId) — bigint(20)
- Field (commentGroupId) — bigint(20)
- Field2 (serviceId) — bigint(20)
- Field (platformId) — bigint(20)
- Field (emotion) — varchar(20)
- Field (userId) — bigint(20)
- Field (createDate) — datetime
- Field (modifyDate) — datetime
cmt_comment_group
- Key (commentGroupId) — bigint(20) — Primary key — NOT NULL
- Field (commentGroupName) — varchar(50)
- Field2 (serviceId) — bigint(20)
- Field (platformId) — bigint(20)
- Field3 (release) — varchar(3)
- Field (userId) — bigint(20)
- Field (createDate) — datetime
- Field (modifyDate) — datetime
cmt_comment_report
- Key (reportId) — bigint(20) — Primary key — NOT NULL
- Field (commentId) — varchar(50)
- Field (reason) — varchar(5000)
- Field (userId) — bigint(20)
- Field (createDate) — datetime
cmt_platform
- Key (platformId) — bigint(20) — Primary key — NOT NULL
- svcId (platformName) — varchar(50)
- releasee (svcId) — int(11)
- Field4 (rekease) — varchar(3)
- Field5 (languageCode) — varchar(6)
- Field (createUser) — varchar(50)
- Field (modifyUser) — varchar(50)
- Field (createDate) — datetime
- Field (modifyDate) — datetime
cmt_service (cmt_channel)
- Key (channelId) — bigint(20) — Primary key — NOT NULL
- Field (channelName) — varchar(50)
- Field2 (platformId) — bigint(20)
- Field (viewType) — varchar(10)
- Field3 (release) — varchar(3)
- Field (createUser) — varchar(50)
- Field (modifyUser) — varchar(50)
- Field (createDate) — datetime
- Field (modifyDate) — datetime
cmt_user
- Key (userId) — bigint(20) — Primary key — NOT NULL
- Field (nexonSn) — varchar(20)
- Field2 (npsn) — varchar(20)
- Field (isAdmin) — tinyint(1)
- Field2 (isDelete) — tinyint(1)
- Field (createDate) — datetime
- Field (modifyDate) — datetime
cmt_user_mapping
- Key (mappingId) — bigint(20) — Primary key — NOT NULL
- Field (userId) — bigint(20)
- Field2 (platformId) — bigint(20)