post-check-api/sql/UpdateTable.sql

ALTER TABLE "public"."post_checked" RENAME COLUMN "remark_info" TO remark;
ALTER TABLE "public"."post_checked" RENAME COLUMN "is_del" TO del_flag;
ALTER TABLE "public"."post_checked" MODIFY COLUMN "del_flag" CHARACTER(1 char);
ALTER TABLE "public"."post_checked" MODIFY COLUMN "del_flag" CHARACTER DEFAULT '0'::bpchar;
ALTER TABLE "public"."post_checked" MODIFY COLUMN "del_flag" CHARACTER COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_checked" RENAME COLUMN "create_date" TO create_time;
ALTER TABLE "public"."post_checked" RENAME COLUMN "create_user_id" TO create_by;
ALTER TABLE "public"."post_checked" MODIFY COLUMN "create_by" CHARACTER VARYING(64 char);
ALTER TABLE "public"."post_checked" MODIFY COLUMN "create_by" CHARACTER VARYING DEFAULT ''::varchar;
ALTER TABLE "public"."post_checked" MODIFY COLUMN "create_by" CHARACTER VARYING COMMENT '创建者';
ALTER TABLE "public"."post_checked" RENAME COLUMN "update_date" TO update_time;
ALTER TABLE "public"."post_checked" RENAME COLUMN "update_user_id" TO update_by;
ALTER TABLE "public"."post_checked" MODIFY COLUMN "update_by" bigint DEFAULT ''::varchar;
ALTER TABLE "public"."post_checked" MODIFY COLUMN "update_by" bigint COMMENT '更新者';

ALTER TABLE "public"."post_checked_items" RENAME COLUMN "remark_info" TO remark;
ALTER TABLE "public"."post_checked_items" RENAME COLUMN "is_del" TO del_flag;
ALTER TABLE "public"."post_checked_items" MODIFY COLUMN "del_flag" CHARACTER(1 char);
ALTER TABLE "public"."post_checked_items" MODIFY COLUMN "del_flag" CHARACTER DEFAULT '0'::bpchar;
ALTER TABLE "public"."post_checked_items" MODIFY COLUMN "del_flag" CHARACTER COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_checked_items" RENAME COLUMN "create_date" TO create_time;
ALTER TABLE "public"."post_checked_items" RENAME COLUMN "create_user_id" TO create_by;
ALTER TABLE "public"."post_checked_items" MODIFY COLUMN "create_by" CHARACTER VARYING(64 char);
ALTER TABLE "public"."post_checked_items" MODIFY COLUMN "create_by" CHARACTER VARYING DEFAULT ''::varchar;
ALTER TABLE "public"."post_checked_items" MODIFY COLUMN "create_by" CHARACTER VARYING COMMENT '创建者';
ALTER TABLE "public"."post_checked_items" RENAME COLUMN "update_date" TO update_time;
ALTER TABLE "public"."post_checked_items" RENAME COLUMN "update_user_id" TO update_by;
ALTER TABLE "public"."post_checked_items" MODIFY COLUMN "update_by" bigint DEFAULT ''::varchar;
ALTER TABLE "public"."post_checked_items" MODIFY COLUMN "update_by" bigint COMMENT '更新者';

ALTER TABLE "public"."post_checked_problem" RENAME COLUMN "remark_info" TO remark;
ALTER TABLE "public"."post_checked_problem" RENAME COLUMN "is_del" TO del_flag;
ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "del_flag" CHARACTER(1 char);
ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "del_flag" CHARACTER DEFAULT '0'::bpchar;
ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "del_flag" CHARACTER COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_checked_problem" RENAME COLUMN "create_date" TO create_time;
ALTER TABLE "public"."post_checked_problem" RENAME COLUMN "create_user_id" TO create_by;
ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "create_by" CHARACTER VARYING(64 char);
ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "create_by" CHARACTER VARYING DEFAULT ''::varchar;
ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "create_by" CHARACTER VARYING COMMENT '创建者';
ALTER TABLE "public"."post_checked_problem" RENAME COLUMN "update_date" TO update_time;
ALTER TABLE "public"."post_checked_problem" RENAME COLUMN "update_user_id" TO update_by;
ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "update_by" bigint DEFAULT ''::varchar;
ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "update_by" bigint COMMENT '更新者';

ALTER TABLE "public"."post_checked_report" RENAME COLUMN "remark_info" TO remark;
ALTER TABLE "public"."post_checked_report" RENAME COLUMN "is_del" TO del_flag;
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "del_flag" CHARACTER(1 char);
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "del_flag" CHARACTER DEFAULT '0'::bpchar;
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "del_flag" CHARACTER COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_checked_report" RENAME COLUMN "create_date" TO create_time;
ALTER TABLE "public"."post_checked_report" RENAME COLUMN "create_user_id" TO create_by;
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "create_by" CHARACTER VARYING(64 char);
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "create_by" CHARACTER VARYING DEFAULT ''::varchar;
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "create_by" CHARACTER VARYING COMMENT '创建者';
ALTER TABLE "public"."post_checked_report" RENAME COLUMN "update_date" TO update_time;
ALTER TABLE "public"."post_checked_report" RENAME COLUMN "update_user_id" TO update_by;
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "update_by" bigint DEFAULT ''::varchar;
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "update_by" bigint COMMENT '更新者';

ALTER TABLE "public"."post_highlights" RENAME COLUMN "remark_info" TO remark;
ALTER TABLE "public"."post_highlights" RENAME COLUMN "is_del" TO del_flag;
ALTER TABLE "public"."post_highlights" MODIFY COLUMN "del_flag" CHARACTER(1 char);
ALTER TABLE "public"."post_highlights" MODIFY COLUMN "del_flag" CHARACTER DEFAULT '0'::bpchar;
ALTER TABLE "public"."post_highlights" MODIFY COLUMN "del_flag" CHARACTER COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_highlights" RENAME COLUMN "create_date" TO create_time;
ALTER TABLE "public"."post_highlights" RENAME COLUMN "create_user_id" TO create_by;
ALTER TABLE "public"."post_highlights" MODIFY COLUMN "create_by" CHARACTER VARYING(64 char);
ALTER TABLE "public"."post_highlights" MODIFY COLUMN "create_by" CHARACTER VARYING DEFAULT ''::varchar;
ALTER TABLE "public"."post_highlights" MODIFY COLUMN "create_by" CHARACTER VARYING COMMENT '创建者';
ALTER TABLE "public"."post_highlights" RENAME COLUMN "update_date" TO update_time;
ALTER TABLE "public"."post_highlights" RENAME COLUMN "update_user_id" TO update_by;
ALTER TABLE "public"."post_highlights" MODIFY COLUMN "update_by" bigint DEFAULT ''::varchar;
ALTER TABLE "public"."post_highlights" MODIFY COLUMN "update_by" bigint COMMENT '更新者';

ALTER TABLE "public"."post_list" RENAME COLUMN "remark_info" TO remark;
ALTER TABLE "public"."post_list" RENAME COLUMN "is_del" TO del_flag;
ALTER TABLE "public"."post_list" MODIFY COLUMN "del_flag" CHARACTER(1 char);
ALTER TABLE "public"."post_list" MODIFY COLUMN "del_flag" CHARACTER DEFAULT '0'::bpchar;
ALTER TABLE "public"."post_list" MODIFY COLUMN "del_flag" CHARACTER COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_list" RENAME COLUMN "create_date" TO create_time;
ALTER TABLE "public"."post_list" RENAME COLUMN "create_user_id" TO create_by;
ALTER TABLE "public"."post_list" MODIFY COLUMN "create_by" CHARACTER VARYING(64 char);
ALTER TABLE "public"."post_list" MODIFY COLUMN "create_by" CHARACTER VARYING DEFAULT ''::varchar;
ALTER TABLE "public"."post_list" MODIFY COLUMN "create_by" CHARACTER VARYING COMMENT '创建者';
ALTER TABLE "public"."post_list" RENAME COLUMN "update_date" TO update_time;
ALTER TABLE "public"."post_list" RENAME COLUMN "update_user_id" TO update_by;
ALTER TABLE "public"."post_list" MODIFY COLUMN "update_by" bigint DEFAULT ''::varchar;
ALTER TABLE "public"."post_list" MODIFY COLUMN "update_by" bigint COMMENT '更新者';

