Table Name
CAT_USERS
Table Description
Contains a list of Data Vault users.
Table Columns
NAME: VARCHAR (128), nullable
PASSWORD: VARCHAR (128), nullable
PASSWORDCHANGE: TIMESTAMP, nullable
UID: INTEGER, not null
ROLE: CHAR (1), nullable
DEFAULTDB: INTEGER, nullable
DEFAULTSCHEMA: INTEGER, nullable
CREATOR: INTEGER, nullable
CREATED: TIMESTAMP, nullable
ALTERED: TIMESTAMP, nullable
CONSTRAINT CAT_USERS_PK: Primary key (UID)
Table Name
CAT_DATABASES
Table Description
Contains a list of databases in Data Vault.
Table Columns
NAME: VARCHAR (256), nullable
DBID: INTEGER, not null
CREATOR: INTEGER, nullable
CREATED: TIMESTAMP, nullable
ALTERED: TIMESTAMP, nullable
CONSTRAINT CAT_DATABASES_FK1: Foreign key (CREATOR), references CAT_USERS (UID)
CONSTRAINT CAT_DATABASES_PK: Primary key (DBID)
Table Name
CAT_SCHEMAS
Table Description
Contains a list of schemas in Data Vault.
Table Columns
NAME: VARCHAR (256), nullable
SCHID: INTEGER, not null
DBID: INTEGER, nullable
CREATOR: INTEGER, nullable
CREATED: TIMESTAMP, nullable
ALTERED: TIMESTAMP, nullable
CONSTRAINT CAT_SCHEMAS_FK1: Foreign key (CREATOR), references CAT_USERS (UID)
CONSTRAINT CAT_SCHEMAS_PK: Primary key (SCHID)
Table Name
CAT_TABLES
Table Description
Contains a list of tables in Data Vault.
Table Columns
NAME: VARCHAR (256), nullable
TID: INTEGER, not null
TABLETYPE: CHAR (1), nullable
ARCHIVETYPE: CHAR (1), nullable
COMMENTS: VARCHAR (1024), nullable
DBID: INTEGER, nullable
SCHID: INTEGER, nullable
CREATOR: INTEGER, nullable
CREATED: TIMESTAMP, nullable
ALTERED: TIMESTAMP, nullable
CONSTRAINT CAT_TABLES_FK1: Foreign key (CREATOR), references CAT_USERS (UID)
CONSTRAINT CAT_TABLES_PK: Primary key (TID)
Table Name
CAT_DOMAINS
Table Description
Contains a list of domains in Data Vault.
Table Columns
NAME: VARCHAR (256), nullable
DOMID: INTEGER, not null
DBID: INTEGER, nullable
SCHID: INTEGER, nullable
CREATOR: INTEGER, nullable
DATATYPE: INTEGER, nullable
PREC: INTEGER, nullable
SCALE: INTEGER, nullable
CREATED: TIMESTAMP, nullable
ALTERED: TIMESTAMP, nullable
CONSTRAINT CAT_DOMAINS_FK1: Foreign key (CREATOR), references CAT_USERS (UID)
CONSTRAINT CAT_DOMAINS_FK2: Foreign key (DBID), references CAT_DATABASES (DBID)
CONSTRAINT CAT_DOMAINS_FK3: Foreign key (SCHID), references CAT_SCHEMAS (SCHID)
CONSTRAINT CAT_DOMAINS_PK: Primary key (DOMID)
Table Name
CAT_COLUMNS
Table Description
Contains a list of columns in Data Vault.
Table Columns
NAME: VARCHAR (256), nullable
COLNO: INTEGER, not null
FLAG: CHAR (1), nullable
NULLFLAG: CHAR (1), nullable
TID: INTEGER, not null
DOMID: INTEGER, nullable
CREATED: TIMESTAMP, nullable
ALTERED: TIMESTAMP, nullable
CONSTRAINT CAT_COLUMNS_FK1: Foreign key (TID), references CAT_TABLES (TID)
CONSTRAINT CAT_COLUMNS_FK2: Foreign key (DOMID), references CAT_DOMAINS (DOMID)
CONSTRAINT CAT_COLUMNS_PK: Primary key (TID, COLNO)
Table Name
CAT_DATATYPES
Table Description
Contains a list of datatypes in Data Vault.
Table Columns
DATATYPE: INTEGER, nullable
NAME: VARCHAR (9), nullable
MAX_LENGTH: DECIMAL (18, 0), nullable
MAX_SCALE: INTEGER, nullable
Table Name
CAT_VIEWS
Table Description
Contains a list of views in Data Vault.
Table Columns
NAME: VARCHAR (256), nullable
VWID: INTEGER, not null
DBID: INTEGER, nullable
SCHID: INTEGER, nullable
CREATOR: INTEGER, nullable
TYPE: CHAR (1), nullable
QUERYTYPE: CHAR (1), nullable
STATE: CHAR (1), nullable
CREATED: TIMESTAMP, nullable
ALTERED: TIMESTAMP, nullable
CONSTRAINT CAT_VIEWS_FK1: Foreign key (DBID), references CAT_DATABASES (DBID)
CONSTRAINT CAT_VIEWS_FK2: Foreign key (SCHID), references CAT_SCHEMAS (SCHID)
CONSTRAINT CAT_VIEWS_FK3: Foreign key (VWID), references CAT_TABLES (TID)
CONSTRAINT CAT_VIEWS_FK4: Foreign key (CREATOR), references CAT_USERS (UID)
CONSTRAINT CAT_VIEWS_PK: Primary key (VWID)
Table Name
CAT_DATABASE_PRIVS
Table Description
Contains a list of privileges at the database level in Data Vault.
Table Columns
GRANTOR: INTEGER, nullable
GRANTEE: INTEGER, nullable
DBID: INTEGER, nullable
PRIVILEGE: CHAR (1), nullable
GRANTABLE: CHAR (1), nullable
CREATED: TIMESTAMP, nullable
CONSTRAINT CAT_DATABASE_PRIVS_FK1: Foreign key (DBID), references CAT_DATABASES (DBID)
CONSTRAINT CAT_DATABASE_PRIVS_FK2: Foreign key (GRANTOR), references CAT_USERS (UID)
CONSTRAINT CAT_DATABASE_PRIVS_FK3: Foreign key (GRANTEE), references CAT_USERS (UID)
Table Name
CAT_SCHEMA_PRIVS
Table Description
Contains a list of privileges at the schema level in Data Vault.
Table Columns
GRANTOR: INTEGER, nullable
GRANTEE: INTEGER, nullable
SCHID: INTEGER, nullable
PRIVILEGE: CHAR (1), nullable
GRANTABLE: CHAR (1), nullable
CREATED: TIMESTAMP, nullable
CONSTRAINT CAT_SCHEMA_PRIVS_FK1: Foreign key (SCHID), references CAT_SCHEMAS (SCHID)
CONSTRAINT CAT_SCHEMA_PRIVS_FK2: Foreign key (GRANTOR), references CAT_USERS (UID)
CONSTRAINT CAT_SCHEMA_PRIVS_FK3: Foreign key (GRANTEE), references CAT_USERS (UID)
Table Name
CAT_TABLE_PRIVS
Table Description
Contains a list of privileges at the table level in Data Vault.
Table Columns
GRANTOR: INTEGER, nullable
GRANTEE: INTEGER, nullable
TID: INTEGER, nullable
PRIVILEGE: CHAR (1), nullable
GRANTABLE: CHAR (1), nullable
CREATED: TIMESTAMP, nullable
CONSTRAINT CAT_TABLE_PRIVS_FK1: Foreign key (TID), references CAT_TABLES (TID)
CONSTRAINT CAT_TABLE_PRIVS_FK2: Foreign key (GRANTOR), references CAT_USERS (UID)
CONSTRAINT CAT_TABLE_PRIVS_FK3: Foreign key (GRANTEE) , references CAT_USERS (UID)
Table Name
CAT_COLUMN_PRIVS
Table Description
Contains a list of privileges at the column level in Data Vault.
Table Columns
GRANTOR: INTEGER, nullable
GRANTEE: INTEGER, nullable
TID: INTEGER, nullable
COLNO: INTEGER, nullable
PRIVILEGE: CHAR (1), nullable
GRANTABLE: CHAR (1), nullable
CREATED: TIMESTAMP, nullable
CONSTRAINT CAT_COLUMN_PRIVS_FK1: Foreign key (TID, COLNO), references CAT_COLUMNS (TID, COLNO)
CONSTRAINT CAT_COLUMN_PRIVS_FK2: Foreign key (GRANTOR), references CAT_USERS (UID)
CONSTRAINT CAT_COLUMN_PRIVS_FK3: Foreign key (GRANTEE), references CAT_USERS (UID)
