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 审核已撤销',