ALTER TABLE "public"."post_list_info" RENAME COLUMN "remark_info" TO remark;
ALTER TABLE "public"."post_list_info" RENAME COLUMN "is_del" TO del_flag;
ALTER TABLE "public"."post_list_info" MODIFY COLUMN "del_flag" CHARACTER(1 char);
ALTER TABLE "public"."post_list_info" MODIFY COLUMN "del_flag" CHARACTER DEFAULT '0'::bpchar;
ALTER TABLE "public"."post_list_info" MODIFY COLUMN "del_flag" CHARACTER COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_list_info" RENAME COLUMN "create_date" TO create_time;
ALTER TABLE "public"."post_list_info" RENAME COLUMN "create_user_id" TO create_by;
ALTER TABLE "public"."post_list_info" MODIFY COLUMN "create_by" CHARACTER VARYING(64 char);
ALTER TABLE "public"."post_list_info" MODIFY COLUMN "create_by" CHARACTER VARYING DEFAULT ''::varchar;
ALTER TABLE "public"."post_list_info" MODIFY COLUMN "create_by" CHARACTER VARYING COMMENT '创建者';
ALTER TABLE "public"."post_list_info" RENAME COLUMN "update_date" TO update_time;
ALTER TABLE "public"."post_list_info" RENAME COLUMN "update_user_id" TO update_by;
ALTER TABLE "public"."post_list_info" MODIFY COLUMN "update_by" bigint DEFAULT ''::varchar;
ALTER TABLE "public"."post_list_info" MODIFY COLUMN "update_by" bigint COMMENT '更新者';

ALTER TABLE "public"."post_plan" RENAME COLUMN "remark_info" TO remark;
ALTER TABLE "public"."post_plan" RENAME COLUMN "is_del" TO del_flag;
ALTER TABLE "public"."post_plan" MODIFY COLUMN "del_flag" CHARACTER(1 char);
ALTER TABLE "public"."post_plan" MODIFY COLUMN "del_flag" CHARACTER DEFAULT '0'::bpchar;
ALTER TABLE "public"."post_plan" MODIFY COLUMN "del_flag" CHARACTER COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_plan" RENAME COLUMN "create_date" TO create_time;
ALTER TABLE "public"."post_plan" RENAME COLUMN "create_user_id" TO create_by;
ALTER TABLE "public"."post_plan" MODIFY COLUMN "create_by" CHARACTER VARYING(64 char);
ALTER TABLE "public"."post_plan" MODIFY COLUMN "create_by" CHARACTER VARYING DEFAULT ''::varchar;
ALTER TABLE "public"."post_plan" MODIFY COLUMN "create_by" CHARACTER VARYING COMMENT '创建者';
ALTER TABLE "public"."post_plan" RENAME COLUMN "update_date" TO update_time;
ALTER TABLE "public"."post_plan" RENAME COLUMN "update_user_id" TO update_by;
ALTER TABLE "public"."post_plan" MODIFY COLUMN "update_by" bigint DEFAULT ''::varchar;
ALTER TABLE "public"."post_plan" MODIFY COLUMN "update_by" bigint COMMENT '更新者';


ALTER TABLE "public"."post_plan_info" RENAME COLUMN "remark_info" TO remark;
ALTER TABLE "public"."post_plan_info" RENAME COLUMN "is_del" TO del_flag;
ALTER TABLE "public"."post_plan_info" MODIFY COLUMN "del_flag" CHARACTER(1 char);
ALTER TABLE "public"."post_plan_info" MODIFY COLUMN "del_flag" CHARACTER DEFAULT '0'::bpchar;
ALTER TABLE "public"."post_plan_info" MODIFY COLUMN "del_flag" CHARACTER COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_plan_info" RENAME COLUMN "create_date" TO create_time;
ALTER TABLE "public"."post_plan_info" RENAME COLUMN "create_user_id" TO create_by;
ALTER TABLE "public"."post_plan_info" MODIFY COLUMN "create_by" CHARACTER VARYING(64 char);
ALTER TABLE "public"."post_plan_info" MODIFY COLUMN "create_by" CHARACTER VARYING DEFAULT ''::varchar;
ALTER TABLE "public"."post_plan_info" MODIFY COLUMN "create_by" CHARACTER VARYING COMMENT '创建者';
ALTER TABLE "public"."post_plan_info" RENAME COLUMN "update_date" TO update_time;
ALTER TABLE "public"."post_plan_info" RENAME COLUMN "update_user_id" TO update_by;
ALTER TABLE "public"."post_plan_info" MODIFY COLUMN "update_by" bigint DEFAULT ''::varchar;
ALTER TABLE "public"."post_plan_info" MODIFY COLUMN "update_by" bigint COMMENT '更新者';

ALTER TABLE "public"."post_plan_info_user" RENAME COLUMN "remark_info" TO remark;
ALTER TABLE "public"."post_plan_info_user" RENAME COLUMN "is_del" TO del_flag;
ALTER TABLE "public"."post_plan_info_user" MODIFY COLUMN "del_flag" CHARACTER(1 char);
ALTER TABLE "public"."post_plan_info_user" MODIFY COLUMN "del_flag" CHARACTER DEFAULT '0'::bpchar;
ALTER TABLE "public"."post_plan_info_user" MODIFY COLUMN "del_flag" CHARACTER COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_plan_info_user" RENAME COLUMN "create_date" TO create_time;
ALTER TABLE "public"."post_plan_info_user" RENAME COLUMN "create_user_id" TO create_by;
ALTER TABLE "public"."post_plan_info_user" MODIFY COLUMN "create_by" CHARACTER VARYING(64 char);
ALTER TABLE "public"."post_plan_info_user" MODIFY COLUMN "create_by" CHARACTER VARYING DEFAULT ''::varchar;
ALTER TABLE "public"."post_plan_info_user" MODIFY COLUMN "create_by" CHARACTER VARYING COMMENT '创建者';
ALTER TABLE "public"."post_plan_info_user" RENAME COLUMN "update_date" TO update_time;
ALTER TABLE "public"."post_plan_info_user" RENAME COLUMN "update_user_id" TO update_by;
ALTER TABLE "public"."post_plan_info_user" MODIFY COLUMN "update_by" bigint DEFAULT ''::varchar;
ALTER TABLE "public"."post_plan_info_user" MODIFY COLUMN "update_by" bigint COMMENT '更新者';


ALTER TABLE "public"."post_programme" RENAME COLUMN "remark_info" TO remark;
ALTER TABLE "public"."post_programme" RENAME COLUMN "is_del" TO del_flag;
ALTER TABLE "public"."post_programme" MODIFY COLUMN "del_flag" CHARACTER(1 char);
ALTER TABLE "public"."post_programme" MODIFY COLUMN "del_flag" CHARACTER DEFAULT '0'::bpchar;
ALTER TABLE "public"."post_programme" MODIFY COLUMN "del_flag" CHARACTER COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_programme" RENAME COLUMN "create_date" TO create_time;
ALTER TABLE "public"."post_programme" RENAME COLUMN "create_user_id" TO create_by;
ALTER TABLE "public"."post_programme" MODIFY COLUMN "create_by" CHARACTER VARYING(64 char);
ALTER TABLE "public"."post_programme" MODIFY COLUMN "create_by" CHARACTER VARYING DEFAULT ''::varchar;
ALTER TABLE "public"."post_programme" MODIFY COLUMN "create_by" CHARACTER VARYING COMMENT '创建者';
ALTER TABLE "public"."post_programme" RENAME COLUMN "update_date" TO update_time;
ALTER TABLE "public"."post_programme" RENAME COLUMN "update_user_id" TO update_by;
ALTER TABLE "public"."post_programme" MODIFY COLUMN "update_by" bigint DEFAULT ''::varchar;
ALTER TABLE "public"."post_programme" MODIFY COLUMN "update_by" bigint COMMENT '更新者';


ALTER TABLE "public"."post_programme_template" RENAME COLUMN "remark_info" TO remark;
ALTER TABLE "public"."post_programme_template" RENAME COLUMN "is_del" TO del_flag;
ALTER TABLE "public"."post_programme_template" MODIFY COLUMN "del_flag" CHARACTER(1 char);
ALTER TABLE "public"."post_programme_template" MODIFY COLUMN "del_flag" CHARACTER DEFAULT '0'::bpchar;
ALTER TABLE "public"."post_programme_template" MODIFY COLUMN "del_flag" CHARACTER COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_programme_template" RENAME COLUMN "create_date" TO create_time;
ALTER TABLE "public"."post_programme_template" RENAME COLUMN "create_user_id" TO create_by;
ALTER TABLE "public"."post_programme_template" MODIFY COLUMN "create_by" CHARACTER VARYING(64 char);
ALTER TABLE "public"."post_programme_template" MODIFY COLUMN "create_by" CHARACTER VARYING DEFAULT ''::varchar;
ALTER TABLE "public"."post_programme_template" MODIFY COLUMN "create_by" CHARACTER VARYING COMMENT '创建者';
ALTER TABLE "public"."post_programme_template" RENAME COLUMN "update_date" TO update_time;
ALTER TABLE "public"."post_programme_template" RENAME COLUMN "update_user_id" TO update_by;
ALTER TABLE "public"."post_programme_template" MODIFY COLUMN "update_by" bigint DEFAULT ''::varchar;
ALTER TABLE "public"."post_programme_template" MODIFY COLUMN "update_by" bigint COMMENT '更新者';

