Skip to content

Open-source manufacturing ERP, MES and QMS. Quoting, MRP, inventory, shop floor, quality and lot/serial traceability on one Postgres schema, with a REST API and MCP server. Self-host or use Carbon Cloud.

531 B
Raw Blame
DROP VIEW IF EXISTS "integrations";

ALTER TABLE "integration" 
  DROP COLUMN "title",
  DROP COLUMN "description",
  DROP COLUMN "logoPath",
  DROP COLUMN "visible";


CREATE OR REPLACE VIEW "integrations" WITH(SECURITY_INVOKER=true) AS
  SELECT 
    i.*, 
    c.id AS "companyId",
    coalesce(ci.metadata, '{}') AS "metadata",
    coalesce(ci."active", FALSE) AS "active"
  FROM "integration" i 
  CROSS JOIN "company" c 
  LEFT JOIN (
    SELECT * FROM "companyIntegration"
  ) ci
    ON i.id = ci.id AND c.id = ci."companyId";