Reference Manual
CHAPTER 15. System Tables
Column name |
Column type |
Column constraint |
Table constraints |
|---|---|---|---|
type_id |
SMALLINT |
NOT NULL |
Primary key |
creator |
SMALLINT |
NOT NULL |
Foreign key references SYS.SYSUSERPERM. user_id |
domain_id |
SMALLINT |
NOT NULL |
Foreign key references SYS.SYSDOMAIN |
nulls |
CHAR(1) |
NOT NULL |
|
width |
SMALLINT |
NOT NULL |
|
scale |
SMALLINT |
NOT NULL |
|
type_name |
CHAR(128) |
NOT NULL |
|
"default" |
LONG VARCHAR |
NULL |
|
"check" |
LONG VARCHAR |
NULL |
|
format_str |
CHAR(128) |
||
super_type_id |
SMALLINT |
NULL |
Foreign key references SYS.SYSUSERTYPE. type_id. |
Each row holds a description of a user-defined data type.
type_id A unique identifying number for the user-defined data type.
creator The user number of the owner of the data type.
domain_id The data type on which this user defined data type is based, indicated by a data type number listed in the SYSDOMAIN table.
nulls (Y/N) Indicates whether the user-defined data type allows nulls.
width The length of a string column, the precision of a numeric column, or the number of bytes of storage for any other data type.
scale The number of digits after the decimal point for numeric data type columns, and zero for all other data types.
type_name The name for the data type, which must be a valid identifier.
default The default value for the data type.
check The CHECK condition for the data type.
format_str Currently unused.