ALTER TABLE "public"."post_team" RENAME COLUMN "remark_info" TO remark;
ALTER TABLE "public"."post_team" RENAME COLUMN "is_del" TO del_flag;
ALTER TABLE "public"."post_team" MODIFY COLUMN "del_flag" CHARACTER(1 char);
ALTER TABLE "public"."post_team" MODIFY COLUMN "del_flag" CHARACTER DEFAULT '0'::bpchar;
ALTER TABLE "public"."post_team" MODIFY COLUMN "del_flag" CHARACTER COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_team" RENAME COLUMN "create_date" TO create_time;
ALTER TABLE "public"."post_team" RENAME COLUMN "create_user_id" TO create_by;
ALTER TABLE "public"."post_team" MODIFY COLUMN "create_by" CHARACTER VARYING(64 char);
ALTER TABLE "public"."post_team" MODIFY COLUMN "create_by" CHARACTER VARYING DEFAULT ''::varchar;
ALTER TABLE "public"."post_team" MODIFY COLUMN "create_by" CHARACTER VARYING COMMENT '创建者';
ALTER TABLE "public"."post_team" RENAME COLUMN "update_date" TO update_time;
ALTER TABLE "public"."post_team" RENAME COLUMN "update_user_id" TO update_by;
ALTER TABLE "public"."post_team" MODIFY COLUMN "update_by" bigint DEFAULT ''::varchar;
ALTER TABLE "public"."post_team" MODIFY COLUMN "update_by" bigint COMMENT '更新者';

ALTER TABLE "public"."post_team_user" RENAME COLUMN "remark_info" TO remark;
ALTER TABLE "public"."post_team_user" RENAME COLUMN "is_del" TO del_flag;
ALTER TABLE "public"."post_team_user" MODIFY COLUMN "del_flag" CHARACTER(1 char);
ALTER TABLE "public"."post_team_user" MODIFY COLUMN "del_flag" CHARACTER DEFAULT '0'::bpchar;
ALTER TABLE "public"."post_team_user" MODIFY COLUMN "del_flag" CHARACTER COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_team_user" RENAME COLUMN "create_date" TO create_time;
ALTER TABLE "public"."post_team_user" RENAME COLUMN "create_user_id" TO create_by;
ALTER TABLE "public"."post_team_user" MODIFY COLUMN "create_by" CHARACTER VARYING(64 char);
ALTER TABLE "public"."post_team_user" MODIFY COLUMN "create_by" CHARACTER VARYING DEFAULT ''::varchar;
ALTER TABLE "public"."post_team_user" MODIFY COLUMN "create_by" CHARACTER VARYING COMMENT '创建者';
ALTER TABLE "public"."post_team_user" RENAME COLUMN "update_date" TO update_time;
ALTER TABLE "public"."post_team_user" RENAME COLUMN "update_user_id" TO update_by;
ALTER TABLE "public"."post_team_user" MODIFY COLUMN "update_by" bigint DEFAULT ''::varchar;
ALTER TABLE "public"."post_team_user" MODIFY COLUMN "update_by" bigint COMMENT '更新者';


ALTER TABLE "public"."post_checked" MODIFY COLUMN "create_by" varchar(64);
ALTER TABLE "public"."post_checked" MODIFY COLUMN "update_by" varchar(64);
ALTER TABLE "public"."post_checked_items" MODIFY COLUMN "create_by" varchar(64);
ALTER TABLE "public"."post_checked_items" MODIFY COLUMN "update_by" varchar(64);
ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "create_by" varchar(64);
ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "update_by" varchar(64);
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "create_by" varchar(64);
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "update_by" varchar(64);
ALTER TABLE "public"."post_highlights" MODIFY COLUMN "create_by" varchar(64);
ALTER TABLE "public"."post_highlights" MODIFY COLUMN "update_by" varchar(64);
ALTER TABLE "public"."post_list" MODIFY COLUMN "create_by" varchar(64);
ALTER TABLE "public"."post_list" MODIFY COLUMN "update_by" varchar(64);
ALTER TABLE "public"."post_list_info" MODIFY COLUMN "create_by" varchar(64);
ALTER TABLE "public"."post_list_info" MODIFY COLUMN "update_by" varchar(64);
ALTER TABLE "public"."post_plan" MODIFY COLUMN "create_by" varchar(64);
ALTER TABLE "public"."post_plan" MODIFY COLUMN "update_by" varchar(64);
ALTER TABLE "public"."post_plan_info" MODIFY COLUMN "create_by" varchar(64);
ALTER TABLE "public"."post_plan_info" MODIFY COLUMN "update_by" varchar(64);
ALTER TABLE "public"."post_plan_info_user" MODIFY COLUMN "create_by" varchar(64);
ALTER TABLE "public"."post_plan_info_user" MODIFY COLUMN "update_by" varchar(64);
ALTER TABLE "public"."post_programme" MODIFY COLUMN "create_by" varchar(64);
ALTER TABLE "public"."post_programme" MODIFY COLUMN "update_by" varchar(64);
ALTER TABLE "public"."post_programme_template" MODIFY COLUMN "create_by" varchar(64);
ALTER TABLE "public"."post_programme_template" MODIFY COLUMN "update_by" varchar(64);
ALTER TABLE "public"."post_team" MODIFY COLUMN "create_by" varchar(64);
ALTER TABLE "public"."post_team" MODIFY COLUMN "update_by" varchar(64);
ALTER TABLE "public"."post_team_user" MODIFY COLUMN "create_by" varchar(64);
ALTER TABLE "public"."post_team_user" MODIFY COLUMN "update_by" varchar(64);

ALTER TABLE "public"."post_checked" ADD COLUMN create_user_id bigint COMMENT '创建者用户ID';
ALTER TABLE "public"."post_checked_items" ADD COLUMN create_user_id bigint COMMENT '创建者用户ID';
ALTER TABLE "public"."post_checked_problem" ADD COLUMN create_user_id bigint COMMENT '创建者用户ID';
ALTER TABLE "public"."post_checked_report" ADD COLUMN create_user_id bigint COMMENT '创建者用户ID';
ALTER TABLE "public"."post_highlights" ADD COLUMN create_user_id bigint COMMENT '创建者用户ID';
ALTER TABLE "public"."post_list" ADD COLUMN create_user_id bigint COMMENT '创建者用户ID';
ALTER TABLE "public"."post_list_info" ADD COLUMN create_user_id bigint COMMENT '创建者用户ID';
ALTER TABLE "public"."post_plan" ADD COLUMN create_user_id bigint COMMENT '创建者用户ID';
ALTER TABLE "public"."post_plan_info" ADD COLUMN create_user_id bigint COMMENT '创建者用户ID';
ALTER TABLE "public"."post_plan_info_user" ADD COLUMN create_user_id bigint COMMENT '创建者用户ID';
ALTER TABLE "public"."post_programme" ADD COLUMN create_user_id bigint COMMENT '创建者用户ID';
ALTER TABLE "public"."post_programme_template" ADD COLUMN create_user_id bigint COMMENT '创建者用户ID';
ALTER TABLE "public"."post_team" ADD COLUMN create_user_id bigint COMMENT '创建者用户ID';
ALTER TABLE "public"."post_team_user" ADD COLUMN create_user_id bigint COMMENT '创建者用户ID';

ALTER TABLE "public"."post_programme" MODIFY COLUMN "post_programme_template_id" bigint COMMENT '废弃-因为改为多模板共存了：方案模板表ID';

ALTER TABLE "public"."post_team" ADD COLUMN TYPE integer COMMENT '类型：1-联合办公室；2-岗检工作组；3-工作小组；';

