Table : dealBrokerJournalFlowStepProgress

If a post exists that connects a deal with a flowStep, that flowStep is considered done in broker journal

Raw table description

Fields

id id

{
  "name": "id",
  "type": "primaryKey"
}

flowStepId M  → flowSteps

{
  "name": "flowStepId",
  "type": "foreignKey",
  "table": "flowSteps",
  "schema": "mspx_admin",
  "mandatory": "true"
}

dealId M  → deals

{
  "name": "dealId",
  "type": "foreignKey",
  "table": "deals",
  "mandatory": "true"
}

updatedDate 

{
  "name": "updatedDate",
  "type": "updated"
}

Unique Fields

 The fields flowStepId and dealId together.