Table : comments

Raw table description

Fields

id id

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

subject

{
  "name": "subject",
  "type": "text",
  "maxLength": 200
}

comment M

{
  "name": "comment",
  "type": "text",
  "mandatory": "true"
}

createdDate

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

commentDate D

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

createdByUserId  → userAccounts

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

isRead bit

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

updatedDate

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

Referenced by

brokerJournalEntryComments as commentId (connection table to brokerJournalEntries via brokerJournalEntryId)
contactComments as commentId (connection table to contacts via contactId)
dealComments as commentId (connection table to deals via dealId)