CREATE TABLE "public"."post_team_dept" (
	"id" bigint NOT NULL,
	"post_team_id" character varying(255 char) NULL,
	"dept_id" bigint NULL,
	"type" integer NULL,
	"remark" character varying(500 char) NULL,
	"del_flag" character(1 char) NOT NULL DEFAULT '0'::bpchar,
	"create_time" timestamp(0) with time zone NOT NULL,
	"create_by" character varying(64 char) NOT NULL DEFAULT ''::varchar,
	"update_time" timestamp(0) with time zone NOT NULL,
	"update_by" character varying(64 char) NOT NULL DEFAULT ''::varchar,
	"create_user_id" bigint NULL,
	PRIMARY KEY (id)
);
ALTER TABLE "public"."post_team_dept" COMMENT '岗检工作组关联部门';
ALTER TABLE "public"."post_team_dept" MODIFY "id" COMMENT '主键ID';
ALTER TABLE "public"."post_team_dept" MODIFY "post_team_id" COMMENT '岗检小组ID';
ALTER TABLE "public"."post_team_dept" MODIFY "dept_id" COMMENT '部门ID';
ALTER TABLE "public"."post_team_dept" MODIFY "type" COMMENT '类型（1-牵头部门；2-成员部门）';
ALTER TABLE "public"."post_team_dept" MODIFY "remark" COMMENT '备注';
ALTER TABLE "public"."post_team_dept" MODIFY "del_flag" COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_team_dept" MODIFY "create_time" COMMENT '创建时间';
ALTER TABLE "public"."post_team_dept" MODIFY "create_by" COMMENT '创建者';
ALTER TABLE "public"."post_team_dept" MODIFY "update_time" COMMENT '更新时间';
ALTER TABLE "public"."post_team_dept" MODIFY "update_by" COMMENT '更新者';
ALTER TABLE "public"."post_team_dept" MODIFY "create_user_id" COMMENT '创建者用户ID';

ALTER TABLE "public"."post_team_dept" MODIFY COLUMN "dept_id" bigint NOT NULL;
ALTER TABLE "public"."post_team_dept" MODIFY COLUMN "type" integer NOT NULL;
ALTER TABLE "public"."post_team_dept" MODIFY COLUMN "type" integer DEFAULT 1;

ALTER TABLE "public"."post_team_user" MODIFY COLUMN "type" integer COMMENT '类型（1-负责人；2-小组成员；）';

ALTER TABLE "public"."post_plan" ADD COLUMN check_workgroup_id bigint NOT NULL COMMENT '检查工作组ID';
ALTER TABLE "public"."post_plan" ADD COLUMN check_group_id bigint NOT NULL COMMENT '检查小组';

ALTER TABLE "public"."post_plan_info" DROP COLUMN "check_group_id";
ALTER TABLE "public"."post_plan_info" RENAME COLUMN "check_workgroup_id" TO post_id;
ALTER TABLE "public"."post_plan_info" MODIFY COLUMN "post_id" bigint COMMENT '被检查岗位ID';

ALTER TABLE "public"."post_programme" DROP COLUMN "post_programme_template_id";
ALTER TABLE "public"."post_programme" ADD COLUMN disk_path varchar(255) NOT NULL COMMENT '岗检方案文件地址';


CREATE TABLE "public"."post_checked_problem" (
	"id" bigint NOT NULL,
	"status" integer NOT NULL DEFAULT 1,
	"problem_no" character varying(255 char) NOT NULL,
	"check_workgroup_id" bigint NOT NULL,
	"check_group_id" bigint NOT NULL,
	"check_user_id" bigint NOT NULL,
	"dept_approve_user_id" bigint NULL,
	"dept_approve_time" timestamp(0) with time zone NULL,
	"speciality_department_reviewer_id" bigint NULL,
	"speciality_department_review_time" timestamp with time zone NULL,
	"problem_level" character varying(255 char) NOT NULL,
	"problem_attribute" character varying(255 char) NOT NULL,
	"problem_category" character varying(255 char) NOT NULL,
	"description" character varying(512 char) NULL,
	"problem_cause" character varying(512 char) NULL,
	"is_immediately_corrected" integer NOT NULL,
	"rectification_measure" character varying(512 char) NULL,
	"checked_dept_id" bigint NOT NULL,
	"checked_post_id" bigint NOT NULL,
	"rectification_responsible_user_id" bigint NULL,
	"rectification_period" timestamp(0) with time zone NULL,
	"is_rectification_completed" integer NULL,
	"rectification_completion_time" timestamp(0) with time zone NULL,
	"rectification_completion_img" character varying(255 char) NULL,
	"review_department_reviewer_id" bigint NULL,
	"review_department_reviewer_time" datetime NULL,
	"review_conclusion" character varying(255 char) NULL,
	"reason" character varying(255 char) NULL,
	"remark" character varying(500 char) NULL,
	"del_flag" character(1 char) NOT NULL DEFAULT '0'::bpchar,
	"create_time" timestamp(0) with time zone NOT NULL,
	"create_by" character varying(64 char) NOT NULL DEFAULT ''::varchar,
	"update_time" timestamp(0) with time zone NOT NULL,
	"update_by" character varying(64 char) NOT NULL DEFAULT ''::varchar,
	"create_user_id" bigint NULL,
	"check_time" datetime NULL,
	CONSTRAINT "post_checked_problem_pkey" PRIMARY KEY (id)
);
ALTER TABLE "public"."post_checked_problem" COMMENT '岗检问题录入表';
ALTER TABLE "public"."post_checked_problem" MODIFY "id" COMMENT '主键ID';
ALTER TABLE "public"."post_checked_problem" MODIFY "status" COMMENT '状态：1-待指定整改人（问题录入完成时）；2-待填写方案（部门管理员指定整改人后）；3-方案填写完成；10-部门审核通过；11-部门审核驳回；20-专业部门人审核（非必填）通过；21-专业部门人审核驳回（非必填）；30-整改人待上传实施（整改人上传实施图片）；31-上传实施照片完成；40-复查部门人审核通过；41-复查部门人审核驳回';
ALTER TABLE "public"."post_checked_problem" MODIFY "problem_no" COMMENT '问题编号（需要甲方提供规则规则）';
ALTER TABLE "public"."post_checked_problem" MODIFY "check_workgroup_id" COMMENT '检查工作组ID';
ALTER TABLE "public"."post_checked_problem" MODIFY "check_group_id" COMMENT '检查小组ID';
ALTER TABLE "public"."post_checked_problem" MODIFY "check_user_id" COMMENT '检查人员ID';
ALTER TABLE "public"."post_checked_problem" MODIFY "dept_approve_user_id" COMMENT '审核1：整改部门经理ID';
ALTER TABLE "public"."post_checked_problem" MODIFY "dept_approve_time" COMMENT '审核1：整改部门经理审核时间';
ALTER TABLE "public"."post_checked_problem" MODIFY "speciality_department_reviewer_id" COMMENT '审核2：专业部门的审核人ID（非必选，方案填写人选择）';
ALTER TABLE "public"."post_checked_problem" MODIFY "speciality_department_review_time" COMMENT '审核2：专业部门审核人审核时间';
ALTER TABLE "public"."post_checked_problem" MODIFY "problem_level" COMMENT '问题等级（一般、重要）';
ALTER TABLE "public"."post_checked_problem" MODIFY "problem_attribute" COMMENT '问题属性（完整问题、有效性问题、适宜性问题）';
ALTER TABLE "public"."post_checked_problem" MODIFY "problem_category" COMMENT '问题类别（职责权限问题、工作内容问题、工作标准问题、考核奖励问题、任职资格问题、其他）';
ALTER TABLE "public"."post_checked_problem" MODIFY "description" COMMENT '问题描述';
ALTER TABLE "public"."post_checked_problem" MODIFY "problem_cause" COMMENT '问题原因';
ALTER TABLE "public"."post_checked_problem" MODIFY "is_immediately_corrected" COMMENT '是否立行立改(1-Yes；2-No；)';
ALTER TABLE "public"."post_checked_problem" MODIFY "rectification_measure" COMMENT '整改措施';
ALTER TABLE "public"."post_checked_problem" MODIFY "checked_dept_id" COMMENT '整改责任部门ID（被检查部门ID）';
ALTER TABLE "public"."post_checked_problem" MODIFY "checked_post_id" COMMENT '整改责任岗位ID（被检查岗位ID）';
ALTER TABLE "public"."post_checked_problem" MODIFY "rectification_responsible_user_id" COMMENT '整改责任人ID';
ALTER TABLE "public"."post_checked_problem" MODIFY "rectification_period" COMMENT '整改期限';
ALTER TABLE "public"."post_checked_problem" MODIFY "is_rectification_completed" COMMENT '整改情况-是否完成(1-Yes；2-No；)';
ALTER TABLE "public"."post_checked_problem" MODIFY "rectification_completion_time" COMMENT '整改完成时间';
ALTER TABLE "public"."post_checked_problem" MODIFY "rectification_completion_img" COMMENT '整改完成图片磁盘路径';
ALTER TABLE "public"."post_checked_problem" MODIFY "review_department_reviewer_id" COMMENT '审核3：复查部门的审核人ID（措施上传时必选，实施人选择）';
ALTER TABLE "public"."post_checked_problem" MODIFY "review_department_reviewer_time" COMMENT '审核3：复查部门的审核人复查时间';
ALTER TABLE "public"."post_checked_problem" MODIFY "review_conclusion" COMMENT '复查结论';
ALTER TABLE "public"."post_checked_problem" MODIFY "reason" COMMENT '未通过理由';
ALTER TABLE "public"."post_checked_problem" MODIFY "remark" COMMENT '备注';
ALTER TABLE "public"."post_checked_problem" MODIFY "del_flag" COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_checked_problem" MODIFY "create_time" COMMENT '创建时间';
ALTER TABLE "public"."post_checked_problem" MODIFY "create_by" COMMENT '创建者';
ALTER TABLE "public"."post_checked_problem" MODIFY "update_time" COMMENT '更新时间';
ALTER TABLE "public"."post_checked_problem" MODIFY "update_by" COMMENT '更新者';
ALTER TABLE "public"."post_checked_problem" MODIFY "create_user_id" COMMENT '创建者用户ID';
ALTER TABLE "public"."post_checked_problem" MODIFY "check_time" COMMENT '检查时间';



