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