Table : customFields

Raw table description

Fields

id id

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

customFieldsGroupId  → customFieldsGroups

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

organizationUnitId  → organizationUnits

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

flowStepId  → flowSteps

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

fieldType M E

{
  "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)"
  ]
}

isMandatory bit

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

maxLength

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

decimals

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

name

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

isReadOnly bit

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

isNotDisplayed bit

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

tableName M

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

documentVariableName

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

documentVariableText

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

lookupURL

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

displayOrder

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

defaultValue

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

updatedDate

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

Referenced by

customFieldsValues as customFieldId
documentBundles as customFieldId
objectTypeCustomFields as customFieldId (connection table to objectTypes via objectTypeId)