Table : queryFilters

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

{
  "name": "filterType",
  "type": "enum",
  "enums": [
    "ENUM_QUERY_FILTER_TYPE_COMMUNICATE",
    "ENUM_QUERY_FILTER_TYPE_DASHBOARD_LIST",
    "ENUM_QUERY_FILTER_TYPE_DEAL_LIST",
    "ENUM_QUERY_FILTER_TYPE_CONTACT_LIST"
  ],
  "mandatory": "true"
}

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

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

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

{
  "name": "displayOrder",
  "type": "int"
}

{
  "name": "scope",
  "type": "enum",
  "enums": [
    "ENUM_QUERY_FILTER_SCOPE_USER",
    "ENUM_QUERY_FILTER_SCOPE_OFFICE",
    "ENUM_QUERY_FILTER_SCOPE_PUBLIC"
  ]
}

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

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