1. Home
  2. Docs
  3. Compiler
  4. Schema (XML)
  5. Column element

Column element

<column
  name = "/ColumnName/"
  [description = "/Column Description/"]
  [primaryKey = "true|{false}"]
  [autoIncrement = "true|{false}"]
  [required = "true|{false}"]
  [type = "BOOLEAN|TINYINT|SMALLINT|INTEGER|BIGINT|DOUBLE|FLOAT|DECIMAL|CHAR|VARCHAR|LONGVARCHAR|DATE|TIME|TIMESTAMP|BLOB|ARRAY|ENUM|BINARY"]
  [size = "/NumericLengthOfColumn/"]
  [scale = "/DigitsAfterDecimalPlace/"]
  [defaultValue = "/AnyDefaultValueMatchingType/"]
  [valueSet = "/CommaSeparatedValues/"]
  >
</column>
  • name The database column name. Use a the reference name in the model.
  • description It will determine if a form field is required when compiling. Is is also the caption of the form field.
  • required Use for automatic validation.
  • type The database-agnostic column type. It will also affect the behavior of the form field if any.
  • defaultValue The default value that the object will have for this column. This value is always interpreted as a string.
  • valueSet The list of enumerated values accepted on an ENUM column. The list contains 255 values at most, separated by commas.
  • size Column length.
  • scale Length after the decimal point. Applicable to type: decimal and float
  • autoIncrement Table column auto increment.
  • primaryKey Table column primary key.

How can we help?

Leave a Reply