Table : communicateContacts

Raw table description

Fields

id id

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

communicateState M E

{
  "name": "communicateState",
  "type": "enum",
  "enums": [
    "ENUM_COMMUNICATE_CONTACT_STATE_SELECTED",
    "ENUM_COMMUNICATE_CONTACT_STATE_NO_CHANNEL",
    "ENUM_COMMUNICATE_CONTACT_STATE_DISPATCHED",
    "ENUM_COMMUNICATE_CONTACT_STATE_DISPATCH_CONFIRMED",
    "ENUM_COMMUNICATE_CONTACT_STATE_FAILED"
  ],
  "mandatory": "true"
}

communicateChannel E

{
  "name": "communicateChannel",
  "type": "enum",
  "enums": [
    "ENUM_COMMUNICATION_CHANNEL_EMAIL",
    "ENUM_COMMUNICATION_CHANNEL_SMS",
    "ENUM_COMMUNICATION_CHANNEL_LETTER",
    "ENUM_COMMUNICATION_CHANNEL_NONE"
  ]
}

messageExternalIdentifier

{
  "name": "messageExternalIdentifier",
  "type": "text",
  "maxLength": 100
}

communicateSessionId M  → communicateSessions

{
  "name": "communicateSessionId",
  "type": "foreignKey",
  "table": "communicateSessions",
  "mandatory": "true"
}

contactId M  → contacts

{
  "name": "contactId",
  "type": "foreignKey",
  "table": "contacts",
  "mandatory": "true"
}

updatedDate

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