jfcloud-gene/jfcloud-gene-biz/src/main/resources/sql/ddl-20250306.sql

ALTER TABLE jfcloud_gene.flow_info MODIFY COLUMN project_name varchar(500) NOT NULL COMMENT '项目名称';
ALTER TABLE jfcloud_gene.strain_purification_info MODIFY COLUMN strain_name varchar(500) NOT NULL COMMENT '品系名称';

ALTER TABLE jfcloud_gene.animal_demand MODIFY COLUMN age_weeks VARCHAR(10) NOT NULL COMMENT '周龄';
ALTER TABLE jfcloud_gene.cage_demand MODIFY COLUMN breeding_days varchar(50) NOT NULL COMMENT '饲养天数';

ALTER TABLE jfcloud_gene.flow_info ADD applicant_id bigint NULL COMMENT '申请人id' AFTER ky_id;
ALTER TABLE jfcloud_gene.flow_info ADD applicant_phone varchar(255) NULL COMMENT '申请人电话' AFTER applicant_id;