HUABASE supports the following data types.docx
- 文档编号:3502507
- 上传时间:2023-05-05
- 格式:DOCX
- 页数:20
- 大小:15.14KB
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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- HUABASE supports the following data types