123456789101112131415161718192021222324 |
- -- public.task_deliverables definition
- -- Drop table
- -- DROP TABLE public.task_deliverables;
- CREATE TABLE public.task_deliverables (
- id int8 NOT NULL,
- task_id int8 NOT NULL,
- member_id int8 NULL,
- title varchar NOT NULL,
- template_id int8 NULL,
- file_id int8 NULL,
- create_user_id int8 NOT NULL,
- create_time timestamp NOT NULL,
- update_user_id int8 NULL,
- update_time timestamp NULL,
- status int4 NOT NULL DEFAULT 1,
- reference_id int8 NULL,
- CONSTRAINT task_deliverables_pk PRIMARY KEY (id)
- );
- 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
- (-9110303016380514202,-479825051726099236,NULL,'交付物2',222,NULL,6514257066533602256,'2023-09-11 17:10:52.798',6514257066533602256,'2023-09-11 17:17:50.413',0,NULL);
|