-
Notifications
You must be signed in to change notification settings - Fork 2
DbColumn
do- edited this page Jan 8, 2023
·
35 revisions
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.
| 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 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'. |