ASA SQL Reference
System Tables
| Column name | Column type | Column constraint | Table constraints |
|---|---|---|---|
| type_id | SMALLINT | NOT NULL | Primary key |
| creator | UNSIGNED INT | NOT NULL | Foreign key references SYSUSERPERM.user_id |
| domain_id | SMALLINT | NOT NULL | Foreign key references SYSDOMAIN |
| nulls | CHAR(1) | NOT NULL | |
| width | SMALLINT | NOT NULL | |
| scale | SMALLINT | NOT NULL | |
| type_name | CHAR(128) | NOT NULL | Unique |
| "default" | LONG VARCHAR | ||
| "check" | LONG VARCHAR | ||
| format_str | CHAR(128) | ||
| super_type_id | SMALLINT | Foreign key references 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.