Table : communicateSessions

Raw table description

Fields

id id

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

sessionState M E

{
  "name": "sessionState",
  "type": "enum",
  "enums": [
    "ENUM_SESSION_STATE_CREATED",
    "ENUM_SESSION_STATE_SELECTED",
    "ENUM_SESSION_STATE_HAS_ERROR",
    "ENUM_SESSION_STATE_DISPATCHED"
  ],
  "mandatory": "true"
}

queryFilterId  → queryFilters

{
  "name": "queryFilterId",
  "type": "foreignKey",
  "table": "queryFilters"
}

userAccountId M  → userAccounts

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

name M

{
  "name": "name",
  "type": "text",
  "maxLength": 50,
  "mandatory": "true"
}

prioEmail

{
  "name": "prioEmail",
  "type": "tinyint"
}

prioSms

{
  "name": "prioSms",
  "type": "tinyint"
}

prioLetter

{
  "name": "prioLetter",
  "type": "tinyint"
}

subject

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

emailContent

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

smsOutboxId  → smsOutboxes

{
  "name": "smsOutboxId",
  "type": "foreignKey",
  "table": "smsOutboxes"
}

emailOutboxId  → emailOutboxes

{
  "name": "emailOutboxId",
  "type": "foreignKey",
  "table": "emailOutboxes"
}

smsSender

{
  "name": "smsSender",
  "type": "text",
  "maxLength": 14
}

smsContent

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

letterContent

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

createdDate

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

updatedDate

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

Referenced by

communicateContacts as communicateSessionId