Skip to content

⭐️⭐️⭐️ Open-source, self-hosted alternative to Linear and Plane. Project management and issue tracking where teams and AI agents work side by side to plan and ship products.

707 B
Raw Blame
CREATE TABLE "project_view_preference" (
	"view_id" integer NOT NULL,
	"user_id" text NOT NULL,
	"position" integer,
	"is_hidden" boolean DEFAULT false NOT NULL,
	CONSTRAINT "project_view_preference_view_id_user_id_pk" PRIMARY KEY("view_id","user_id")
);
--> statement-breakpoint
ALTER TABLE "project_view_preference" ADD CONSTRAINT "project_view_preference_view_id_project_view_id_fk" FOREIGN KEY ("view_id") REFERENCES "public"."project_view"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
ALTER TABLE "project_view_preference" ADD CONSTRAINT "project_view_preference_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;