Table : futureChanges

Raw table description

Fields

id id

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

createdByUserId M  → userAccounts

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

eventTable M 

{
  "name": "eventTable",
  "type": "text",
  "maxLength": 120,
  "mandatory": "true"
}

eventId M 

{
  "name": "eventId",
  "type": "genericForeignKey",
  "tableNameInField": "eventTable",
  "mandatory": "true"
}

eventData 

{
  "name": "eventData",
  "type": "jsonObject"
}

eventType M E

{
  "name": "eventType",
  "type": "enum",
  "enums": [
    "ENUM_FUTURE_CHANGES_EVENT_TYPE_CONTACT_ADDRESS_CHANGE"
  ],
  "mandatory": "true"
}

triggerDate M 

{
  "name": "triggerDate",
  "type": "date",
  "mandatory": "true"
}

createdDate 

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

updatedDate 

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