CREATE TABLE "public"."post_checked_problem_record" (
	"id" bigint NOT NULL,
	"problem_id" bigint NOT NULL,
	"user_by" varchar NOT NULL,
	"content" varchar NOT NULL,
	"remark" character varying(500 char) NULL,
	"del_flag" character(1 char) NOT NULL DEFAULT '0'::bpchar,
	"create_time" timestamp(0) with time zone NOT NULL,
	"create_by" character varying(64 char) NOT NULL DEFAULT ''::varchar,
	"update_time" timestamp(0) with time zone NOT NULL,
	"update_by" character varying(64 char) NOT NULL DEFAULT ''::varchar,
	"create_user_id" bigint NULL,
	"check_time" datetime NULL,
	CONSTRAINT "post_checked_problem_record_pkey" PRIMARY KEY (id)
);
ALTER TABLE "public"."post_checked_problem_record" MODIFY "id" COMMENT '主键ID';
ALTER TABLE "public"."post_checked_problem_record" MODIFY "problem_id" COMMENT '问题ID（多）';
ALTER TABLE "public"."post_checked_problem_record" MODIFY "user_by" COMMENT '操作者姓名';
ALTER TABLE "public"."post_checked_problem_record" MODIFY "content" COMMENT '操作内容';
ALTER TABLE "public"."post_checked_problem_record" MODIFY "remark" COMMENT '备注';
ALTER TABLE "public"."post_checked_problem_record" MODIFY "del_flag" COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_checked_problem_record" MODIFY "create_time" COMMENT '创建时间';
ALTER TABLE "public"."post_checked_problem_record" MODIFY "create_by" COMMENT '创建者';
ALTER TABLE "public"."post_checked_problem_record" MODIFY "update_time" COMMENT '更新时间';
ALTER TABLE "public"."post_checked_problem_record" MODIFY "update_by" COMMENT '更新者';


ALTER TABLE "public"."post_programme" ADD COLUMN dept_id bigint COMMENT '提交部门ID';
ALTER TABLE "public"."post_programme" ADD COLUMN dept_name varchar(64) COMMENT '提交部门名称';

ALTER TABLE "public"."post_plan" MODIFY COLUMN "status" integer NOT NULL;
ALTER TABLE "public"."post_plan" ADD COLUMN status_icfa INT  NULL COMMENT '1-内控法务部审批-状态：1-待审核；3-通过；4-驳回；';
ALTER TABLE "public"."post_plan" ADD COLUMN date_icfa DATETIME  NULL COMMENT '1-内控法务部审批-通过日期';
ALTER TABLE "public"."post_plan" ADD COLUMN reason_icfa varchar(255)  NULL COMMENT '1-内控法务部审批-未通过理由';
ALTER TABLE "public"."post_plan" ADD COLUMN status_hr int  NULL COMMENT '2-人力资源审批-状态：1-待审核；3-通过；4-驳回；';
ALTER TABLE "public"."post_plan" ADD COLUMN date_hr DATETIME  NULL COMMENT '2-人力资源审批-通过日期';
ALTER TABLE "public"."post_plan" ADD COLUMN reason_hr varchar(255) NULL COMMENT '2-人力资源审批-未通过理由';

ALTER TABLE "public"."post_programme" MODIFY COLUMN "status_hr" integer COMMENT '1-人力资源审批-状态：1-待审核；3-通过；4-驳回；';
ALTER TABLE "public"."post_programme" MODIFY COLUMN "date_hr" timestamp WITH time ZONE COMMENT '1-人力资源审批-通过日期';
ALTER TABLE "public"."post_programme" MODIFY COLUMN "reason_hr" CHARACTER VARYING COMMENT '1-人力资源审批-未通过理由';
ALTER TABLE "public"."post_programme" MODIFY COLUMN "status_icfa" integer COMMENT '2-内控法务部审批-状态：1-待审核；3-通过；4-驳回；';
ALTER TABLE "public"."post_programme" MODIFY COLUMN "date_icfa" timestamp WITH time ZONE COMMENT '2-内控法务部审批-通过日期';
ALTER TABLE "public"."post_programme" MODIFY COLUMN "reason_icfa" CHARACTER VARYING COMMENT '2-内控法务部审批-未通过理由';


ALTER TABLE "public"."post_programme" ADD COLUMN status_time DATETIME NULL COMMENT '审核时间';
ALTER TABLE "public"."post_programme" ADD COLUMN status_user_id bigint NULL COMMENT '审核时人ID';
ALTER TABLE "public"."post_plan" ADD COLUMN status_time DATETIME NULL COMMENT '审核时间';
ALTER TABLE "public"."post_plan" ADD COLUMN status_user_id bigint NULL COMMENT '审核时人ID';

ALTER TABLE "public"."post_programme" ADD COLUMN status_icfa_user_id integer COMMENT '2-内控法务部审批人ID';
ALTER TABLE "public"."post_programme" ADD COLUMN status_hr_user_id integer COMMENT '1-人力资源审批人ID';

ALTER TABLE "public"."post_plan" ADD COLUMN status_icfa_user_id integer COMMENT '1-内控法务部审批人ID';
ALTER TABLE "public"."post_plan" ADD COLUMN status_hr_user_id integer COMMENT '2-人力资源审批人ID';

ALTER TABLE "public"."post_team_dept" RENAME COLUMN "dept_id" TO group_team_name;
ALTER TABLE "public"."post_team_dept" MODIFY COLUMN "group_team_name" varchar;
ALTER TABLE "public"."post_team_dept" MODIFY COLUMN "group_team_name" varchar COMMENT '岗检工作组名称（与部门不相关，自定义的名称，例如：综合岗检工作组、生产岗检工作组）';
ALTER TABLE "public"."post_team_dept" MODIFY COLUMN "type" integer COMMENT '类型（1-牵头；2-成员）';

ALTER TABLE "public"."post_team_user" MODIFY COLUMN "type" integer COMMENT '类型（1-组长；2-成员；）';

