| feature_dev_moment | CREATE TABLE feature_dev_moment (
recdate date NOT NULL COMMENT ‘日期’,
osid smallint(6) NOT NULL COMMENT ‘操作系统版本1-iOS 2-安卓’,
gameid varchar(255) NOT NULL DEFAULT ‘’,
cid varchar(20) NOT NULL DEFAULT ‘’ COMMENT ‘渠道ID’,
aid varchar(20) NOT NULL DEFAULT ‘’ COMMENT ‘广告位ID’,
oid varchar(20) NOT NULL DEFAULT ‘’ COMMENT ‘落地页ID’,
pt int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘平台ID’,
moment varchar(5) NOT NULL DEFAULT ‘0’ COMMENT ‘时刻’,
payment decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘投入’,
installCount int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘安装设备数-激活设备数’,
regLoginCount int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘注册账号数(平台登录)’,
regDevCount int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘注册设备数(平台登录)’,
newLoginCount int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘新登账户数’,
newDevCount int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘新登设备数’,
loginCount int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘总登录’,
newUserRoleCount int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘当天创角账号数’,
userRoleCount int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘总创角账号数’,
didNewCount int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘设备新登数(当天设备首登去重)’,
newUserIncome decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘当日充值金额’,
newUserPaypeople int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘当日充值人数’,
todayPay6people int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘至今充值6元的人数’,
todayIncome decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘至今充值金额’,
todayPaypeople int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘至今充值人数’,
newUserIncome_after decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘当日充值金额-账后’,
todayIncome_after decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘至今充值金额-账后’,
userLive1 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘次留人数’,
userLive3 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘3留人数’,
userLive4 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘4留人数’,
userLive5 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘5留人数’,
userLive6 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘6留人数’,
userLive7 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘7留人数’,
userLive8 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘8留人数’,
userLive9 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘9留人数’,
userLive10 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘10留人数’,
userLive11 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘11留人数’,
userLive12 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘12留人数’,
userLive13 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘13留人数’,
userLive14 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘14留人数’,
userLive15 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘15留人数’,
userLive16 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘16留人数’,
userLive30 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘30留人数’,
userLive60 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘60留人数’,
userLive90 int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘90留人数’,
ltv1Icome decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘等时1充值’,
ltv1Icome_after decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘等时账后充值’,
ltv3Icome decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘等时3充值’,
ltv3Icome_after decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘等时账后充值’,
ltv7Icome decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘等时7充值’,
ltv7Icome_after decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘等时7账后充值’,
ltv15Icome decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘等时15充值’,
ltv15Icome_after decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘等时15账后充值’,
ltv30Icome decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘等时30充值’,
ltv30Icome_after decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘等时30账后充值’,
ltv45Icome decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘等时45充值’,
ltv45Icome_after decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘等时45账后充值’,
ltv60Icome decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘等时60充值’,
ltv60Icome_after decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘等时60账后充值’,
ltv90Icome decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘等时90充值’,
ltv90Icome_after decimal(15,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘等时90账后充值’,
inner_time timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT ‘timestamp’,
newDidRoleCount int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘新登创角设备数’,
didRoleCount int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘总创角设备数’,
field_1 int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘备用字段’,
field_2 decimal(10,0) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘备用字段’,
PRIMARY KEY (recdate,osid,gameid,cid,aid,oid,pt,moment) /*T![clustered_index] NONCLUSTERED */,
KEY index_id (gameid,cid,aid,oid,moment,pt)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘用户特征报表-时间时刻’