opms_backend/opms_parent/schema/tmp.sql

alter table cust_customer add `cust_province_id` INT(11) COMMENT '所在省ID' after cust_address;
alter table cust_customer add `cust_province` VARCHAR(90) COMMENT '所在省' after cust_province_id;
alter table cust_customer add `cust_city_id` INT(11) COMMENT '所在市ID' after cust_province;
alter table cust_customer add `cust_city` VARCHAR(90) COMMENT '所在市' after cust_city_id;
alter table cust_customer add `cust_region_id` INT(11) COMMENT '所在区县ID' after cust_city;
alter table cust_customer add `cust_region` VARCHAR(90) COMMENT '所在区县' after cust_region_id;
alter table cust_customer modify `cust_status` VARCHAR(4) DEFAULT 10 COMMENT '客户状态(10 待领取 20 领取审批 30 已领取)';
alter table cust_customer add `follow_up_man` VARCHAR(90) COMMENT '最后跟进人' after follow_up_date;
alter table ctr_contract_invoice modify `appro_status` varchar(4) DEFAULT NULL COMMENT '审核状态 10 待提交审核 20 待审核 30 审核已同意 40 审核已拒绝 50 审核已撤销';

alter table ctr_contract add `signatory_type` varchar(255) DEFAULT NULL COMMENT '签订单位类型 10 终端用户 20 经销商 30 代理商' after signatory_name;
alter table ctr_contract modify `incharge_name` varchar(90) COMMENT '负责人(销售工程师)';

alter table ctr_contract modify `appro_status` varchar(4) NOT NULL COMMENT '审核状态 10 待提交审核 20 待审核 30 审核已同意 40 审核已拒绝 50 审核已撤销',

alter table ctr_contract  add `cust_province_id` INT(11) COMMENT '所在省ID' after cust_name;
alter table ctr_contract  add `cust_province` VARCHAR(90) COMMENT '所在省' after cust_province_id;
alter table ctr_contract  add `cust_city_id` INT(11) COMMENT '所在市ID' after cust_province;
alter table ctr_contract  add `cust_city` VARCHAR(90) COMMENT '所在市' after cust_city_id;

alter table ctr_contract  add  `product_line` varchar(4) NOT NULL COMMENT '产品线' after cust_name;

alter table cust_customer drop column  cust_dist_code;
alter table cust_customer drop column  cust_location;
alter table ctr_contract modify `contract_end_time` datetime COMMENT '合同结束时间'

alter table base_distributor add `invoice_header` varchar(255) DEFAULT NULL COMMENT '开票抬头' after sale_num;
alter table cust_customer add `invoice_header` varchar(255) DEFAULT NULL COMMENT '开票抬头' after follow_up_man;



-- 2023-05-05
alter table ctr_contract  add  `contract_sign_time` datetime COMMENT '合同签订时间' after contract_end_time;
alter table ctr_contract  add  `signatory_unit` varchar(90) COMMENT '合同签订单位' after signatory_type;
alter table ctr_contract  add  `earnest_money` decimal(24, 6) COMMENT '质量/履约保证金（元）' after signatory_unit;

alter table ctr_contract_product  add `contract_code` varchar(32) NOT NULL COMMENT '合同编号' after contract_id;
alter table ctr_contract_product add `purchase_cost` decimal(24, 6) DEFAULT NULL COMMENT '采购成本' after contract_prive;
alter table ctr_contract_product add `dev_cost` decimal(24, 6) DEFAULT NULL COMMENT '二次开发成本' after purchase_cost;
alter table ctr_contract_product add `maintain_cost` decimal(24, 6) DEFAULT NULL COMMENT '产品维保成本' after dev_cost;
alter table ctr_contract_product add `direct_cost` decimal(24, 6) DEFAULT NULL COMMENT '直接成本' after maintain_cost;
alter table ctr_contract_product add `maintain_period` int(11) DEFAULT NULL COMMENT '质保期(天)' after direct_cost;
alter table ctr_contract_product add `warrant_period` int(11) DEFAULT NULL COMMENT '运维期(天)' after maintain_period;
alter table ctr_contract_product add `maintain_start_time` datetime DEFAULT NULL COMMENT '运维开始时间' after warrant_period;
alter table ctr_contract_product add `maintain_remark` text DEFAULT NULL COMMENT '运维约定条款' after maintain_start_time;
alter table ctr_contract_product add `accept_time` datetime DEFAULT NULL COMMENT '验收时间' after maintain_remark;

alter table ctr_contract_collection_plan add `plan_scale` decimal(24, 6) COMMENT '计划回款比例' after plan_datetime;
alter table ctr_contract_collection_plan add `plan_condition` text COMMENT '回款条件' after plan_scale;