PDF《运营中心使用指南-MarketingMgmt 1 套件基础》

9000000120206'

, '

9000000001202'

, 1, '

monthLimit'

, '

单月抽奖上限'

, null, sysdate, sysdate);

insert into MKM_T_EXTENSION (EXTENSIONID, TEMPLATEID, EXTENSIONTYPE, FIELDKEY, FIELDNAME, DICTID, CREATETIME, LASTUPDATETIME) values ('

9000000120207'

, '

9000000001202'

, 1, '

totalLimit'

, '

总抽奖上限'

, null, sysdate, sysdate);

5.4 奖品资源模板 具体SQL如下: insert into MKM_T_TEMPLATE (TEMPLATEID, TEMPLATETYPE, TEMPLATENAME, CREATETIME, LASTUPDATETIME) values ('

9000000001301'

, 3, '

奖品资源模板'

, sysdate, sysdate);

insert into MKM_T_EXTENSION (EXTENSIONID, TEMPLATEID, EXTENSIONTYPE, FIELDKEY, FIELDNAME, DICTID, CREATETIME, LASTUPDATETIME) values ('

9000000130101'

, '

9000000001301'

, 1, '

level'

, '

奖品级别'

, null, sysdate, sysdate);

insert into MKM_T_EXTENSION (EXTENSIONID, TEMPLATEID, EXTENSIONTYPE, FIELDKEY, FIELDNAME, DICTID, CREATETIME, LASTUPDATETIME) values ('

9000000130102'

, '

9000000001301'

, 1, '

levelName'

, '

奖品级别名称'

, null, sysdate, sysdate);

insert into MKM_T_EXTENSION (EXTENSIONID, TEMPLATEID, EXTENSIONTYPE, FIELDKEY, FIELDNAME, DICTID, CREATETIME, LASTUPDATETIME) values ('

9000000130103'

, '

9000000001301'

, 1, '

winningRate'

, '

中奖率,单位是百分比%'

, null, sysdate, sysdate);

insert into MKM_T_EXTENSION (EXTENSIONID, TEMPLATEID, EXTENSIONTYPE, FIELDKEY, FIELDNAME, DICTID, CREATETIME, LASTUPDATETIME) values ('

9000000130104'

, '

9000000001301'

, 1, '

valueInfo'

, '

奖品价值'

, null, sysdate, sysdate);

insert into MKM_T_EXTENSION (EXTENSIONID, TEMPLATEID, EXTENSIONTYPE, FIELDKEY, FIELDNAME, DICTID, CREATETIME, LASTUPDATETIME) values ('

9000000130105'

, '

9000000001301'

, 2, '

awardResourceType'

, '

奖品类型'

, '

9000000000007'

, sysdate, sysdate);

6 预置字典 6.1 场景描述 抽奖活动主要涉及4个模板,其中奖品资源模板需要使用到奖品资源类型,因此还 需要定义一个奖品资源类型的数据字典 6.2 奖品资源类型数据字典 建议ENUMID预留后3位,方便后期扩展,具体SQL如下: insert into MKM_T_DICTIONARY (DICTID, DICTTYPE, NAME, DICTDESC, CREATETIME, LASTUPDATETIME) values ('

9000000000007'

, 2, '

奖品资源的枚举值'

, '

奖品资源的枚举值'

, sysdate, sysdate);

insert into MKM_T_ENUMDATA (ENUMID, DICTID, DATATYPE, DATANAME, DATAVALUE, CREATETIME, LASTUPDATETIME) values ('

9000000007001'

, '

9000000000007'

, 3, '

0'

, '

积分'

, sysdate, sysdate);

insert into MKM_T_ENUMDATA (ENUMID, DICTID, DATATYPE, DATANAME, DATAVALUE, CREATETIME, LASTUPDATETIME) values ('

9000000007002'

, '

9000000000007'

, 3, '

1'

, '

书券'

, sysdate, sysdate);

insert into MKM_T_ENUMDATA (ENUMID, DICTID, DATATYPE, DATANAME, DATAVALUE, CREATETIME, LASTUPDATETIME) values ('

9000000007003........