Skip to content
The Chat Archive
gpt-3.5-turbo-0301· OpenAI WildChat-4.8M (AI2)

根据这个SQL,生成一个Java实体类,基本类型不要用包装类,不需要有方法,只需要有字段。CREATE TABLE wmadcpcplan ( planid…

  1. User

    根据这个SQL,生成一个Java实体类,基本类型不要用包装类,不需要有方法,只需要有字段。CREATE TABLE wm_ad_cpc_plan ( plan_id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '投放计划 id,自增', view_id bigint(20) DEFAULT NULL COMMENT '展示ID', budget int(10) NOT NULL COMMENT '预算,精确到分', status tinyint(1) DEFAULT '1' COMMENT '投放计划状态:0:开启 1:停止', account_status tinyint(1) DEFAULT '0' COMMENT '账户上下线状态:0:上线 1:下线', budget_status tinyint(1) DEFAULT '0' COMMENT '预算上下线状态:0:上线 1:下线', start_time int(11) NOT NULL COMMENT '开始时间', end_time int(11) NOT NULL COMMENT '结束时间', ctime int(11) NOT NULL COMMENT '创建时间', utime int(11) NOT NULL COMMENT '修改时间', acct_id int(20) DEFAULT NULL COMMENT '操作账户ID', token varchar(100) DEFAULT NULL COMMENT '操作token', platform tinyint(1) NOT NULL COMMENT '操作平台 1:H5 2.PC 3:ADMIN 4:SERVER', oper_type tinyint(1) DEFAULT '0' COMMENT '操作类型:1:增加 2:修改 3:删除', ka_plan_id bigint(20) DEFAULT '0' COMMENT 'KA plan ID', is_delete tinyint(1) DEFAULT '0' COMMENT '0:未删除 1:已删除', prod_type tinyint(4) NOT NULL DEFAULT '1' COMMENT '产品类型 1:CPC列表广告 2:天降商家券', effect_prod_type varchar(50) DEFAULT NULL COMMENT '生效产品', cast_type tinyint(4) NOT NULL DEFAULT '1' COMMENT '投放类型:1-普通投放,2-自动投放', budget_type tinyint(4) NOT NULL DEFAULT '1' COMMENT '预算类型:1-红包及余额,2-仅即将过期红包', prod_acct_id bigint(20) NOT NULL DEFAULT '0' COMMENT '虚拟产品账户ID', wm_poi_id bigint(20) NOT NULL DEFAULT '0' COMMENT '门店ID', plan_type int(11) NOT NULL DEFAULT '1' COMMENT '计划类型,1:自定义,2:智能托管', optimization_detail varchar(512) NOT NULL DEFAULT '' COMMENT '智能托管的信息,包括商家设定的目标ROI、商家选择的模式', platform_type tinyint(4) NOT NULL DEFAULT '0' COMMENT '所在系统类型,1:广告主系统,2:KA系统(后续接入以此类推)', platform_account_id bigint(20) NOT NULL DEFAULT '0' COMMENT '系统账户ID 广告主系统:门店ID KA系统:KA账户ID', charge_id bigint(20) NOT NULL DEFAULT '0' COMMENT '计费账户ID', smth tinyint(2) NOT NULL DEFAULT '1' COMMENT '预算平滑 0匀速投放 1快速投放', campaign_name varchar(256) NOT NULL DEFAULT '' COMMENT '投放计划名称', common_ext_info varchar(2048) NOT NULL DEFAULT '' COMMENT '通用扩展字段', campaign_type tinyint(4) NOT NULL DEFAULT '0' COMMENT '计划类型,中小系统用默认0,1-KA 总店资金,2-KA 单店资金', __lz_update_time timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '本行更新时间', PRIMARY KEY (plan_id), UNIQUE KEY idx_view_id (view_id), KEY idx_status (status), KEY idx_kaplanid (ka_plan_id), KEY idx_id_delete (is_delete), KEY idx_wm_poi_id_prod_type (wm_poi_id,prod_type), KEY idx_kaplanid_is_delete (ka_plan_id,is_delete), KEY idx_prod_type (prod_type) USING BTREE, KEY idx_platform_account_id_platform_type (platform_account_id,platform_type), KEY idx_prod_utime_planid (prod_type,utime,plan_id), KEY idx_charge_id (charge_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='cpc投放计划表';

  2. 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; }