数据库表结构

管家账户管理 luban_amp_butler_account

Long id;//主键idLong channelId; //渠道idString accountName; //账户名称String accountNumber; //账户账号(id)String accountPassword; //账户密码String remarks;//备注 Date createDatetime;Long createUserId;Date updateDatetime;Long updateUserId;Boolean disabled;

渠道管理列表luban_amp_channel

Long id;           //主键idString name;   //渠道名称String shortName;   //渠道简称String type;           //渠道类型String remarks;    //备注Date createDatetime;Long createUserId;Date updateDatetime;Long updateUserId;Boolean disabled;    //删除  

推广账户分组返点信息情况表 luban_amp_promotion_account_rebate_info

Long id; //主键idLong promotionAccountId;//所属推广账户IDDate rebateStartTime;//返点开始时间Date rebateEndTime;//返点结束时间Double rebateRatio;//返点比例Date createDatetime;Long createUserId;Date updateDatetime;Long updateUserId;Boolean disabled;

推广账户管理 luban_amp_promotion_account

Long id;//主键idLong butlerId; //所属管家账户idLong agentId; //所属代理idString accountName; //账户名称String accountNumber; //账户账号(id)String accountPassword;//账户密码String operator;//投放人员String rebateInfo; //返点信息String dataReportToken; //数据报表tokenString dataReturnToken; //数据回传tokenString remarks; //备注Date createDatetime;Long createUserId;Date updateDatetime;Long updateUserId;Boolean disabled;

账户分组小组表 luban_amp_promotion_account_team

Long id;//主键idString teamName;//小组名称Long teamItemId; //小组类别IDDate createDatetime;Long createUserId;Date updateDatetime;Long updateUserId;Boolean disabled;

代理商管理 luban_amp_agent

Long id;    //主键idString name;//代理商名称String fullName;//代理商全称String shortName;  //代理商简称String cooperationStatus; //合作状态String agentUserName;//代理商务人员String agentUserPhone;//代理商务人员手机号Date rebateStartTime;//返点开始时间Date rebateEndTime; //返点结束时间Double rebateRatio; //返点比例String remarks;  //备注Date createDatetime;Long createUserId;Date updateDatetime;Long updateUserId;Boolean disabled;

账户分组小组类别表  luban_amp_promotion_account_team_item

Long id; //主键idString teamItemName; //小组类型名称Date createDatetime;Long createUserId;Date updateDatetime;Long updateUserId;Boolean disabled;

推广账户小组变动记录表 表名 luban_amp_promotion_account_team_log

Long id;//主键idLong promotionAccountId;//所属推广账户IDLong teamId; //小组IDString type;//操作类型Date createDatetime;Long createUserId;Date updateDatetime;Long updateUserId;Boolean disabled;

推广账户人员变动记录表  luban_amp_promotion_account_operator_log

Long id;//主键idLong promotionAccountId;//所属推广账户IDString operator;//操作人String type;//操作类型Date createDatetime;Long createUserId;Date updateDatetime;Long updateUserId;Boolean disabled;

计划报备表 luban_amp_plan_report

Long id;//主键idLong promotionAccountId; //对应推广账户idString planName; //计划名称Long templateId; //模板IDString callbackTypes; //回传方式Date deadLine; //截止日期String remarks;//备注Date createDatetime;Long createUserId;Date updateDatetime;Long updateUserId;Boolean disabled;

账户分组小组中账户表  luban_amp_promotion_account_team_members 

Long id;//主键id Long teamId;//小组idLong promotionAccountId;//推广账户IDDate createDatetime;Long createUserId;Date updateDatetime;Long updateUserId;Boolean disabled;