Table : gridFilters

Raw table description

Fields

id id

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

userAccountId M  → userAccounts

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

name M

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

type M E

{
  "name": "type",
  "type": "enum",
  "enums": [
    "ENUM_GRID_FILTERS_CONTACTS",
    "ENUM_GRID_FILTERS_EXTERNAL_CONTACTS",
    "ENUM_GRID_FILTERS_DEALS",
    "ENUM_GRID_FILTERS_ASSISTANT_DEALS",
    "ENUM_GRID_FILTERS_HOUSING_ASSOCIATIONS",
    "ENUM_GRID_FILTERS_VIEWINGS"
  ],
  "mandatory": "true"
}

jsonData M

{
  "name": "jsonData",
  "type": "jsonObject",
  "mandatory": "true"
}

createdDate

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

updatedDate

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