JX-BPOS/db/migrations/0011_little_pet_avengers.sql

CREATE TABLE "sys"."work_group" (
	"id" text PRIMARY KEY NOT NULL,
	"name" text NOT NULL,
	"owner_id" text NOT NULL,
	"members" jsonb DEFAULT '{}'::jsonb NOT NULL,
	"created_at" timestamp with time zone DEFAULT now() NOT NULL
);
--> statement-breakpoint
ALTER TABLE "sys"."workflow" ADD COLUMN "work_group" jsonb;--> statement-breakpoint
ALTER TABLE "sys"."work_group" ADD CONSTRAINT "work_group_owner_id_staff_id_fk" FOREIGN KEY ("owner_id") REFERENCES "sys"."staff"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
CREATE INDEX "work_group_owner_idx" ON "sys"."work_group" USING btree ("owner_id");