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-领导；';