tip-cq-kaizhou/02-script/sql/v1.2_createTaskDeliverables.sql

-- 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);