CREATE TABLE `post_assessment_rating` (
	`id` TINYINT NOT NULL COMMENT '主键',
  `type` INT NOT NULL COMMENT '类型：1-职能；2-生产；',
  `department_id` VARCHAR(32) NOT NULL COMMENT '部门ID',
  `position_name` VARCHAR(64) NOT NULL COMMENT '岗位名称',
  `principal_id` VARCHAR(32) NOT NULL COMMENT '负责人ID',
  `integrity_issues_total` INT NOT NULL DEFAULT 0 COMMENT '完整性问题数量-总数',
  `integrity_issues_resolved` INT NOT NULL DEFAULT 0 COMMENT '完整性问题数量-已整改',
  `effectiveness_issues_total` INT NOT NULL DEFAULT 0 COMMENT '有效性问题数量-总数',
  `effectiveness_issues_resolved` INT NOT NULL DEFAULT 0 COMMENT '有效性问题数量-已整改',
  `suitability_issues_total` INT NOT NULL DEFAULT 0 COMMENT '适宜性问题数量-总数',
  `suitability_issues_resolved` INT NOT NULL DEFAULT 0 COMMENT '适宜性问题数量-已整改',
  `peer_evaluation_score` DECIMAL(5,2) NOT NULL DEFAULT 0.00 COMMENT '互评得分',
  `daily_score` DECIMAL(5,2) NOT NULL DEFAULT 0.00 COMMENT '日常得分',
  `department_score` DECIMAL(5,2) NOT NULL DEFAULT 0.00 COMMENT '部门得分',
  `position_score` DECIMAL(5,2) NOT NULL DEFAULT 0.00 COMMENT '岗位得分',
  `rating_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '评分时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `del_flag` INT NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `create_by` varchar(64) NOT NULL COMMENT '创建者',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `update_by` varchar(64) NOT NULL COMMENT '更新者',
  PRIMARY KEY (`id`)
) COMMENT='考核评比表';
ALTER TABLE "public"."post_assessment_rating" RENAME COLUMN "department_id" TO dept_id;
ALTER TABLE "public"."post_assessment_rating" MODIFY COLUMN "dept_id" bigint;
ALTER TABLE "public"."post_assessment_rating" RENAME COLUMN "position_name" TO post_id;
ALTER TABLE "public"."post_assessment_rating" MODIFY COLUMN "post_id" bigint;
ALTER TABLE "public"."post_assessment_rating" RENAME COLUMN "principal_id" TO head_user_id;
ALTER TABLE "public"."post_assessment_rating" MODIFY COLUMN "head_user_id" bigint;
ALTER TABLE "public"."post_team_user" MODIFY COLUMN "post_team_id" bigint;
ALTER TABLE "public"."post_team_dept" COMMENT '(废弃)岗检工作组关联部门';
ALTER TABLE "public"."post_team" ADD COLUMN team_type integer NOT NULL DEFAULT 2 COMMENT 'type=3时，工作小组权限（1-牵头；2-成员）';
ALTER TABLE "public"."post_plan" RENAME COLUMN "check_workgroup_id" TO check_group_id;
ALTER TABLE "public"."post_plan" RENAME COLUMN "check_group_id" TO check_team_id;
ALTER TABLE "public"."post_plan_info" ADD COLUMN status integer COMMENT '岗检状态：1-未检；2-已检；';


ALTER TABLE "public"."post_plan_info" ADD COLUMN print_user_id bigint COMMENT '打印人ID';
ALTER TABLE "public"."post_plan_info" ADD COLUMN print_time DATETIME COMMENT '打印时间';
ALTER TABLE "public"."post_plan_info" ADD COLUMN checked_img varchar COMMENT '上传：检查后的检查表照片或PDF，磁盘相对路径';
ALTER TABLE "public"."post_plan_info" ADD COLUMN checked_user_id bigint COMMENT '上传：检查人ID';
ALTER TABLE "public"."post_plan_info" ADD COLUMN checked_time DATETIME COMMENT '上传：检查时间';



ALTER TABLE "public"."post_checked_problem" ADD COLUMN duty_type integer COMMENT '职责类别：1-业务职责；2-党建及党风廉政；3-安全环保职责；4-合规保密职；';
ALTER TABLE "public"."post_checked_problem_record" DROP COLUMN "create_user_id";

ALTER TABLE "public"."post_checked_problem_record" DROP COLUMN "check_time";

ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "problem_level" integer;

ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "problem_attribute" integer;

ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "problem_category" integer;

ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "is_immediately_corrected" integer NULL;

ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "checked_dept_id" bigint NULL;

ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "checked_post_id" bigint NULL;

ALTER TABLE "public"."post_checked_problem_record" DROP COLUMN "remark";

ALTER TABLE "public"."post_checked_problem_record" DROP COLUMN "del_flag";

ALTER TABLE "public"."post_checked_problem_record" DROP COLUMN "create_by";

ALTER TABLE "public"."post_checked_problem_record" DROP COLUMN "update_time";

ALTER TABLE "public"."post_checked_problem_record" DROP COLUMN "update_by";



ALTER TABLE "public"."post_list" RENAME COLUMN "position_name" TO post_id;

ALTER TABLE "public"."post_list" MODIFY COLUMN "post_id" bigint;

ALTER TABLE "public"."post_list" MODIFY COLUMN "post_id" bigint COMMENT '岗位名称：岗位ID';

ALTER TABLE "public"."post_list" RENAME COLUMN "department_name" TO dept_id;

ALTER TABLE "public"."post_list" MODIFY COLUMN "dept_id" bigint;

ALTER TABLE "public"."post_list" MODIFY COLUMN "dept_id" bigint COMMENT '所在部门：部门ID'; deptId

ALTER TABLE "public"."post_highlights" MODIFY COLUMN "highlights_type" integer COMMENT '职责类别：1-业务职责；2-党建及党风廉政；3-安全环保职责；4-合规保密职；5-其他；';


ALTER TABLE "public"."post_checked_report" ADD COLUMN html_one TEXT COMMENT '1、（一）组织情况';
ALTER TABLE "public"."post_checked_report" ADD COLUMN html_two TEXT COMMENT '2、（二）岗检的时间、范围和开展形式';
ALTER TABLE "public"."post_checked_report" ADD COLUMN html_three TEXT COMMENT '3、（三）岗检发现的主要问题';
ALTER TABLE "public"."post_checked_report" ADD COLUMN html_four TEXT COMMENT '4、（四）原因分析';
ALTER TABLE "public"."post_checked_report" ADD COLUMN html_five TEXT COMMENT '5、（五）取得成绩';
ALTER TABLE "public"."post_checked_report" ADD COLUMN html_six TEXT COMMENT '6、（一）“立行立改”问题整改情况';
ALTER TABLE "public"."post_checked_report" ADD COLUMN html_seven TEXT COMMENT '7、（二）“非立行立改”问题整改情况';
ALTER TABLE "public"."post_checked_report" ADD COLUMN html_eight TEXT COMMENT '8、三、下一步岗位责任提升计划';
ALTER TABLE "public"."post_checked_report" ADD COLUMN html_nine TEXT COMMENT '9、四、总结结论';

ALTER TABLE "public"."post_checked_report" ADD COLUMN status integer NOT NULL COMMENT '状态：1-待审核；3-通过；4-驳回；';
ALTER TABLE "public"."post_checked_report" ADD COLUMN status_by_user_id integer COMMENT '审核人ID';
ALTER TABLE "public"."post_checked_report" ADD COLUMN status_by_user_name integer COMMENT '审核人姓名';
ALTER TABLE "public"."post_checked_report" ADD COLUMN status_reason integer COMMENT '审核不通过原因';

ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "consummation_problem" integer COMMENT '废弃：完善性问题';
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "suitability_problem" integer COMMENT '废弃：适宜性问题';
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "effectiveness_problem" integer COMMENT '废弃：有效性问题';
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "li_xing_li_gai_question_number" integer COMMENT '废弃：立行立改问题数量';
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "li_xing_li_gai_question_has_rectified_number" integer COMMENT '废弃：立行立改问题已整改数量';
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "rich_text" TEXT COMMENT '废弃：富文本';
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "status_by_user_id" bigint;
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "status_by_user_name" varchar(64);
ALTER TABLE "public"."post_checked_report" MODIFY COLUMN "status_reason" varchar(255);


CREATE TABLE post_assessment_rules (
	`id` bigint NOT NULL COMMENT '主键',
    type VARCHAR(255) COMMENT '评分分类/项目/专业：1-岗检考核规则；2-职能部门互评表；；3-生产部门日常得分；',
    full_score INT COMMENT '满分/权重',
    rule VARCHAR(500) COMMENT '考核规则/评分标准',
    problem_level_one int COMMENT 'type=1-岗检考核规则：一般',
    problem_level_two int COMMENT 'type=1-岗检考核规则：重要',
    status int COMMENT '状态：1-待审核；3-通过；4-驳回；',
    status_by_user_id INT COMMENT '审核人ID',
    status_by_user_name VARCHAR(255) COMMENT '审核人姓名' ,
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `del_flag` INT NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_time` datetime NOT NULL COMMENT '创建时间/提交时间',
  `create_by` varchar(64) NOT NULL COMMENT '创建者',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `update_by` varchar(64) NOT NULL COMMENT '更新者',
  PRIMARY KEY (`id`)
) COMMENT='考核规则表';

ALTER TABLE "public"."post_assessment_rules" MODIFY COLUMN "type" integer;

ALTER TABLE "public"."post_assessment_rules" MODIFY COLUMN "problem_level_one" decimal(
    5,
    2
);

ALTER TABLE "public"."post_assessment_rules" MODIFY COLUMN "problem_level_one" decimal COMMENT 'type=1-岗检考核规则：一般分数';

ALTER TABLE "public"."post_assessment_rules" MODIFY COLUMN "problem_level_two" decimal(
    5,
    2
);

