column-remarks.properties

hsqldb是100％java实现的数据库,是一个开放源代码的JAVA数据库 l 具有标准的SQL语法和JAVA接口 l HSQLDB可以自由使用和分发 l 非常简洁和快速的

SYSTEM_TYPEINFO_NUM_PREC_RADIX=For numeric types, this column contains the value 10 to indicate that COLUMN_SIZE specifies a number of decimal digits.  Otherwise, this column is NULL.
SYSTEM_TYPEINFO_TYPE_SUB=the variant tag for this variation of the data type.  1 = standard, 2 = identity, 4 = ignore case
# SYSTEM_UDTS
SYSTEM_UDTS_TYPE_CAT=type's catalog
SYSTEM_UDTS_TYPE_SCHEM=type's schema
SYSTEM_UDTS_TYPE_NAME=type's DBMS name
SYSTEM_UDTS_CLASS_NAME=type's Java class name
SYSTEM_UDTS_DATA_TYPE=type value defined in DITypes, from one of { "JAVA_OBJECT" | "STRUCT" | "DISTINCT" }
SYSTEM_UDTS_BASE_TYPE=type code of the source type of a DISTINCT type or the type that implements the user-generated reference type of the SELF_REFERENCING_COLUMN of a structured type as defined in DITypes (null if DATA_TYPE is not DISTINCT or not STRUCT with REFERENCE_GENERATION = USER_DEFINED)
SYSTEM_UDTS_REMARKS=explanatory comment on the user defined type
# SYSTEM_UDTATTRIBUTES
SYSTEM_UDTATTRIBUTES_TYPE_CAT=type catalog
SYSTEM_UDTATTRIBUTES_TYPE_SCHEM=type schema
SYSTEM_UDTATTRIBUTES_TYPE_NAME=type name
SYSTEM_UDTATTRIBUTES_ATTR_NAME=attribute name
SYSTEM_UDTATTRIBUTES_DATA_TYPE=attribute type SQL type from DITypes
SYSTEM_UDTATTRIBUTES_ATTR_TYPE_NAME=Data source dependent type name. For a UDT, the type name is fully qualified. For a REF, the type name is fully qualified and represents the target type of the reference type.
SYSTEM_UDTATTRIBUTES_ATTR_SIZE=column size. For char or date types this is the maximum number of characters; for numeric or decimal types this is precision.
SYSTEM_UDTATTRIBUTES_DECIMAL_DIGITS=the number of fractional digits (scale) of number type
SYSTEM_UDTATTRIBUTES_NUM_PREC_RADIX=Radix of number type
SYSTEM_UDTATTRIBUTES_NULLABLE=whether NULL is allowed
SYSTEM_UDTATTRIBUTES_REMARKS=comment describing attribute
SYSTEM_UDTATTRIBUTES_ATTR_DEF=default attribute value
SYSTEM_UDTATTRIBUTES_SQL_DATA_TYPE=The value of the SQL data type as it would appear in the SQL CLI SQL_DESC_TYPE field of the SQLDA
SYSTEM_UDTATTRIBUTES_SQL_DATETIME_SUB=When the value of SQL_DATA_TYPE is SQL_DATETIME or SQL_INTERVAL, this column contains the datetime/interval subcode.  For data types other than datetime and interval, this column is NULL.
SYSTEM_UDTATTRIBUTES_CHAR_OCTET_LENGTH=for char types the maximum number of bytes in the column
SYSTEM_UDTATTRIBUTES_ORDINAL_POSITION=index of column in table (starting at 1)
SYSTEM_UDTATTRIBUTES_IS_NULLABLE="NO" means column definitely does not allow NULL values; "YES" means the column might allow NULL values. An empty string means unknown.
SYSTEM_UDTATTRIBUTES_SCOPE_CATALOG=catalog of table that is the scope of a reference attribute (NULL if DATA_TYPE isn't REF)
SYSTEM_UDTATTRIBUTES_SCOPE_SCHEMA=schema of table that is the scope of a reference attribute (NULL if DATA_TYPE isn't REF)
SYSTEM_UDTATTRIBUTES_SCOPE_TABLE=table name that is the scope of a reference attribute (NULL if the DATA_TYPE isn't REF)
SYSTEM_UDTATTRIBUTES_SOURCE_DATA_TYPE=source type of a distinct type or user-generated Ref type, SQL type from DITypes (NULL if DATA_TYPE isn't DISTINCT or user-generated REF)
# SYSTEM_USERS
SYSTEM_USERS_USER=user name
SYSTEM_USERS_ADMIN=has the administrative privilege?
# SYSTEM_VERSIONCOLUMNS
SYSTEM_VERSIONCOLUMNS_TABLE_CAT=table catalog
SYSTEM_VERSIONCOLUMNS_TABLE_SCHEM=table schema
SYSTEM_VERSIONCOLUMNS_TABLE_NAME=simple table name
SYSTEM_VERSIONCOLUMNS_SCOPE=not used
SYSTEM_VERSIONCOLUMNS_COLUMN_NAME=column name
SYSTEM_VERSIONCOLUMNS_DATA_TYPE=SQL data type from DITypes
SYSTEM_VERSIONCOLUMNS_TYPE_NAME=Data source dependent type name
SYSTEM_VERSIONCOLUMNS_COLUMN_SIZE=precision
SYSTEM_VERSIONCOLUMNS_BUFFER_LENGTH=length of column value in bytes
SYSTEM_VERSIONCOLUMNS_DECIMAL_DIGITS=scale
SYSTEM_VERSIONCOLUMNS_PSEUDO_COLUMN=is this a pseudo column like an Oracle ROWID: { Unknown | Not Pseudo | Pseudo }?
# SYSTEM_VIEWS
SYSTEM_VIEWS_TABLE_CATALOG=name of catalog in which view is defined
SYSTEM_VIEWS_TABLE_SCHEMA=unqualified name of schema in which view is defined
SYSTEM_VIEWS_TABLE_NAME=simple name of view
SYSTEM_VIEWS_VIEW_DEFINITION=the character representation of the query expression contained in the corresponding view descriptor.
SYSTEM_VIEWS_CHECK_OPTION={"CASCADED" | "LOCAL" | "NONE"}
SYSTEM_VIEWS_IS_UPDATABLE={"YES" | "NO"}
SYSTEM_VIEWS_VALID={TRUE | FALSE}
# Since 1.7.2 RC1
# SYSTEM_CHECK_COLUMN_USAGE
SYSTEM_CHECK_COLUMN_USAGE_CONSTRAINT_CATALOG=constraint catalog name
SYSTEM_CHECK_COLUMN_USAGE_CONSTRAINT_SCHEMA=constraint schema name
SYSTEM_CHECK_COLUMN_USAGE_CONSTRAINT_NAME=constraint identifier
SYSTEM_CHECK_COLUMN_USAGE_TABLE_CATALOG=table catalog name
SYSTEM_CHECK_COLUMN_USAGE_TABLE_SCHEMA= table schema name
SYSTEM_CHECK_COLUMN_USAGE_TABLE_NAME=table name
SYSTEM_CHECK_COLUMN_USAGE_COLUMN_NAME=name of column referenced explicitly or implicitly as contained in the <search condition> of the constraint being described.
# SYSTEM_CHECK_CONSTRAINTS
SYSTEM_CHECK_CONSTRAINTS_CONSTRAINT_CATALOG=constraint catalog name
SYSTEM_CHECK_CONSTRAINTS_CONSTRAINT_SCHEMA=constraint schema name
SYSTEM_CHECK_CONSTRAINTS_CONSTRAINT_NAME=constraint identifier
SYSTEM_CHECK_CONSTRAINTS_CHECK_CLAUSE=the character representation of the <search condition> contained in the <check constraint definition>, <domain constraint definition>, or <assertion definition> that defined the check constraint being described, or NULL if it cannot be described without truncation
# SYSTEM_CHECK_ROUTINE_USAGE
SYSTEM_CHECK_ROUTINE_USAGE_CONSTRAINT_CATALOG=constraint catalog name
SYSTEM_CHECK_ROUTINE_USAGE_CONSTRAINT_SCHEMA=constraint schema name
SYSTEM_CHECK_ROUTINE_USAGE_CONSTRAINT_NAME=constraint identifier
SYSTEM_CHECK_ROUTINE_USAGE_SPECIFIC_CATALOG=catalog name of specific name of routine
SYSTEM_CHECK_ROUTINE_USAGE_SPECIFIC_SCHEMA=schema name of specific name of routine
SYSTEM_CHECK_ROUTINE_USAGE_SPECIFIC_NAME=specific name of SQL-invoked routine identified as the subject routine of either a <routine invocation>, a <method reference>, a <method invocation>, or a <static method invocation> contained in the <assertion definition> or in the <check constraint definition> contained in either a <domain constraint> or a <table constraint definition>
# SYSTEM_CHECK_TABLE_USAGE
SYSTEM_CHECK_TABLE_USAGE_CONSTRAINT_CATALOG=constraint catalog name
SYSTEM_CHECK_TABLE_USAGE_CONSTRAINT_SCHEMA=constraint schema name
SYSTEM_CHECK_TABLE_USAGE_CONSTRAINT_NAME=constraint identifier
SYSTEM_CHECK_TABLE_USAGE_TABLE_CATALOG=table catalog name
SYSTEM_CHECK_TABLE_USAGE_TABLE_SCHEMA=table schema name
SYSTEM_CHECK_TABLE_USAGE_TABLE_NAME=name of a table identified by a <table name> simply contained in a <table reference> contained in the lt;search condition> of the constraint being described.
# SYSTEM_SEQUENCES
SYSTEM_SEQUENCES_SEQUENCE_CATALOG=sequence catalog name
SYSTEM_SEQUENCES_SEQUENCE_SCHEMA=sequence schema name
SYSTEM_SEQUENCES_SEQUENCE_NAME=sequence identifier
SYSTEM_SEQUENCES_DTD_IDENTIFIER=implementation dependent data type descriptor identifier
SYSTEM_SEQUENCES_MAXIMUM_VALUE=sequence maximum value
SYSTEM_SEQUENCES_MINIMUM_VALUE=sequence minimum value
SYSTEM_SEQUENCES_INCREMENT=sequence increment
SYSTEM_SEQUENCES_CYCLE_OPTION=sequence cycle option ('YES' | 'NO')
SYSTEM_SEQUENCES_START_WITH=sequence start with value
# SYSTEM_TABLE_CONSTRAINTS
SYSTEM_TABLE_CONSTRAINTS_CONSTRAINT_CATALOG=constraint catalog name
SYSTEM_TABLE_CONSTRAINTS_CONSTRAINT_SCHEMA=constraint schema name
SYSTEM_TABLE_CONSTRAINTS_CONSTRAINT_NAME=constraint identifier
SYSTEM_TABLE_CONSTRAINTS_CONSTRAINT_TYPE=('UNIQUE' | 'PRIMARY KEY' | 'FOREIGN KEY' | 'CHECK')
SYSTEM_TABLE_CONSTRAINTS_TABLE_CATALOG=table catalog name
SYSTEM_TABLE_CONSTRAINTS_TABLE_SCHEMA=table schema name
SYSTEM_TABLE_CONSTRAINTS_TABLE_NAME=table identifier
SYSTEM_TABLE_CONSTRAINTS_IS_DEFERRABLE=('YES' | 'NO')
SYSTEM_TABLE_CONSTRAINTS_INITIALLY_DEFERRED=('YES' | 'NO')
# SYSTEM_USAGE_PRIVILEGES
SYSTEM_USAGE_PRIVILEGES_GRANTOR=<authorization identifier> of the user or role who granted usage privileges on the object
SYSTEM_USAGE_PRIVILEGES_GRANTEE=<authorization identifier> of some user or role, or ?PUBLIC? to indicate all users, to whom the usage privilege being described is granted
SYSTEM_USAGE_PRIVILEGES_OBJECT_CATALOG=object catalog name
SYSTEM_USAGE_PRIVILEGES_OBJECT_SCHEMA=object catalog schema
SYSTEM_USAGE_PRIVILEGES_OBJECT_NAME=identifier of the object to which the privilege applies
SYSTEM_USAGE_PRIVILEGES_OBJECT_TYPE=(DOMAIN' | 'CHARACTER SET' | 'COLLATION' | 'TRANSLATION' | 'SEQUENCE')
SYSTEM_USAGE_PRIVILEGES_IS_GRANTABLE=('YES' | 'NO')
# SYSTEM_VIEW_COLUMN_USAGE
SYSTEM_VIEW_COLUMN_USAGE_VIEW_CATALOG=view catalog name
SYSTEM_VIEW_COLUMN_USAGE_VIEW_SCHEMA=view schema name
SYSTEM_VIEW_COLUMN_USAGE_VIEW_NAME=view identifier
SYSTEM_VIEW_COLUMN_USAGE_TABLE_CATALOG=table catalog name
SYSTEM_VIEW_COLUMN_USAGE_TABLE_SCHEMA=table schema name
SYSTEM_VIEW_COLUMN_USAGE_TABLE_NAME=table identifier
SYSTEM_VIEW_COLUMN_USAGE_COLUMN_NAME=column of table that is explicitly or implicitly referenced in the <query expression> of the view being described.
# SYSTEM_VIEW_ROUTINE_USAGE
SYSTEM_VIEW_ROUTINE_USAGE_TABLE_CATALOG=view catalog name
SYSTEM_VIEW_ROUTINE_USAGE_TABLE_SCHEMA=view schema name
SYSTEM_VIEW_ROUTINE_USAGE_TABLE_NAME=view identifier
SYSTEM_VIEW_ROUTINE_USAGE_SPECIFIC_CATALOG=catalog name of specific name of routine
SYSTEM_VIEW_ROUTINE_USAGE_SPECIFIC_SCHEMA=schema name of specific name of routine
SYSTEM_VIEW_ROUTINE_USAGE_SPECIFIC_NAME=specific name of SQL-invoked subject routine of either a <routine invocation>, a <method reference>, a <method invocation>, or a <static method invocation> contained in the <view definition>

SYSTEM_VIEW_TABLE_USAGE_VIEW_CATALOG=view catalog name
SYSTEM_VIEW_TABLE_USAGE_VIEW_SCHEMA=view schema name
SYSTEM_VIEW_TABLE_USAGE_VIEW_NAME=view identifier
SYSTEM_VIEW_TABLE_USAGE_TABLE_CATALOG=table catalog name
SYSTEM_VIEW_TABLE_USAGE_TABLE_SCHEMA=table schema name
SYSTEM_VIEW_TABLE_USAGE_TABLE_NAME=table identified by a <table name> simply contained in a <table reference> that is contained in the <query expression> of the view being described.
# Since 1.8.0
# SYSTEM_AUTHORIZATIONS
SYSTEM_AUTHORIZATIONS_AUTHORIZATION_NAME=a <role name> or <user identifier>
SYSTEM_AUTHORIZATIONS_AUTHORIZATION_TYPE=('USER' | 'ROLE') whether the AUTHORIZATION_NAME is a known <user identifier> or is a <role name> defined by a <role definition>.
# SYSTEM_COLLATIONS
SYSTEM_COLLATIONS_COLLATION_CATALOG=catalog name of the collation being described
SYSTEM_COLLATIONS_COLLATION_SCHEMA=unqualified schema name of the collation being described
SYSTEM_COLLATIONS_COLLATION_NAME=qualified identifier of the collation being described
SYSTEM_COLLATIONS_PAD_ATTRIBUTE=('NO PAD' | 'PAD SPACE') whether the collation being described has the NO PAD or PAD SPACE characteristic
SYSTEM_COLLATIONS_COLLATION_TYPE=NULL (deprecated)
SYSTEM_COLLATIONS_COLLATION_DEFINITION=NULL (deprecated)
SYSTEM_COLLATIONS_COLLATION_DICTIONARY=NULL (deprecated)
SYSTEM_COLLATIONS_CHARACTER_REPERTOIRE_NAME=the name of the charater repertoire to which the collation being described is applicable.
# SYSTEM_ROLE_AUTHORIZATION_DESCRIPTORS
SYSTEM_ROLE_AUTHORIZATION_DESCRIPTORS_ROLE_NAME=the <role name> of some <role granted> by the <grant role statement> or the <role name> of a <role definition>.
SYSTEM_ROLE_AUTHORIZATION_DESCRIPTORS_GRANTEE=an <authorization identifier>, possibly PUBLIC, or <role name> specified as a <grantee> contained in a <grant role statement>, or the <authorization identifier> of the current SQLsession when the <role definition> is executed.
SYSTEM_ROLE_AUTHORIZATION_DESCRIPTORS_GRANTOR=the <authorization identifier> of the user or role who granted the role identified by ROLE_NAME to the user or role identified by the value of GRANTEE.
# SYSTEM_SCHEMATA
SYSTEM_SCHEMATA_CATALOG_NAME=the name of the catalog of the described schema
SYSTEM_SCHEMATA_SCHEMA_NAME=the unqualified schema name of the described schema
SYSTEM_SCHEMATA_SCHEMA_OWNER=the authorization identifier that owns the schema.
SYSTEM_SCHEMATA_DEFAULT_CHARACTER_SET_CATALOG=the catalog name of the default character set for columns and domains in the schema.
SYSTEM_SCHEMATA_DEFAULT_CHARACTER_SET_SCHEMA=the unqualified schema name of the default character set for columns and domains in the schema.
SYSTEM_SCHEMATA_DEFAULT_CHARACTER_SET_NAME=the qualified identifier of the default character set for columns and domains in the schemata.
SYSTEM_SCHEMATA_SQL_PATH=the character representation of the schema's <schema path specification>, or null if it cannot be represented without truncation