根据这个SQL,生成一个Java实体类,基本类型不要用包装类,不需要有方法,只需要有字段。CREATE TABLE wmadcpcplan ( planid…
- User
根据这个SQL,生成一个Java实体类,基本类型不要用包装类,不需要有方法,只需要有字段。CREATE TABLE
wm_ad_cpc_plan(plan_idbigint(20) NOT NULL AUTO_INCREMENT COMMENT '投放计划 id,自增',view_idbigint(20) DEFAULT NULL COMMENT '展示ID',budgetint(10) NOT NULL COMMENT '预算,精确到分',statustinyint(1) DEFAULT '1' COMMENT '投放计划状态:0:开启 1:停止',account_statustinyint(1) DEFAULT '0' COMMENT '账户上下线状态:0:上线 1:下线',budget_statustinyint(1) DEFAULT '0' COMMENT '预算上下线状态:0:上线 1:下线',start_timeint(11) NOT NULL COMMENT '开始时间',end_timeint(11) NOT NULL COMMENT '结束时间',ctimeint(11) NOT NULL COMMENT '创建时间',utimeint(11) NOT NULL COMMENT '修改时间',acct_idint(20) DEFAULT NULL COMMENT '操作账户ID',tokenvarchar(100) DEFAULT NULL COMMENT '操作token',platformtinyint(1) NOT NULL COMMENT '操作平台 1:H5 2.PC 3:ADMIN 4:SERVER',oper_typetinyint(1) DEFAULT '0' COMMENT '操作类型:1:增加 2:修改 3:删除',ka_plan_idbigint(20) DEFAULT '0' COMMENT 'KA plan ID',is_deletetinyint(1) DEFAULT '0' COMMENT '0:未删除 1:已删除',prod_typetinyint(4) NOT NULL DEFAULT '1' COMMENT '产品类型 1:CPC列表广告 2:天降商家券',effect_prod_typevarchar(50) DEFAULT NULL COMMENT '生效产品',cast_typetinyint(4) NOT NULL DEFAULT '1' COMMENT '投放类型:1-普通投放,2-自动投放',budget_typetinyint(4) NOT NULL DEFAULT '1' COMMENT '预算类型:1-红包及余额,2-仅即将过期红包',prod_acct_idbigint(20) NOT NULL DEFAULT '0' COMMENT '虚拟产品账户ID',wm_poi_idbigint(20) NOT NULL DEFAULT '0' COMMENT '门店ID',plan_typeint(11) NOT NULL DEFAULT '1' COMMENT '计划类型,1:自定义,2:智能托管',optimization_detailvarchar(512) NOT NULL DEFAULT '' COMMENT '智能托管的信息,包括商家设定的目标ROI、商家选择的模式',platform_typetinyint(4) NOT NULL DEFAULT '0' COMMENT '所在系统类型,1:广告主系统,2:KA系统(后续接入以此类推)',platform_account_idbigint(20) NOT NULL DEFAULT '0' COMMENT '系统账户ID 广告主系统:门店ID KA系统:KA账户ID',charge_idbigint(20) NOT NULL DEFAULT '0' COMMENT '计费账户ID',smthtinyint(2) NOT NULL DEFAULT '1' COMMENT '预算平滑 0匀速投放 1快速投放',campaign_namevarchar(256) NOT NULL DEFAULT '' COMMENT '投放计划名称',common_ext_infovarchar(2048) NOT NULL DEFAULT '' COMMENT '通用扩展字段',campaign_typetinyint(4) NOT NULL DEFAULT '0' COMMENT '计划类型,中小系统用默认0,1-KA 总店资金,2-KA 单店资金',__lz_update_timetimestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '本行更新时间', PRIMARY KEY (plan_id), UNIQUE KEYidx_view_id(view_id), KEYidx_status(status), KEYidx_kaplanid(ka_plan_id), KEYidx_id_delete(is_delete), KEYidx_wm_poi_id_prod_type(wm_poi_id,prod_type), KEYidx_kaplanid_is_delete(ka_plan_id,is_delete), KEYidx_prod_type(prod_type) USING BTREE, KEYidx_platform_account_id_platform_type(platform_account_id,platform_type), KEYidx_prod_utime_planid(prod_type,utime,plan_id), KEYidx_charge_id(charge_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='cpc投放计划表'; - Assistant
public class WmAdCpcPlan { private long planId; private Long viewId; private int budget; private byte status; private byte accountStatus; private byte budgetStatus; private int startTime; private int endTime; private int ctime; private int utime; private int acctId; private String token; private byte platform; private byte operType; private long kaPlanId; private byte isDelete; private byte prodType; private String effectProdType; private byte castType; private byte budgetType; private long prodAcctId; private long wmPoiId; private int planType; private String optimizationDetail; private byte platformType; private long platformAccountId; private long chargeId; private byte smth; private String campaignName; private String commonExtInfo; private byte campaignType; }