DbColumn

DbColumn is an object describing a column of a relation (a regular data table or some similar object like SQL view etc.) in a database.

Properties

Name	Type	Description
name	String	Name (identifier) of this column
comment	String	Comment for this column
type	String	Name of the data type
size	int	Maximum size of the data (length for VARCHAR, precision for DECIMAL etc.). The exact meaning (units etc.) and the mere existence meaning depends of the type.
scale	int	For DECIMAL, his synonyms and/or derived types, (NUMERIC etc.) means the length of the fractional part. Must be absent for other types.
default	String	The DEFAULT clause of the corresponding CREATE/ALTER TABLE statement. Always presented as a String, including numeric types. Explicit DEFAULT NULL is defined by a 4-letter string 'NULL'.
nullable	Boolean	false for NOT NULL columns, true otherwise.
min	String	The minimal allowed value. Corresponds to the HTML INPUT's min attribute. May be used in autogenerated validation procedures, forwarded to UI components etc.
max	String	The maximal allowed value. Corresponds to the HTML INPUT's max attribute. May be used in autogenerated validation procedures, forwarded to UI components etc.
pattern	String	The regular expression to test values against. Corresponds to the HTML INPUT's pattern attribute. May be used in autogenerated validation procedures, forwarded to UI components etc.