item-management-1phase/sql/20230213.sql

alter table post add COLUMN parent_id bigint(20) DEFAULT NULL comment '父级岗位id';
alter table customer add COLUMN user_id bigint(20) DEFAULT NULL comment '所属员工id';
alter table visit add COLUMN user_id bigint(20) DEFAULT NULL comment '所属员工id';
alter table business_opportunity add COLUMN user_id bigint(20) DEFAULT NULL comment '所属员工id';
alter table item add COLUMN user_id bigint(20) DEFAULT NULL comment '所属员工id(客户经理)';
alter table item add COLUMN customer_id bigint(20) DEFAULT NULL comment '客户id';

CREATE TABLE `user_target` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    `sale_target` double(128,2) DEFAULT NULL COMMENT '本年签约目标',
  `payment_target` double(128,2) DEFAULT NULL COMMENT '本年回款目标',
  `user_id` bigint(20) NOT NULL COMMENT '员工id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='员工目标';