RO

Tables (10)

tb_Ro_Bluemarble_GoodsOrder

  • gSeq — int — Primary key — NOT NULL
  • seq — int — NOT NULL
  • week — tinyint — NOT NULL
  • gameNum — char(4) — NOT NULL
  • goodsNum — tinyint — NOT NULL
  • sort — tinyint — NOT NULL

tb_Ro_Bluemarble_Info

  • bSeq — int — Primary key — NOT NULL
  • seq — int — NOT NULL
  • week — tinyint — NOT NULL
  • gameNum — char(10) — NOT NULL
  • limitRound — nvarchar(50) — NOT NULL
  • diceLimitNumber — tinyint — NOT NULL

tb_Ro_Bluemarble_Schedule

  • eventFolder — varchar(100) — Primary key — NOT NULL
  • Seq — int — NOT NULL
  • startDate — varchar(16) — NOT NULL
  • endDate — varchar(16) — NOT NULL
  • gameCode — char(4) — NOT NULL
  • isActive — char(1) — NOT NULL

tb_Ro_Bluemarble_UserMoveLog

  • logSeq — int — Primary key — NOT NULL
  • userID — nvarchar(50) — NOT NULL
  • userAID — int — NOT NULL
  • userAccNum — int — NOT NULL
  • userGroupNum — char(4) — NOT NULL
  • userName — nvarchar(50) — NOT NULL
  • seq — int — NOT NULL
  • week — tinyint — NOT NULL
  • gameNum — char(4) — NOT NULL
  • goodsNum — tinyint — NOT NULL
  • bfPoint — int — NOT NULL
  • usePoint — int — NOT NULL
  • afPoint — int — NOT NULL
  • prePosition — tinyint — NOT NULL
  • movePosition — tinyint — NOT NULL
  • diceNumber — tinyint — NOT NULL
  • userIP — varchar(20) — NOT NULL
  • moveFullDate — datetime — NOT NULL
  • cpFlag — char(1) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

tb_Ro_Bluemarble_UserPoint

  • upSeq — int — NOT NULL
  • seq — int — NOT NULL
  • accountID — varchar(20) — NOT NULL
  • gameAID — varchar(20) — NOT NULL
  • pointCount — int — NOT NULL
  • modifyDate — datetime — NOT NULL
  • gameCode — char(4) — NOT NULL

tb_Ro_Bluemarble_UserPoint_Log

  • upLogSeq — int — NOT NULL
  • seq — int — NOT NULL
  • accountID — varchar(12) — NOT NULL
  • gameAID — varchar(12) — NOT NULL
  • pointCount — int — NOT NULL
  • modifyDate — datetime — NOT NULL
  • gameCode — char(4) — NOT NULL
  • reasons — int — NOT NULL
  • reason1Hash — varchar(40) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

tb_Ro_Bluemarble_UserRoundLog

  • roundSeq — int — Primary key — NOT NULL
  • userID — nvarchar(50) — NOT NULL
  • userAID — int — NOT NULL
  • userAccNum — int — NOT NULL
  • userGroupNum — char(4) — NOT NULL
  • userName — nvarchar(50) — NOT NULL
  • seq — int — NOT NULL
  • week — tinyint — NOT NULL
  • gameNum — char(4) — NOT NULL
  • round — tinyint — NOT NULL
  • roundFullDate — datetime — NOT NULL
  • cpFlag — char(1) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

tb_Ro_Bluemarble_goodsApplyTotalLogByGoodsNum

  • seq — int — Primary key — NOT NULL
  • week — tinyint — Primary key — NOT NULL
  • gameCode — char(4) — Primary key — NOT NULL
  • goodsNum — tinyint — Primary key — NOT NULL
  • applyCount — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

tb_Ro_Bluemarble_goodsInfo

  • goodsSeq — int — Primary key — NOT NULL
  • seq — int — Primary key — NOT NULL
  • week — tinyint — Primary key — NOT NULL
  • goodsNum — tinyint — Primary key — NOT NULL
  • goodsName — nvarchar(100) — NOT NULL
  • liveWinCount — int — NOT NULL
  • liveWinCountNoLimitYN — char(1) — NOT NULL
  • liveWinYN — char(1) — NOT NULL
  • applyPoint — int — NOT NULL
  • applyPointKind — smallint — NOT NULL
  • gameNum — char(4)
  • applyLimitCount — int — NOT NULL
  • goodsKind — char(4) — NOT NULL

tb_Ro_Bluemarble_userPointUseLog

  • seq — int — NOT NULL
  • week — tinyint — NOT NULL
  • gameNum — char(4) — NOT NULL
  • applyPointKind — smallint — NOT NULL
  • userID — nvarchar(50) — NOT NULL
  • userAID — int — NOT NULL
  • userAccNum — int — NOT NULL
  • usePoint — int — NOT NULL
  • regiDate — datetime — NOT NULL
  • lastDate — datetime — NOT NULL
  • cpFlag — char(1) — NOT NULL