Table : incomingSms

Raw table description

Fields

id id

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

communicationTokenId  → communicationTokens

{
  "name": "communicationTokenId",
  "type": "foreignKey",
  "table": "communicationTokens",
  "schema": "mspx_admin"
}

message

{
  "name": "message",
  "type": "text",
  "maxLength": 160
}

sender

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

receiver

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

receivedDate

{
  "name": "receivedDate",
  "type": "datetime"
}

updatedDate

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

Referenced by

bids as incomingSmsId
incomingSmsContacts as incomingSmsId