Postgresql – How to create a table that should only allow a single relation to exist out of many?
I have a table called Configuration: CREATE TABLE "Configuration" ( "id" CHAR(36) NOT NULL, "namespace" VARCHAR(255) NOT NULL, "key" VARCHAR(255) NOT NULL, "value" JSONB NOT NULL, "level" "ConfigLevel" NOT NULL, "userId" CHAR(36), "orgId" CHAR(36), "teamId" CHAR(36), "moduleId" CHAR(36), "moduleSubscriptionId" CHAR(36),…