tip-cq-kaizhou/02-script/sql/v1.4_createTaskProcessSummaryTemp.sql

-- ----------------------------
-- Table structure for task_process_summary_temp
-- ----------------------------
DROP TABLE IF EXISTS "public"."task_process_summary_temp";
CREATE TABLE "public"."task_process_summary_temp"(
    "id"        int8 NOT NULL,
    "task_id"   int8,
    "person_id" int8,
    "data"      text COLLATE "pg_catalog"."default"
);
COMMENT ON COLUMN "public"."task_process_summary_temp"."id" IS '批示留言暂存信息';
COMMENT ON COLUMN "public"."task_process_summary_temp"."task_id" IS '任务id';
COMMENT ON COLUMN "public"."task_process_summary_temp"."person_id" IS '人员id';
COMMENT ON COLUMN "public"."task_process_summary_temp"."data" IS '暂存数据';

-- ----------------------------
-- Primary Key structure for table task_process_summary_temp
-- ----------------------------
ALTER TABLE "public"."task_process_summary_temp" ADD CONSTRAINT "task_process_summary_temp_pkey" PRIMARY KEY ("id");