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)