Skip to content

Column element

Column definition for a Custom Table

Attributes

Category

Category of this column. This attribute must be specified with a value of ‘Binary’ if the Type attribute’s value is ‘binary’. This attribute’s value must be one of the following:

  • text
  • upperCase
  • lowerCase
  • integer
  • doubleInteger
  • timeDate
  • identifier
  • property
  • filename
  • wildCardFilename
  • path
  • paths
  • anyPath
  • defaultDir
  • regPath
  • formatted
  • formattedSddl
  • template
  • condition
  • guid
  • version
  • language
  • binary
  • customSource
  • cabinet
  • shortcut

Description

string

Description of this column.

Id

string required

Identifier for the column.

KeyColumn

Integer

Column in the table in KeyTable attribute.

KeyTable

string

Table in which this column is an external key. Can be semicolon delimited.

Localizable

yesno

Whether this column can be localized.

MaxValue

xs:long

Maximum value for a numeric value, date or version in this column.

MinValue

xs:long

Minimum value for a numeric value, date or version in this column.

Modularize

How this column should be modularized, if at all. This attribute’s value must be one of the following:

  • none: Column should not be modularized. This is the default value.
  • column: Column should be modularized.
  • condition: Column is a condition and should be modularized.
  • icon: When the column is an primary or foreign key to the Icon table it should be modularized special.
  • property: Any Properties in the column should be modularized.
  • semicolonDelimited: Semi-colon list of keys, all of which need to be modularized.

Nullable

yesno

Whether this column can be left null.

PrimaryKey

yesno

Whether this column is a primary key.

Set

string

Semicolon delimited list of permissible values.

Type

required

The type of this column. This attribute’s value must be one of the following:

  • binary: Column contains a path to a file that will be inserted into the column as a binary object. If this value is set, the Category attribute must also be set with a value of ‘Binary’ to pass ICE validation.
  • int: Column contains an integer or datetime value (the MinValue and MaxValue attributes should also be set).
  • string: Column contains a non-localizable string value.

Width

Integer

Width of this column.

Parents

CustomTable