create unique index jetplasma_alteration_apply_no_uindex on jetplasma_alteration_apply (no);
create unique index jetplasma_ecn_no_uindex on jetplasma_ecn (ecn_no);
alter table jetplasma_alteration_apply modify no varchar(20) not null comment '申请编号';
alter table jetplasma_eco modify alteration_id bigint not null comment '变更申请ID';
alter table jetplasma_eco modify alteration_no varchar(20) not null comment '申请编号';
alter table jetplasma_ecn modify alteration_id bigint not null comment '变更申请ID';
alter table jetplasma_ecn modify alteration_no varchar(20) not null comment '变更申请编号';
alter table jetplasma_ecn modify eco_id bigint not null comment 'ECO编号';
alter table jetplasma_ecn modify ecn_no varchar(20) not null comment 'ECN单号';
alter table jetplasma_ecn_meta modify ecn_id bigint not null comment 'ECN编号';
alter table jetplasma_ecn_progress modify ecn_id bigint not null comment '关联ECN ID';
alter table jetplasma_ecn_spread modify ecn_id bigint not null comment '所属ECN编号';
alter table jetplasma_ecn_spread modify alteration_no varchar(20) not null comment '变更申请编号';
alter table jetplasma_eco modify level varchar(60) null comment '重要程度';

alter table jetplasma_alteration_apply
    modify item_type longtext not null comment '变更项目';;

alter table jetplasma_alteration_apply
    modify attachment longtext null comment '附件';