Column name
|
Data type
|
Description
|
DOMAIN_SYSID
|
INTEGER
|
System identifier for the domain. |
COLLATION_SYSID
|
INTEGER
|
System identifier for the collation for a domain associated with a character set. |
DATA_TYPE
|
CHAR(30)
|
Identifies the data type of the domain.
Can be one of the following:
"BIGINT"
"BINARY"
"BINARY VARYING"
"CHARACTER"
"CHARACTER VARYING"
"DATE"
"DECIMAL"
"DOUBLE PRECISION"
"FLOAT"
"INTEGER"
"INTERVAL"
"NUMERIC"
"REAL"
"SMALLINT"
"TIME"
"TIMESTAMP". |
INTERVAL_TYPE
|
CHAR(30)
|
For interval data types, this is a character string specifying the interval qualifier for the named interval data type, see the Mimer SQL Reference Manual. For other data types it is the NULL value. |
CHAR_MAX_LENGTH
|
INTEGER
|
For a character data type, this shows the maximum length in characters. For all other data types it is the NULL value. |
CHAR_OCTET_LENGTH
|
INTEGER
|
For a character data type, this shows the maximum length in octets. For all other data types it is the NULL value. (For single octet character sets, this is the same as CHAR_MAX_LENGTH). |
NUMERIC_PRECISION
|
INTEGER
|
For numeric data types, this shows the total number of decimal digits allowed in the column. For all other data types it is the NULL value. NUMERIC_PREC_RADIX indicates the units of measurement. |
NUMERIC_SCALE
|
INTEGER
|
This defines the total number of significant digits to the right of the decimal point. For INTEGER and SMALLINT, this is 0. For CHARACTER, CHARACTER VARYING, DATETIME, FLOAT, INTERVAL, REAL and DOUBLE PRECISION data types, it is the NULL value. |
NUMERIC_PREC_RADIX
|
INTEGER
|
For numeric data types, the value 10 is shown because NUMERIC_PRECISION specifies a number of decimal digits. For all other data types it is the NULL value. NUMERIC_PRECISION and NUMERIC_PREC_RADIX can be combined to calculate the maximum number that the column can hold. |
DATETIME_PRECISION
|
INTEGER
|
For DATE, TIME, TIMESTAMP and interval data types, this column contains the number of digits of precision for the fractional seconds component. For other data types it is the NULL value. |
INTERVAL_PRECISION
|
INTEGER
|
For interval data types, this is the number of significant digits for the interval leading precision, see the Mimer SQL Reference Manual.
For other data types it is the NULL value.
|
INTERVAL_LENGTH
|
INTEGER
|
Length in bytes of value. |
DOMAIN_DEFAULT
|
VARCHAR(2000)
|
This shows the default value for the domain.
If the default value is a character string, the value shown is the string enclosed in single quotes.
If the default value is a numeric literal, the value is shown in its original character representation without enclosing quotes.
If the default value is a DATE, TIME or TIMESTAMP, the value shown is the appropriate keyword (e.g. DATE) followed by the literal representation of the value enclosed in single quotes, see Mimer SQL Reference Manual for a description of DATE, TIME and TIMESTAMP literals.
If the default value is a pseudo-literal, the value shown is the appropriate keyword (e.g. CURRENT_DATE) without enclosing quotes.
If the default value is the NULL value, the value shown is the keyword NULL without enclosing quotes.
If the default value cannot be represented without truncation, then TRUNCATED is shown without enclosing quotes and the text will be stored in the SOURCE_DEFINITION table.
If no default value was specified then its value is the NULL value.
The value of DOMAIN_DEFAULT is syntactically suitable for use in specifying default-value in a CREATE TABLE or ALTER TABLE statement.
|
ANY_CONSTRAINT
|
CHAR(3)
|
One of:
"NO" = There are no constraints for the domain
"YES" = There are constraints for the domain. |
IS_LEVEL2_APPROVED
|
CHAR(3)
|
One of:
"NO" = Tables using this domain can not be used with the level 2 interface
"YES" = The use of this domain does not prohibit the table being used with the level 2 interface. |
