Table : contactSmsNumbers

Numbers that broker are allowed to send SMS from

Raw table description

Fields

id id

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

contactId M  → contacts

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

phoneNumber M

{
  "name": "phoneNumber",
  "type": "text",
  "maxLength": 25,
  "mandatory": "true"
}

startDate

{
  "name": "startDate",
  "type": "date",
  "readOnly": true
}

endDate

{
  "name": "endDate",
  "type": "date",
  "readOnly": true
}

updatedDate

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

Referenced by

biddings as contactSmsNumberId