Table : customFields

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

{
  "name": "customFieldsGroupId",
  "type": "foreignKey",
  "table": "customFieldsGroups"
}

{
  "name": "organizationUnitId",
  "type": "foreignKey",
  "table": "organizationUnits"
}

{
  "name": "flowStepId",
  "type": "foreignKey",
  "table": "flowSteps",
  "schema": "mspx_admin"
}

{
  "name": "fieldType",
  "type": "enum",
  "mandatory": "true",
  "enums": [
    "ENUM_CUSTOM_FIELDS_FIELD_TYPE_TEXT (Text)",
    "ENUM_CUSTOM_FIELDS_FIELD_TYPE_INTEGER (Heltal)",
    "ENUM_CUSTOM_FIELDS_FIELD_TYPE_DECIMAL (Decimaltal)",
    "ENUM_CUSTOM_FIELDS_FIELD_TYPE_BIT (Ja/nej)",
    "ENUM_CUSTOM_FIELDS_FIELD_TYPE_DATETIME (Datum/tid)",
    "ENUM_CUSTOM_FIELDS_FIELD_TYPE_DOCUMENT_BIT (Ja/nej dokument)",
    "ENUM_CUSTOM_FIELDS_FIELD_TYPE_URL (Url)",
    "ENUM_CUSTOM_FIELDS_FIELD_TYPE_LOOKUP (Sök URL)"
  ]
}

{
  "name": "isMandatory",
  "type": "bit"
}

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

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

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

{
  "name": "isReadOnly",
  "type": "bit"
}

{
  "name": "isNotDisplayed",
  "type": "bit"
}

{
  "name": "tableName",
  "type": "text",
  "maxLength": 40,
  "mandatory": "true"
}

{
  "name": "documentVariableName",
  "type": "text",
  "maxLength": 100
}

{
  "name": "documentVariableText",
  "type": "text"
}

{
  "name": "lookupURL",
  "type": "text",
  "maxLength": 200
}

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

{
  "name": "defaultValue",
  "type": "text"
}

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