column-remarks.properties

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

# default column-remarks
# SYSTEM_ALIASES
SYSTEM_ALIASES_OBJECT_TYPE=type of the aliased object: "DOMAIN" for data type aliases and "ROUTINE" for routine call aliases
SYSTEM_ALIASES_OBJECT_CAT=catalog in which the aliased object is defined
SYSTEM_ALIASES_OBJECT_SCHEM=schema in which the aliased object is defined
SYSTEM_ALIASES_OBJECT_NAME=simple identifier of the aliased object
SYSTEM_ALIASES_ALIAS_CAT=catalog in which the alias is defined
SYSTEM_ALIASES_ALIAS_SCHEM=schema in which the alias is defined
SYSTEM_ALIASES_ALIAS=the SQL identifier which is the alias for the indicated object
# SYSTEM_ALLTYPEINFO
SYSTEM_ALLTYPEINFO_TYPE_NAME=the HSQLDB-specific data type name; this is the canonical name used in CREATE TABLE and ALTER TABLE statements.
SYSTEM_ALLTYPEINFO_DATA_TYPE=SQL data type.  This may be a java.sql.Types data type, a SQL 200n data type or an HSQLDB-specific data type.  For datetime or interval data types, this column returns the concise data type (such as SQL_璗YPE_璗IME or SQL_璉NTERVAL_璝EAR_璗O_璏ONTH).
SYSTEM_ALLTYPEINFO_PRECISION=The maximum column size for this data type.  For numeric data, this is the maximum precision.  For string data, this is the length in characters.  For datetime data types, this is the length in characters of the string representation (assuming the maximum allowed precision of the fractional seconds component).  NULL for data types where column size is not applicable.  For interval data types, this is the number of characters in the character representation of the interval literal (as defined by the interval leading precision).
SYSTEM_ALLTYPEINFO_LITERAL_PREFIX=the character or characters used to prefix a literal of this type; for example, a single quotation mark (') for character data types; NULL for data types where a literal prefix is not applicable
SYSTEM_ALLTYPEINFO_LITERAL_SUFFIX=the character or characters used to terminate a literal of this type; for example, a single quotation mark (') for character data types; NULL for data types where a literal suffix is not applicable
SYSTEM_ALLTYPEINFO_CREATE_PARAMS=A list of keywords, separated by commas, corresponding to each parameter that may be specified in parentheses when issuing DDL relative to the data type.  The keywords in the list, in the language of the current Locale, may be any of the following:  length, precision, scale.  They appear in the order that the syntax requires that they be used.  For example, CREATE_PARAMS for DECIMAL with an English locale would be "precision,scale"; CREATE_PARAMS for VARCHAR would be "length".  The value is NULL if there are no parameters for the data type definition; for example, INTEGER.
SYSTEM_ALLTYPEINFO_NULLABLE=NULL values allowed for this type?: { No Nulls | Nullable | Unknown }
SYSTEM_ALLTYPEINFO_CASE_SENSITIVE=TRUE if the type is case-sensitive in collations and comparisons; FALSE otherwise
SYSTEM_ALLTYPEINFO_SEARCHABLE=use of WHERE?: { None | Char (Only WHERE .. LIKE) | Basic (Except WHERE .. LIKE) | Searchable (All forms of WHERE...) }
SYSTEM_ALLTYPEINFO_UNSIGNED_ATTRIBUTE=TRUE if the data type is unsigned; NULL the attribute is not applicable to the data type or the data type is not numeric.
SYSTEM_ALLTYPEINFO_FIXED_PREC_SCALE=TRUE if the data type has predefined fixed precision and scale , like a money data type.  NULL for non-numeric types.
SYSTEM_ALLTYPEINFO_AUTO_INCREMENT=NULL if the attribute is not applicable to the data type or the data type is not numeric.  If TRUE, this indicates that when an insert is made, a unique value is inserted into the column at insert time. The increment is not defined. An application should not assume that auto-increment values start at any particular point or increment by any particular value.
SYSTEM_ALLTYPEINFO_LOCAL_TYPE_NAME=Localized version of the name of the data type; NULL if a localized name is not supported.  This name is intended for display only, such as in dialog boxes
SYSTEM_ALLTYPEINFO_MINIMUM_SCALE=minimum scale supported
SYSTEM_ALLTYPEINFO_MAXIMUM_SCALE=maximum scale supported
SYSTEM_ALLTYPEINFO_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_ALLTYPEINFO_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_ALLTYPEINFO_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_ALLTYPEINFO_INTERVAL_PRECISION=If the data type is an interval data type, then this column contains the value of the interval leading precision.  Otherwise, this column is NULL.
SYSTEM_ALLTYPEINFO_AS_TAB_COL=TRUE if the engine supports this data type as a table column, else FALSE
SYSTEM_ALLTYPEINFO_AS_PROC_COL=TRUE if the engine supports this data type as a procedure parameter or return type, else FALSE
SYSTEM_ALLTYPEINFO_MAX_PREC_ACT=same as PRECISION except for data types whose precision cannot be represented by an INTEGER column value
SYSTEM_ALLTYPEINFO_MIN_SCALE_ACT=same as MINIMUM_SCALE except for data types whose minimum scale cannot be represented by a SMALLINT column value
SYSTEM_ALLTYPEINFO_MAX_SCALE_ACT=same as MAXIMUM_SCALE except for data types whose maximum scale cannot be represented by a SMALLINT column value
SYSTEM_ALLTYPEINFO_COL_ST_CLS_NAME=the fully qualified name of the Java class that HSQLDB uses to represent values of this type in memory
SYSTEM_ALLTYPEINFO_COL_ST_IS_SUP=TRUE if the Java class that HSQLDB uses to represent values of this type in memory is supported under the hosting JVM and engine build options
SYSTEM_ALLTYPEINFO_STD_MAP_CLS_NAME=the fully qualified name of the Java class that the JDBC standard mapping uses to represent values of this type
SYSTEM_ALLTYPEINFO_STD_MAP_IS_SUP=TRUE if the Java class that the JDBC standard mapping uses to represent values of this type is supported under the current JVM
SYSTEM_ALLTYPEINFO_CST_MAP_CLS_NAME=the fully qualified name of the Java class that HSQLDB provides to represent values of this type via the JDBC interface
SYSTEM_ALLTYPEINFO_CST_MAP_IS_SUP=TRUE if the Java class that HSQLDB provides to represent values of this type via the JDBC interface is supported under the hosting JVM and engine build options
SYSTEM_ALLTYPEINFO_MCOL_JDBC=the maximum character octet length of this type if it is representable via the JDBC interface (i.e. as an INTEGER column value)
SYSTEM_ALLTYPEINFO_MCOL_ACT=same as MCOL_JDBC except for data types whose maximum character octet length cannot be represented by an INTEGER column value
SYSTEM_ALLTYPEINFO_DEF_OR_FIXED_SCALE=the default or fixed scale of numeric types; NULL if not applicable of the type is not numeric
SYSTEM_ALLTYPEINFO_REMARKS=a localized explanatory comment on the data type
SYSTEM_ALLTYPEINFO_TYPE_SUB=the variant tag for this variation of the data type.  1 = standard, 2 = identity, 4 = ignore case
# SYSTEM_BESTROWIDENTIFIER
SYSTEM_BESTROWIDENTIFIER_SCOPE=actual scope of result, as defined in java.sql.DatabaseMetadata
SYSTEM_BESTROWIDENTIFIER_COLUMN_NAME=simple column name
SYSTEM_BESTROWIDENTIFIER_DATA_TYPE=SQL data type.  This may be a java.sql.Types data type, a SQL 200n data type or an HSQLDB-specific data type.  For datetime or interval data types, this column returns the concise data type (such as SQL_璗YPE_璗IME or SQL_璉NTERVAL_璝EAR_璗O_璏ONTH).
SYSTEM_BESTROWIDENTIFIER_TYPE_NAME=the HSQLDB-specific data type name; this is the canonical name used in CREATE TABLE and ALTER TABLE statements.
SYSTEM_BESTROWIDENTIFIER_COLUMN_SIZE=precision for number types; length for variable sized types; NULL for others
SYSTEM_BESTROWIDENTIFIER_BUFFER_LENGTH=The maximum length in bytes of data, if definitely known, that would be transferred to a buffer on a fetch operation.  For numeric data, this size may be different than the size of the data stored on the data source.  This value is the same as the COLUMN_SIZE column for binary data. This value is the twice the COLUMN_SIZE column for character data.  If the actual value is larger than can be represented in an INTEGER column value, this is NULL.
SYSTEM_BESTROWIDENTIFIER_DECIMAL_DIGITS=scale of column for number types
SYSTEM_BESTROWIDENTIFIER_PSEUDO_COLUMN=is this a pseudo column like an Oracle ROWID?
SYSTEM_BESTROWIDENTIFIER_TABLE_CAT=catalog in which the table containing the column is defined
SYSTEM_BESTROWIDENTIFIER_TABLE_SCHEM=schema in which the table containing the column is defined
SYSTEM_BESTROWIDENTIFIER_TABLE_NAME=simple name of the table containing the column
SYSTEM_BESTROWIDENTIFIER_NULLABLE=is the column nullable?
SYSTEM_BESTROWIDENTIFIER_IN_KEY=does column participate in primary or alternate key?
# SYSTEM_BYTECODE
SYSTEM_BYTECODE_OBJECT_CAT=catalog in which the executable object is defined
SYSTEM_BYTECODE_OBJECT_SCHEM=schema in which the executable object is defined
SYSTEM_BYTECODE_OBJECT_NAME=simple name of executable object
SYSTEM_BYTECODE_OBJECT_TYPE=type of executable object
SYSTEM_BYTECODE_SIGNATURE=Java method signature of executable object
SYSTEM_BYTECODE_LINE=instruction line number
SYSTEM_BYTECODE_PC=instruction program counter
SYSTEM_BYTECODE_OPCODE=instruction opcode
SYSTEM_BYTECODE_MNEMONIC=instruction mnemonic
SYSTEM_BYTECODE_OPERANDS=instruction operands
SYSTEM_BYTECODE_OPERANDS_DESCRIPTION=a human-readable description of instruction operands
SYSTEM_BYTECODE_INSTRUCTION_DESCRIPTION=a human-readable description of whole instruction
# SYSTEM_CACHEINFO
#SYSTEM_CACHEINFO_CACHE_CLASS=FQN of the Java Class implementing the cache
#SYSTEM_CACHEINFO_CACHE_HASH=the in-memory hashCode() of the Cache object
SYSTEM_CACHEINFO_CACHE_FILE=absolute path of the file underlying the cache object
#SYSTEM_CACHEINFO_CACHE_LENGTH=length of the cache object's row data array
SYSTEM_CACHEINFO_MAX_CACHE_COUNT=maximum number of rows that will be buffered in memory by this cache
SYSTEM_CACHEINFO_MAX_CACHE_BYTES=approximate maximum size, in bytes, of row data that will be buffered in memory by this cache
SYSTEM_CACHEINFO_CACHE_SIZE=number of rows currently cached
SYSTEM_CACHEINFO_CACHE_BYTES=approximate number of row data bytes currently cached
SYSTEM_CACHEINFO_FILE_FREE_BYTES=aggregate size, in octets, of all allocation units considered available for reuse
#SYSTEM_CACHEINFO_SMALLEST_FREE_ITEM=size, in octets, of smallest allocation unit available for reuse
#SYSTEM_CACHEINFO_LARGEST_FREE_ITEM=size, in octets, of largest allocation unit available for reuse
SYSTEM_CACHEINFO_FILE_FREE_COUNT=number of allocation units available for reuse
SYSTEM_CACHEINFO_FILE_FREE_POS=one greater than largest file position known to be allocated
#SYSTEM_CACHEINFO_MAX_CACHE_SIZE=maximum allowable number of cached Row objects
#SYSTEM_CACHEINFO_MAX_CACHE_BYTE_SIZE=limit on memory consumption of cached Row objects
#SYSTEM_CACHEINFO_MULTIPLIER_MASK=binary mask used to calculate indices into row data array
#SYSTEM_CACHEINFO_WRITER_LENGTH=length of row write buffer array
# SYSTEM_CATALOGS
SYSTEM_CATALOGS_TABLE_CAT=catalog name
# SYSTEM_CLASSPRIVILEGES
SYSTEM_CLASSPRIVILEGES_CLASS_CAT=catalog in which the class is defined
SYSTEM_CLASSPRIVILEGES_CLASS_SCHEM=schema in which the class is defined
SYSTEM_CLASSPRIVILEGES_CLASS_NAME=fully qualified name of class
SYSTEM_CLASSPRIVILEGES_GRANTOR=grantor of access
SYSTEM_CLASSPRIVILEGES_GRANTEE=grantee of access
SYSTEM_CLASSPRIVILEGES_PRIVILEGE=name of access, e.g. one of { "EXECUTE" (callable routines) | "FIRE" (fireable trigger body implementations)}
SYSTEM_CLASSPRIVILEGES_IS_GRANTABLE=grantable?: "YES" - may grant to others, "NO" - not permitted to grant to others, NULL - unknown
# SYSTEM_COLUMNPRIVILEGES
SYSTEM_COLUMNPRIVILEGES_TABLE_CAT=catalog in which the table containing the column is defined
SYSTEM_COLUMNPRIVILEGES_TABLE_SCHEM=schema in which the table containing the column is defined
SYSTEM_COLUMNPRIVILEGES_TABLE_NAME=simple name of the table containing the column is defined
SYSTEM_COLUMNPRIVILEGES_COLUMN_NAME=simple name of the column
SYSTEM_COLUMNPRIVILEGES_GRANTOR=grantor of access
SYSTEM_COLUMNPRIVILEGES_GRANTEE=grantee of access
SYSTEM_COLUMNPRIVILEGES_PRIVILEGE=name of access, e.g. one of { ALL, SELECT, INSERT, UPDATE, DELETE, ...}
SYSTEM_COLUMNPRIVILEGES_IS_GRANTABLE=grantable?: YES - may grant to others, NO - not permitted to grant to others, NULL - unknown
# SYSTEM_COLUMNS
SYSTEM_COLUMNS_TABLE_CAT=catalog in which the table containing the column is defined
SYSTEM_COLUMNS_TABLE_SCHEM=schema in which the table containing the column is defined
SYSTEM_COLUMNS_TABLE_NAME=simple name of the table containing the column
SYSTEM_COLUMNS_COLUMN_NAME=simple name of the column
SYSTEM_COLUMNS_DATA_TYPE=SQL data type.  This may be a java.sql.Types data type, a SQL 200n data type or an HSQLDB-specific data type.  For datetime or interval data types, this column returns the concise data type (such as SQL_璗YPE_璗IME or SQL_璉NTERVAL_璝EAR_璗O_璏ONTH).
SYSTEM_COLUMNS_TYPE_NAME=the HSQLDB-specific data type name; this is the canonical name used in CREATE TABLE and ALTER TABLE statements.
SYSTEM_COLUMNS_COLUMN_SIZE=precision for number types; length for sized types; NULL if not applicable
SYSTEM_COLUMNS_BUFFER_LENGTH=The maximum length in bytes of data, if definitely known, that would be transferred to a buffer on a fetch operation.  For numeric data, this size may be different than the size of the data stored on the data source.  This value is the same as the COLUMN_SIZE column for binary data. This value is the twice the COLUMN_SIZE column for character data.  If the actual value is larger than can be represented in an INTEGER column value, this is NULL.
SYSTEM_COLUMNS_DECIMAL_DIGITS=# of fractional digits (scale) for number types
SYSTEM_COLUMNS_NUM_PREC_RADIX=Radix of reported numeric precision (i.e. base of number types)
SYSTEM_COLUMNS_NULLABLE=is NULL allowed?: { columnNoNulls (maybe not), columnNullable (definitely), columnNullableUnknown }
SYSTEM_COLUMNS_REMARKS=explanitory comment describing the column (may be NULL)
SYSTEM_COLUMNS_COLUMN_DEF=default value (may be NULL)
SYSTEM_COLUMNS_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_COLUMNS_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_COLUMNS_CHAR_OCTET_LENGTH=for char types, the maximum number of bytes in the column, if the value can be represented as an INTEGER column value, else NULL
SYSTEM_COLUMNS_ORDINAL_POSITION=index of column in table (starting at 1)
SYSTEM_COLUMNS_IS_NULLABLE=is column nullable?: { YES (might allow) | NO (definitely not)  | '' (unknown) }
SYSTEM_COLUMNS_SCOPE_CATLOG=catalog of table that is the scope of a reference attribute (NULL if DATA_TYPE isn't REF)
SYSTEM_COLUMNS_SCOPE_SCHEMA=schema of table that is the scope of a reference attribute (NULL if the DATA_TYPE isn't REF)
SYSTEM_COLUMNS_SCOPE_TABLE=table name that this the scope of a reference attribute (NULL if the DATA_TYPE isn't REF)
SYSTEM_COLUMNS_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_COLUMNS_TYPE_SUB=the HSQLDB-specific type subidentifier (1:default, 2:identity, 4:ignorecase)
# SYSTEM_CROSSREFERENCE
SYSTEM_CROSSREFERENCE_PKTABLE_CAT=the catalog in which the referenced table is defined
SYSTEM_CROSSREFERENCE_PKTABLE_SCHEM=the schema in which the referenced table is defined
SYSTEM_CROSSREFERENCE_PKTABLE_NAME=simple name of the referenced table
SYSTEM_CROSSREFERENCE_PKCOLUMN_NAME=simple name of the referenced column
SYSTEM_CROSSREFERENCE_FKTABLE_CAT=the catalog in which the referencing table is defined
SYSTEM_CROSSREFERENCE_FKTABLE_SCHEM=the schema in which the referencing table is defined
SYSTEM_CROSSREFERENCE_FKTABLE_NAME=the simple name of the referencing table
SYSTEM_CROSSREFERENCE_FKCOLUMN_NAME=the simple name of the referencing column
SYSTEM_CROSSREFERENCE_KEY_SEQ=sequence number within foreign key definition
SYSTEM_CROSSREFERENCE_UPDATE_RULE=how does an update of referenced row columns affect referencing rows?: e.g. { Cascade | Set Null | Set Default | Restrict (No Action) }
SYSTEM_CROSSREFERENCE_DELETE_RULE=how does deletion of a referenced row affect referencing rows?: e.g. { Cascade | Set Null | Set Default | Restrict (No Action) }
SYSTEM_CROSSREFERENCE_FK_NAME=the name of the foreign key
SYSTEM_CROSSREFERENCE_PK_NAME=the name of the referenced column set (usually the name of a primary key constraint, but may be a unique constraint or even the name of a non-unique index previous to 1.7.0)
SYSTEM_CROSSREFERENCE_DEFERRABILITY=foreign key constraints deferred until commit?: e.g. { initially deferred | initially immediate | not deferrable }
# SYSTEM_INDEXINFO
SYSTEM_INDEXINFO_TABLE_CAT=catalog in which the table using the index is defined
SYSTEM_INDEXINFO_TABLE_SCHEM=schema in which the table using the index is defined
SYSTEM_INDEXINFO_TABLE_NAME=simple name of the table using the index
SYSTEM_INDEXINFO_NON_UNIQUE=can index values be non-unique?
SYSTEM_INDEXINFO_INDEX_QUALIFIER=catalog in which the index is defined
SYSTEM_INDEXINFO_INDEX_NAME=simple name of the index
SYSTEM_INDEXINFO_TYPE=index type: e.g. { Clustered | Hashed | Other }
SYSTEM_INDEXINFO_ORDINAL_POSITION=column sequence number within index
SYSTEM_INDEXINFO_COLUMN_NAME=simple column name
SYSTEM_INDEXINFO_ASC_OR_DESC=column sort sequence: e.g. { "A" (Ascending) | "D" (Descending) }
SYSTEM_INDEXINFO_CARDINALITY=index cardinality: # of unique values in the index (currently unused)
SYSTEM_INDEXINFO_PAGES=index page use (currently unused)
SYSTEM_INDEXINFO_FILTER_CONDITION=filter condition, if any (currently unused)