Table : brokerJournalEntries

Raw table description

Fields

id id

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

dealId M  → deals

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

createdDate

{
  "name": "createdDate",
  "type": "timestamp"
}

eventDate D

{
  "name": "eventDate",
  "type": "datetime",
  "default": "CURRENT_TIMESTAMP",
  "mandatory": "true"
}

userAccountId  → userAccounts

{
  "name": "userAccountId",
  "type": "foreignKey",
  "table": "userAccounts",
  "schema": "mspx_admin"
}

description

{
  "name": "description",
  "type": "text"
}

isHidden bit

{
  "name": "isHidden",
  "type": "bit"
}

isDone bit

{
  "name": "isDone",
  "type": "bit"
}

brokerJournalEventTypeId M  → brokerJournalEventTypes

{
  "name": "brokerJournalEventTypeId",
  "type": "foreignKey",
  "table": "brokerJournalEventTypes",
  "mandatory": "true",
  "schema": "mspx_admin"
}

updatedDate

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

Referenced by

brokerJournalEntryComments as brokerJournalEntryId (connection table to comments via commentId)
filesInBrokerJournalEntry as brokerJournalEntryId (connection table to files via fileId)