ALTER TABLE "public"."post_assessment_rules" MODIFY COLUMN "problem_level_two" decimal COMMENT 'type=1-岗检考核规则：重要分数';

ALTER TABLE "public"."post_assessment_rules" MODIFY COLUMN "status_by_user_id" bigint;

ALTER TABLE "public"."post_assessment_rating_other" MODIFY COLUMN "id" bigint NOT NULL;

ALTER TABLE "public"."post_assessment_rating_other" MODIFY COLUMN "type" integer NOT NULL;

ALTER TABLE "public"."post_assessment_rating_other" MODIFY COLUMN "batch_id" varchar NOT NULL;

ALTER TABLE "public"."post_assessment_rating_other" MODIFY COLUMN "start_time" DATETIME NOT NULL;

ALTER TABLE "public"."post_assessment_rating_other" MODIFY COLUMN "status" integer NOT NULL;

ALTER TABLE "public"."post_assessment_rating_other" MODIFY COLUMN "dept_id" bigint NOT NULL;

ALTER TABLE "public"."post_assessment_rating_other" MODIFY COLUMN "create_user_id" DATETIME NOT NULL;

ALTER TABLE "public"."post_assessment_rating_other" MODIFY COLUMN "del_flag" DATETIME NOT NULL;

ALTER TABLE "public"."post_assessment_rating_other" MODIFY COLUMN "create_time" DATETIME NOT NULL;

ALTER TABLE "public"."post_assessment_rating_other" MODIFY COLUMN "create_by" DATETIME NOT NULL;

ALTER TABLE "public"."post_assessment_rating_other" MODIFY COLUMN "update_time" DATETIME NOT NULL;

ALTER TABLE "public"."post_assessment_rating_other" MODIFY COLUMN "update_by" DATETIME NOT NULL;

CREATE UNIQUE INDEX post_assessment_rating_other_pkey ON
"public"."post_assessment_rating_other"
    USING BTREE (id) TABLESPACE "sys_default";


CREATE TABLE "public"."post_assessment_rating_other" (
	"id" bigint NOT NULL,
	"type" integer NOT NULL,
	"batch_id" varchar NOT NULL,
	"start_time" datetime NOT NULL,
	"status" integer NOT NULL,
	"dept_id" bigint NOT NULL,
	"complete_time" datetime NULL,
	"score_user_id" bigint NULL,
	"score_user_name" varchar NULL,
	"create_user_id" bigint NOT NULL,
	"remark" character varying(255 char) NULL,
	"del_flag" integer NOT NULL,
	"create_time" datetime NOT NULL,
	"create_by" character varying(64 char) NOT NULL,
	"update_time" datetime NOT NULL,
	"update_by" character varying(64 char) NOT NULL
);
CREATE UNIQUE INDEX post_assessment_rating_other_pkey ON public.post_assessment_rating_other USING btree (id);
ALTER TABLE "public"."post_assessment_rating_other" COMMENT '打分表(职能互评生产日常)';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY "id" COMMENT '主键';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY "type" COMMENT '类型：1-职能互评；2-生产日常；';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY "batch_id" COMMENT '批次号（管理员创建的）';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY "start_time" COMMENT '评分开始时间（管理员创建的）';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY "status" COMMENT '状态：1-进行中；2-已完成';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY "dept_id" COMMENT '评分部门ID：打分部门，自己给其他12个部门打分；';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY "complete_time" COMMENT '评分完成时间';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY "score_user_id" COMMENT '评分人ID';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY "score_user_name" COMMENT '评分人姓名';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY "create_user_id" COMMENT '创建者用户ID';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY "remark" COMMENT '备注';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY "del_flag" COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY "create_time" COMMENT '创建时间/提交时间';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY "create_by" COMMENT '创建者';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY "update_time" COMMENT '更新时间';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY "update_by" COMMENT '更新者';

CREATE TABLE "public"."post_assessment_rating_other_info" (
	"id" bigint NOT NULL,
	"rating_other_id" bigint NOT NULL,
	"duty_type" integer NOT NULL,
	"score_weight" numeric(10,0) NOT NULL,
	"rule" character varying(512 char) NULL,
	"by_dept_id" bigint NOT NULL,
	"by_dept_score" numeric(5,2) NULL,
	"improvement_suggestions" character varying(512 char) NULL,
	"create_user_id" bigint NULL,
	"remark" character varying(255 char) NULL,
	"del_flag" integer NULL,
	"create_time" datetime NULL,
	"create_by" character varying(64 char) NULL,
	"update_time" datetime NULL,
	"update_by" character varying(64 char) NULL
);
CREATE UNIQUE INDEX post_assessment_rating_other_info_pkey ON public.post_assessment_rating_other_info USING btree (id);
ALTER TABLE "public"."post_assessment_rating_other_info" COMMENT '打分表明细(职能互评生产日常)';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY "id" COMMENT '主键';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY "rating_other_id" COMMENT '打分表ID';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY "duty_type" COMMENT '评分分类/项目/专业：职责类别：1-业务职责；2-党建及党风廉政；3-安全环保职责；4-合规与保密职责；5-任职资格与能力素质要求；6-岗位责任制文件完整性与适宜性；10-工作态度；11-部门协作；12-廉洁从业；13-主要工作完成情况；20-HSE；21-生产；22-设备；';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY "score_weight" COMMENT '分值/权重；（当前考核规则的分和权重镜像到这里）';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY "rule" COMMENT '考核规则/评分标准（岗检和职能部门时有值）';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY "by_dept_id" COMMENT '被评分部门ID';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY "by_dept_score" COMMENT '被评分部门得分';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY "improvement_suggestions" COMMENT '改进建议';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY "create_user_id" COMMENT '创建者用户ID';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY "remark" COMMENT '备注';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY "del_flag" COMMENT '删除标志（0代表存在 2代表删除）';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY "create_time" COMMENT '创建时间/提交时间';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY "create_by" COMMENT '创建者';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY "update_time" COMMENT '更新时间';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY "update_by" COMMENT '更新者';


添加通用字段
    ALTER TABLE "public"."post_assessment_rating_other" ADD COLUMN create_user_id bigint NULL COMMENT '创建者用户ID';
    ALTER TABLE "public"."post_assessment_rating_other" ADD COLUMN remark varying(255 char) NULL COMMENT '备注';
    ALTER TABLE "public"."post_assessment_rating_other" ADD COLUMN del_flag integer NULL COMMENT '删除标志（0代表存在 2代表删除）';
    ALTER TABLE "public"."post_assessment_rating_other" ADD COLUMN create_time DATETIME NULL COMMENT '创建时间/提交时间';
    ALTER TABLE "public"."post_assessment_rating_other" ADD COLUMN create_by varying(64 char) NULL COMMENT '创建者';
    ALTER TABLE "public"."post_assessment_rating_other" ADD COLUMN update_time DATETIME NULL COMMENT '更新时间';
    ALTER TABLE "public"."post_assessment_rating_other" ADD COLUMN update_by varying(64 char) NULL COMMENT '更新者';



ALTER TABLE "public"."post_checked" RENAME COLUMN "checked_user_id" TO checked_user_name;
ALTER TABLE "public"."post_checked" MODIFY COLUMN "checked_user_name" varchar(64);
ALTER TABLE "public"."post_checked" MODIFY COLUMN "checked_user_name" varchar COMMENT '检查人中文姓名（上传页面设置的值）';
ALTER TABLE "public"."post_checked" MODIFY COLUMN "checked_time" timestamp WITH time ZONE COMMENT '检查时间（上传页面设置的值）';
ALTER TABLE "public"."post_checked" MODIFY COLUMN "upload_user_id" bigint COMMENT '检查表上传人ID';
ALTER TABLE "public"."post_checked" MODIFY COLUMN "upload_time" timestamp WITH time ZONE COMMENT '检查表上传时间';

ALTER TABLE "public"."post_checked_items" MODIFY COLUMN "type" integer COMMENT '检查项目：参考post_list_info表；类型（1-业务职责；2-党建及党风廉政建设职责；3-安全环保职责；4-合规保密职；5-任职资格与能力素质要求）';
ALTER TABLE "public"."post_checked_items" ADD COLUMN post_checked_content varchar(1000) COMMENT '检查内容';
ALTER TABLE "public"."post_checked_items" ADD COLUMN post_checked_standard varchar(1000) COMMENT '检查标准';
ALTER TABLE "public"."post_checked_items" ADD COLUMN post_checked_method varchar(1000) COMMENT '检查方法';
ALTER TABLE "public"."post_checked_items" ADD COLUMN post_checked_result varchar(1000) COMMENT '检查结果';


