HUABASE supports the following data types.docx
《HUABASE supports the following data types.docx》由会员分享，可在线阅读，更多相关《HUABASE supports the following data types.docx（20页珍藏版）》请在冰点文库上搜索。
HUABASEsupportsthefollowingdatatypes
HUABASEsupportsthefollowingdatatypes:
INTEGER
BOOLEAN
REAL/FLOAT
DOUBLE
DATE
TIME
TIMESTAMP
BLOB
COB
CHAR（0-2000）
VARCHAR（0-2000）
BINARY（0-4000）
VARBINARY（0-4000）
LONGVARCHAR
LONGVARBINARY
NUMERIC
DEF-SCHEMA-TABLEDEF_SCHEMA_USERS
COLUMNS:
USER_IDINTEGER
USER_NAMEVARCHAR（128）
PASSWORDVARCHAR（128）
USER_TYPECHAR
（1）
PRIMARY_KEY:
USER_ID
DEF-SCHEMA-TABLEDEF_SCHEMA_TABLE_SPACES
COLUMNS:
TABLE_SPACE_IDINTEGER
TABLE_SPACE_NAMEVARCHAR（128）
META_DATA_BLOCK_IDLONG
PRIMARY_KEY:
TABLE_SPACE_ID
DEF-SCHEMA-TABLEDEF_SDEF-SCHEMA-TABLECHEMA_DATA_FILES
COLUMNS:
TABLE_SPACE_IDINTEGER
FILE_INDEXINTEGER
FILE_PATHVARCHAR（512）
INI_CAPACITYVARCHAR（128）
INC_CAPACITYVARCHAR（128）
MAX_CAPACITYVARCHAR（128）
PRIMARY_KEY:
TABLE_SPACE_ID
FILE_INDEX
FOREIGN_KEY:
tableSpaceIdFk
TABLE_SPACE_ID
references
DEF_SCHEMA_TABLE_SPACES
DEF-SCHEMA-TABLEDEF_SCHEMA_SCHEMAS
COLUMNS:
SCHEMA_IDINTEGER
SCHEMA_NAMEVARCHAR（128）
USER_IDINTEGER
TABLE_SPACE_IDINTEGER
META_DATA_BLOCK_IDLONG
PRIMARY_KEY:
SCHEMA_ID
FOREIGN_KEY:
userIdFk
USER_ID
references
DEF_SCHEMA_USERS
FOREIGN_KEY:
tableSpaceIdFk
TABLE_SPACE_ID
references
DEF_SCHEMA_TABLE_SPACES
DEF-SCHEMA-TABLEDEF_SCHEMA_DOMAINS
COLUMNS:
SCHEMA_IDINTEGER
DOMAIN_IDINTEGER
DOMAIN_NAMEVARCHAR（128）
DOMAIN_DATA_TYPEVARBINARY（1024）
DOMAIN_DEFAULTVARBINARY（1024）
PRIMARY_KEY:
SCHEMA_ID
DOMAIN_ID
FOREIGN_KEY:
schemaIdFk
SCHEMA_ID
references
DEF_SCHEMA_SCHEMAS
DEF-SCHEMA-TABLEDEF_SCHEMA_TABLES
COLUMNS:
SCHEMA_IDINTEGER
TABLE_IDINTEGER
TABLE_NAMEVARCHAR（128）
COLUMN_IDINTEGER
PRIMARY_KEY:
SCHEMA_ID
TABLE_ID
FOREIGN_KEY:
schemaIdFk
SCHEMA_ID
references
DEF_SCHEMA_SCHEMAS
DEF-SCHEMA-TABLEDEF_SCHEMA_TABLE_PARTITIONS
COLUMNS:
SCHEMA_IDINTEGER
TABLE_IDINTEGER
PARTITION_IDINTEGER
PARTITION_NAMEVARCHAR（128）
PARTITION_RULEVARBINARY（1024）
TABLE_SPACE_IDINTEGER
PRIMARY_KEY:
SCHEMA_ID
TABLE_ID
PARTITION_ID
FOREIGN_KEY:
tableIdFk
SCHEMA_ID
TABLE_ID
references
DEF_SCHEMA_TABLES
FOREIGN_KEY:
tableSpaceIdFk
TABLE_SPACE_ID
references
DEF_SCHEMA_TABLE_SPACES
DEF-SCHEMA-TABLEDEF_SCHEMA_TABLE_PARTITION_SEGMENTS
COLUMNS:
SCHEMA_IDINTEGER
TABLE_IDINTEGER
PARTITION_IDINTEGER
SEGMENT_IDINTEGER
META_DATA_BLOCK_IDLONG
PRIMARY_KEY:
SCHEMA_ID
TABLE_ID
PARTITION_ID
SEGMENT_ID
FOREIGN_KEY:
partitionNameFk
SCHEMA_ID
TABLE_ID
PARTITION_ID
references
DEF_SCHEMA_TABLE_PARTITIONS
DEF-SCHEMA-TABLEDEF_SCHEMA_VIEWS
COLUMNS:
SCHEMA_IDINTEGER
VIEW_IDINTEGER
VIEW_NAMEVARCHAR（128）
VIEW_DEFINITION_TXTCLOB
VIEW_DEFINITION_BINBLOB
CHECK_OPTIONCHAR
（1）
PRIMARY_KEY:
SCHEMA_ID
VIEW_ID
FOREIGN_KEY:
schemaIdFk
SCHEMA_ID
references
DEF_SCHEMA_SCHEMAS
DEF-SCHEMA-TABLEDEF_SCHEMA_COLUMNS
COLUMNS:
SCHEMA_IDINTEGER
TABLE_IDINTEGER
COLUMN_IDINTEGER
COLUMN_NAMEVARCHAR（128）
DOMAIN_IDINTEGER
IS_SORT_INDEXBOOLEAN
COLUMN_DEFAULTVARBINARY（1024）
IS_NULLABLEBOOLEAN
IS_AUTO_INCREMENTBOOLEAN
PRIMARY_KEY:
SCHEMA_ID
TABLE_ID
COLUMN_ID
FOREIGN_KEY:
tableIdFk
SCHEMA_ID
TABLE_ID
references
DEF_SCHEMA_TABLES
FOREIGN_KEY:
domainIdFk
SCHEMA_ID
DOMAIN_ID
references
DEF_SCHEMA_DOMAINS
DEF-SCHEMA-TABLEDEF_SCHEMA_TABLE_PARTITION_SEGMENT_COLUMNS
COLUMNS:
SCHEMA_IDINTEGER
TABLE_IDINTEGER
PARTITION_IDINTEGER
SEGMENT_IDINTEGER
COLUMN_IDINTEGER
VALUE_INDEX_META_DATA_BLOCK_IDLONG
LINK_INDEX_META_DATA_BLOCK_IDLONG
META_DATA_BLOCK_IDLONG
PRIMARY_KEY:
SCHEMA_ID
TABLE_ID
PARTITION_ID
SEGMENT_ID
COLUMN_ID
FOREIGN_KEY:
partitionSegmentIdFk
SCHEMA_ID
TABLE_ID
PARTITION_ID
SEGMENT_ID
references
DEF_SCHEMA_TABLE_PARTITION_SEGMENTS
FOREIGN_KEY:
columnIdFk
SCHEMA_ID
TABLE_ID
COLUMN_ID
references
DEF_SCHEMA_COLUMNS
DEF-SCHEMA-TABLEDEF_SCHEMA_VIEW_TABLE_USAGES
COLUMNS:
SCHEMA_IDINTEGER
VIEW_IDINTEGER
TABLE_IDINTEGER
PRIMARY_KEY:
SCHEMA_ID
VIEW_ID
TABLE_ID
FOREIGN_KEY:
tableIdFk
SCHEMA_ID
TABLE_ID
references
DEF_SCHEMA_TABLES
DEF-SCHEMA-TABLEDEF_SCHEMA_VIEW_COLUMN_USAGES
COLUMNS:
SCHEMA_IDINTEGER
VIEW_IDINTEGER
TABLE_IDINTEGER
COLUMN_IDINTEGER
PRIMARY_KEY:
SCHEMA_ID
VIEW_ID
TABLE_ID
COLUMN_ID
FOREIGN_KEY:
viewIdFk
SCHEMA_ID
VIEW_ID
references
DEF_SCHEMA_VIEWS
FOREIGN_KEY:
columnIdFk
SCHEMA_ID
TABLE_ID
COLUMN_ID
references
DEF_SCHEMA_COLUMNS
DEF-SCHEMA-TABLEDEF_SCHEMA_KEY_TABLE_CONSTRAINTS
COLUMNS:
SCHEMA_IDINTEGER
TABLE_IDINTEGER
CONSTRAINT_IDINTEGER
CONSTRAINT_NAMEVARCHAR（128）
KEY_TYPECHAR
（1）
IS_DEFERRABLEBOOLEAN
INITIALLY_DEFERREDBOOLEAN
PRIMARY_KEY:
SCHEMA_ID
TABLE_ID
CONSTRAINT_ID
FOREIGN_KEY:
tableIdFk
SCHEMA_ID
TABLE_ID
references
DEF_SCHEMA_TABLES
DEF-SCHEMA-TABLEDEF_SCHEMA_CHECK_TABLE_CONSTRAINTS
COLUMNS:
SCHEMA_IDINTEGER
TABLE_IDINTEGER
CONSTRAINT_IDINTEGER
CONSTRAINT_NAMEVARCHAR（128）
CHECK_CLAUSEVARBINARY（1024）
IS_DEFERRABLEBOOLEAN
INITIALLY_DEFERREDBOOLEAN
PRIMARY_KEY:
SCHEMA_ID
TABLE_ID
CONSTRAINT_ID
FOREIGN_KEY:
tableIdFk
SCHEMA_ID
TABLE_ID
references
DEF_SCHEMA_TABLES
DEF-SCHEMA-TABLEDEF_SCHEMA_KEY_COLUMN_USAGES
COLUMNS:
SCHEMA_IDINTEGER
TABLE_IDINTEGER
CONSTRAINT_IDINTEGER
COLUMN_IDINTEGER
PRIMARY_KEY:
SCHEMA_ID
TABLE_ID
CONSTRAINT_ID
COLUMN_ID
FOREIGN_KEY:
columnIdFk
SCHEMA_ID
TABLE_ID
COLUMN_ID
references
DEF_SCHEMA_COLUMNS
FOREIGN_KEY:
constraintNameFk
SCHEMA_ID
TABLE_ID
CONSTRAINT_ID
references
DEF_SCHEMA_KEY_TABLE_CONSTRAINTS
DEF-SCHEMA-TABLEDEF_SCHEMA_REFERENTIAL_CONSTRAINTS
COLUMNS:
SCHEMA_IDINTEGER
TABLE_IDINTEGER
CONSTRAINT_IDINTEGER
CONSTRAINT_NAMEVARCHAR（128）
REF_TABLE_IDINTEGER
REF_UNIQUE_CONSTRAINT_IDINTEGER
MATCH_OPTIONCHAR
（1）
UPDATE_RULECHAR
（1）
DELETE_RULECHAR
（1）
PRIMARY_KEY:
SCHEMA_ID
TABLE_ID
CONSTRAINT_ID
FOREIGN_KEY:
uniqueConstraintIdFk
SCHEMA_ID
REF_TABLE_ID
REF_UNIQUE_CONSTRAINT_ID
references
DEF_SCHEMA_KEY_TABLE_CONSTRAINTS
DEF-SCHEMA-TABLEDEF_SCHEMA_CHECK_COLUMN_CONSTRAINTS
COLUMNS:
SCHEMA_IDINTEGER
TABLE_IDINTEGER
COLUMN_IDINTEGER
CONSTRAINT_IDINTEGER
CONSTRAINT_NAMEVARCHAR（128）
CHECK_CLAUSEVARBINARY（1024）
IS_DEFERRABLEBOOLEAN
INITIALLY_DEFERREDBOOLEAN
PRIMARY_KEY:
SCHEMA_ID
TABLE_ID
COLUMN_ID
CONSTRAINT_ID
FOREIGN_KEY:
tableIdFk
SCHEMA_ID
TABLE_ID
COLUMN_ID
references
DEF_SCHEMA_COLUMNS
DEF-SCHEMA-TABLEDEF_SCHEMA_CHECK_DOMAIN_CONSTRAINTS
COLUMNS:
SCHEMA_IDINTEGER
DOMAIN_IDINTEGER
CONSTRAINT_IDINTEGER
CONSTRAINT_NAMEVARCHAR（128）
CHECK_CLAUSEVARBINARY（1024）
IS_DEFERRABLEBOOLEAN
INITIALLY_DEFERREDBOOLEAN
PRIMARY_KEY:
SCHEMA_ID
DOMAIN_ID
CONSTRAINT_ID
FOREIGN_KEY:
tableIdFk
SCHEMA_ID
DOMAIN_ID
references
DEF_SCHEMA_DOMAINS
DEF-SCHEMA-TABLEDEF_SCHEMA_CHECK_CONSTRAINTS
COLUMNS:
SCHEMA_IDINTEGER
CONSTRAINT_IDINTEGER
CHECK_CLAUSEVARBINARY（1024）
PRIMARY_KEY:
SCHEMA_ID
CONSTRAINT_ID
FOREIGN_KEY:
schemaIdFk
SCHEMA_ID
references
DEF_SCHEMA_SCHEMAS
DEF-SCHEMA-TABLEDEF_SCHEMA_CHECK_TABLE_USAGES
COLUMNS:
SCHEMA_IDINTEGER
CONSTRAINT_IDINTEGER
TABLE_IDINTEGER
PRIMARY_KEY:
SCHEMA_ID
CONSTRAINT_ID
TABLE_ID
FOREIGN_KEY:
constraintIdFk
SCHEMA_ID
CONSTRAINT_ID
references
DEF_SCHEMA_CHECK_CONSTRAINTS
FOREIGN_KEY:
tableIdFk
SCHEMA_ID
TABLE_ID
references
DEF_SCHEMA_TABLES
DEF-SCHEMA-TABLEDEF_SCHEMA_CHECK_COLUMN_USAGES
COLUMNS:
SCHEMA_IDINTEGER
CONSTRAINT_IDINTEGER
TABLE_IDINTEGER
COLUMN_IDINTEGER
PRIMARY_KEY:
SCHEMA_ID
CONSTRAINT_ID
TABLE_ID
COLUMN_ID
FOREIGN_KEY:
constraintIdFk
SCHEMA_ID
CONSTRAINT_ID
references
DEF_SCHEMA_CHECK_CONSTRAINTS
FOREIGN_KEY:
columnNameFk
SCHEMA_ID
TABLE_ID
COLUMN_ID
references
DEF_SCHEMA_COLUMNS
DEF-SCHEMA-TABLEDEF_SCHEMA_ASSERTONS
COLUMNS:
SCHEMA_IDINTEGER
CONSTRAINT_IDINTEGER
IS_DEFERRABLEBOOLEAN
INITIALLY_DEFERREDBOOLEAN
PRIMARY_KEY:
SCHEMA_ID
CONSTRAINT_ID
FOREIGN_KEY:
constrainIdFk
SCHEMA_ID
CONSTRAINT_ID
references
DEF_SCHEMA_CHECK_CONSTRAINTS
DEF-SCHEMA-TABLEDEF_SCHEMA_TABLE_PRIVILEGES
COLUMNS:
GRANTORINTEGER
GRANTEEINTEGER
SCHEMA_IDINTEGER
TABLE_IDINTEGER
PRIVILEGE_TYPECHAR
（1）//'SELECT','INSERT','DELETE','UPDATE'
'REFERENCES'
IS_GRANTABLEBOOLEAN
PRIMARY_KEY:
GRANTOR
GRANTEE
SCHEMA_ID
TABLE_ID
PRIVILEGE_TYPE
FOREIGN_KEY:
tableIdFk
SCHEMA_ID
TABLE_ID
references
DEF_SCHEMA_TABLES
FOREIGN_KEY:
grantorFk
GRANTOR
references
DEF_SCHEMA_USERS
FOREIGN_KEY:
granteeFk
GRANTEE
references
DEF_SCHEMA_USERS
DEF-SCHEMA-TABLEDEF_SCHEMA_COLUMN_PRIVILEGES
COLUMNS:
GRANTORINTEGER
GRANTEEINTEGER
SCHEMA_IDINTEGER
TABLE_IDINTEGER
COLUMN_IDINTEGER
PRIVILEGE_TYPEVARCHAR（128）
IS_GRANTABLEBOOLEAN
PRIMARY_KEY:
GRANTOR
GRANTEE
SCHEMA_ID
TABLE_ID
COLUMN_ID
PRIVILEGE_TYPE
FOREIGN_KEY:
columnIdFk
SCHEMA_ID
TABLE_ID
COLUMN_ID
references
DEF_SCHEMA_COLUMNS
FOREIGN_KEY:
grantorFk
GRANTOR
references
DEF_SCHEMA_USERS
FOREIGN_KEY:
granteeFk
GRANTEE
references
DEF_SCHEMA_USERS
DEF-SCHEMA-TABLEDEF_SCHEMA_COLUMN_SEQUENCES
COLUMNS:
SCHEMA_IDINTEGER
TABLE_IDINTEGER
COLUMN_IDINTEGER
SEQUENCE_IDLONG
PRIMARY_KEY:
SCHEMA_ID
TABLE_ID
COLUMN_ID
SEQUENCE_ID
FOREIGN_KEY:
columnIdFk
SCHEMA_ID
TABLE_ID
COLUMN_ID
references
DEF_SCHEMA_COLUMNS
DEF-SCHEMA-TABLEDEF_SCHEMA_SEQUENCES
COLUMNS:
SEQUENCE_IDLONG
SEQUENCE_NAMEVARCHAR（128）
SEQUENCE_CACHEINTEGER
SEQUENCE_DATA_BLOCK_IDLONG
PRIMARY_KEY:
SEQUENCE_ID
升级会员 