v1.2_createTaskDeliverables.sql 840 B

123456789101112131415161718192021222324
  1. -- public.task_deliverables definition
  2. -- Drop table
  3. -- DROP TABLE public.task_deliverables;
  4. CREATE TABLE public.task_deliverables (
  5. id int8 NOT NULL,
  6. task_id int8 NOT NULL,
  7. member_id int8 NULL,
  8. title varchar NOT NULL,
  9. template_id int8 NULL,
  10. file_id int8 NULL,
  11. create_user_id int8 NOT NULL,
  12. create_time timestamp NOT NULL,
  13. update_user_id int8 NULL,
  14. update_time timestamp NULL,
  15. status int4 NOT NULL DEFAULT 1,
  16. reference_id int8 NULL,
  17. CONSTRAINT task_deliverables_pk PRIMARY KEY (id)
  18. );
  19. INSERT INTO public.task_deliverables (id,task_id,member_id,title,template_id,file_id,create_user_id,create_time,update_user_id,update_time,status,reference_id) VALUES
  20. (-9110303016380514202,-479825051726099236,NULL,'交付物2',222,NULL,6514257066533602256,'2023-09-11 17:10:52.798',6514257066533602256,'2023-09-11 17:17:50.413',0,NULL);