更新用户表雪花ID-用户ID
UPDATE "public"."sys_users" SET user_id = substr(user_id, 5)  WHERE length(user_id) > 16

更新用户表雪花ID-部门ID
UPDATE "public"."sys_users" SET dept_id = substr(dept_id, 5)  WHERE length(dept_id) > 16


2024年2月27日  数据库更新记录：惠州石化内网数据库未更新
上传模板文件到服务器上
    C:\gnhz\uploadPath\template
创建文件夹：exportFiles
    C:\gnhz\uploadPath\exportFiles

ALTER TABLE "public"."post_checked" ADD COLUMN checked_type integer DEFAULT 1 COMMENT '检查类型：1-全要素；2-自定义';

ALTER TABLE "public"."post_list" ADD COLUMN post_list_name varchar(128) COMMENT '岗位责任制清单名称';

ALTER TABLE "public"."post_list_info" ADD COLUMN post_checked_method varchar(1000) COMMENT '检查方法';

ALTER TABLE "public"."post_list" ADD COLUMN version_no varchar(32) COMMENT '版本号：例如 2024-1、2024-2';

ALTER TABLE "public"."post_checked" ADD COLUMN version_no varchar(32) COMMENT '版本号：例如 2024-1、2024-2';

ALTER TABLE "public"."post_list_info" ADD COLUMN serial_number integer COMMENT '检查表第一列：序号';

ALTER TABLE "public"."post_checked_items" ADD COLUMN serial_number integer COMMENT '检查表第一列：序号';

岗检方案备注修改
ALTER TABLE "public"."post_programme" MODIFY COLUMN "status_hr" integer COMMENT '2-人力资源审批-状态：1-待审核；3-通过；4-驳回；';
ALTER TABLE "public"."post_programme" MODIFY COLUMN "date_hr" timestamp WITH time ZONE COMMENT '2-人力资源审批-通过日期';
ALTER TABLE "public"."post_programme" MODIFY COLUMN "reason_hr" varchar COMMENT '2-人力资源审批-未通过理由';
ALTER TABLE "public"."post_programme" MODIFY COLUMN "status_icfa" integer COMMENT '1-内控法务部审批-状态：1-待审核；3-通过；4-驳回；';
ALTER TABLE "public"."post_programme" MODIFY COLUMN "date_icfa" timestamp WITH time ZONE COMMENT '1-内控法务部审批-通过日期';
ALTER TABLE "public"."post_programme" MODIFY COLUMN "reason_icfa" varchar COMMENT '1-内控法务部审批-未通过理由';


ALTER TABLE "public"."sys_post" MODIFY COLUMN "status" CHARACTER DEFAULT 0;
ALTER TABLE "public"."sys_post" MODIFY COLUMN "post_name" CHARACTER VARYING(255 char);

考核规则设置保留2位小数
ALTER TABLE "public"."post_assessment_rules" MODIFY COLUMN "problem_level_one" NUMERIC(10,2);
ALTER TABLE "public"."post_assessment_rules" MODIFY COLUMN "problem_level_two" NUMERIC(10,2);
修改打分表分值/权重精度
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY COLUMN "score_weight" integer;
修改备注
ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "checked_dept_id" bigint COMMENT '受检部门ID';
ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "checked_post_id" bigint COMMENT '受检岗位ID';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY COLUMN "score_weight" NUMERIC COMMENT '满分分值/权重；（当前考核规则的满分分值/权重镜像到这里）';
ALTER TABLE "public"."sys_users" MODIFY COLUMN "cas_user_pback" CHARACTER VARYING COMMENT 'CASP';
ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "problem_no" CHARACTER VARYING COMMENT '问题编号GJ-MF5-2023-Z-000001';


版本控制
ALTER TABLE "public"."post_assessment_rating_other" ADD COLUMN dept_name integer COMMENT 'Version-评分部门名称';
ALTER TABLE "public"."post_assessment_rating_other" MODIFY COLUMN "dept_name" varchar(64);
ALTER TABLE "public"."post_assessment_rating_other_info" ADD COLUMN by_dept_name integer NOT NULL COMMENT 'Version-被评分部门名称';
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY COLUMN "by_dept_name" varchar(64);
ALTER TABLE "public"."post_team_dept" ADD COLUMN dept_name varchar(64) COMMENT 'Version-部门名称';
ALTER TABLE "public"."post_team_user" ADD COLUMN nick_name varchar(128) COMMENT 'Version-人员姓名';
ALTER TABLE "public"."post_team_user" ADD COLUMN dept_name varchar(64) COMMENT 'Version-部门名称';
ALTER TABLE "public"."post_plan_info" ADD COLUMN checked_dept_name varchar(128) COMMENT 'Version-受检部门名称';
ALTER TABLE "public"."post_plan_info" ADD COLUMN checked_post_name varchar(255) COMMENT 'Version-受检岗位名称';
ALTER TABLE "public"."post_plan_check_user" ADD COLUMN checked_user_name varchar(32) COMMENT 'Version-检查人员姓名';
ALTER TABLE "public"."post_plan_info" ADD COLUMN checked_dept_type integer COMMENT 'Version-部门类型：1-职能；2-生产';
ALTER TABLE "public"."post_list" MODIFY COLUMN "post_id" bigint COMMENT '岗位ID';
ALTER TABLE "public"."post_list" MODIFY COLUMN "dept_id" bigint COMMENT '部门ID';
ALTER TABLE "public"."post_list" ADD COLUMN dept_name varchar(64) COMMENT 'Version-部门名称';
ALTER TABLE "public"."post_list" ADD COLUMN post_name varchar(255) COMMENT 'Version-岗位名称';
ALTER TABLE "public"."post_plan_info" ADD COLUMN checked_post_user_count integer COMMENT 'Version-岗位下人员数量';

ALTER TABLE "public"."post_checked" MODIFY COLUMN "checked_dept_id" bigint COMMENT '受检部门ID';
ALTER TABLE "public"."post_checked" MODIFY COLUMN "checked_post_id" bigint COMMENT '受检岗位ID';
ALTER TABLE "public"."post_checked" ADD COLUMN checked_dept_name varchar(64) COMMENT 'Version-受检部门名称';
ALTER TABLE "public"."post_checked" ADD COLUMN checked_post_name varchar(255) COMMENT 'Version-受检岗位名称';
ALTER TABLE "public"."post_checked" ADD COLUMN checked_dept_type integer COMMENT 'Version-部门类型：1-职能；2-生产';

ALTER TABLE "public"."post_checked_problem" ADD COLUMN checked_dept_name varchar(64) COMMENT 'Version-受检部门名称';
ALTER TABLE "public"."post_checked_problem" ADD COLUMN checked_post_name varchar(255) COMMENT 'Version-受检岗位名称';
ALTER TABLE "public"."post_checked_problem" ADD COLUMN rectification_responsible_name varchar(64) COMMENT 'Version-整改责任人姓名';
ALTER TABLE "public"."post_checked_problem" ADD COLUMN dept_approve_user_name varchar(64) COMMENT 'Version-部门经理审核人姓名';
ALTER TABLE "public"."post_checked_problem" ADD COLUMN speciality_department_reviewer_name varchar(64) COMMENT 'Version-专业审核人姓名';
ALTER TABLE "public"."post_checked_problem" ADD COLUMN review_department_reviewer_name integer COMMENT 'Version-复查部门审核人姓名';
ALTER TABLE "public"."post_checked_problem" ADD COLUMN checked_dept_type integer COMMENT 'Version-部门类型：1-职能；2-生产';
ALTER TABLE "public"."post_checked_problem" MODIFY COLUMN "review_department_reviewer_name" varchar(64);






ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY COLUMN "by_dept_score" NUMERIC NOT NULL;
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY COLUMN "by_dept_score" NUMERIC(10,2);
ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY COLUMN "by_dept_score" NUMERIC DEFAULT 0.00;
-- ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY COLUMN "by_dept_score" integer;
-- ALTER TABLE "public"."post_assessment_rating_other_info" MODIFY COLUMN "by_dept_score" integer DEFAULT 0;

ALTER TABLE "public"."sys_dept" ADD COLUMN dept_code_post varchar(64) COMMENT '岗检系统部门代码：岗检问题编号时需要使用他';

2024年4月9日10:52:27
ALTER TABLE "public"."sys_post" MODIFY COLUMN "post_level" integer COMMENT '级别：0-员工；1-经理；2-领导；';