CREATE OR REPLACE VIEW "pmtriskview"
AS SELECT
  "r"."id",
  "r"."projectid" "projectId",
  "r"."name",
  "r"."description",
  "r"."mitigationplan" "mitigationPlan",
  "r"."contingencyplan" "contingencyPlan",
  "r"."category",
  "r"."source",
  "r"."updateddate" "updatedDate",
  "r"."updatedby" "updatedBy",
  "r"."identifiedby" "identifiedBy",
  "r"."identifieddate" "identifiedDate",
  "r"."isactive" "isActive",
  "r"."type",
  "r"."probability",
  "r"."impact",
  "r"."impactcost" "impactCost",
  "r"."descriptionofimpact" "descriptionOfImpact",
  ("r"."probability"*"r"."impact") AS "factor"
FROM
  "pmtprojectrisk" "r"
LEFT JOIN "pmtproject" ON "r"."projectid" = "pmtproject"."id"