v1.4_createTaskProcessSummaryTemp.sql 930 B

12345678910111213141516171819
  1. -- ----------------------------
  2. -- Table structure for task_process_summary_temp
  3. -- ----------------------------
  4. DROP TABLE IF EXISTS "public"."task_process_summary_temp";
  5. CREATE TABLE "public"."task_process_summary_temp"(
  6. "id" int8 NOT NULL,
  7. "task_id" int8,
  8. "person_id" int8,
  9. "data" text COLLATE "pg_catalog"."default"
  10. );
  11. COMMENT ON COLUMN "public"."task_process_summary_temp"."id" IS '批示留言暂存信息';
  12. COMMENT ON COLUMN "public"."task_process_summary_temp"."task_id" IS '任务id';
  13. COMMENT ON COLUMN "public"."task_process_summary_temp"."person_id" IS '人员id';
  14. COMMENT ON COLUMN "public"."task_process_summary_temp"."data" IS '暂存数据';
  15. -- ----------------------------
  16. -- Primary Key structure for table task_process_summary_temp
  17. -- ----------------------------
  18. ALTER TABLE "public"."task_process_summary_temp" ADD CONSTRAINT "task_process_summary_temp_pkey" PRIMARY KEY ("id");