blob: 215bba5b6a76470b7e77c062e3f2f85eb964e293 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
CREATE TABLE "pq_criterias_extension" (
"id" serial PRIMARY KEY NOT NULL,
"pq_criteria_id" integer NOT NULL,
"project_id" integer NOT NULL,
"contract_info" text,
"additional_requirement" text,
"created_at" timestamp DEFAULT now() NOT NULL,
"updated_at" timestamp DEFAULT now() NOT NULL
);
--> statement-breakpoint
ALTER TABLE "pq_criterias_extension" ADD CONSTRAINT "pq_criterias_extension_pq_criteria_id_pq_criterias_id_fk" FOREIGN KEY ("pq_criteria_id") REFERENCES "public"."pq_criterias"("id") ON DELETE cascade ON UPDATE cascade;--> statement-breakpoint
ALTER TABLE "pq_criterias_extension" ADD CONSTRAINT "pq_criterias_extension_project_id_projects_id_fk" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE cascade ON UPDATE cascade;
|
