Column name | TDV JDBC Data Type | Nullable | Description |
TABLE_ID: | INTEGER | Primary key identifier of the table. | |
TABLE_NAME: | VARCHAR | Name of the table. | |
TABLE_TYPE: | VARCHAR | Possible values of this column are ‘VIEW’ and ‘TABLE”. | |
SCHEMA_ID: | INTEGER | Yes | See SCHEMA_ID in Table: model.ALL_SCHEMAS |
SCHEMA_NAME: | VARCHAR | Yes | See SCHEMA_NAME in Table: model.ALL_SCHEMAS |
CATALOG_ID: | INTEGER | Yes | See CATALOG_ID in Table: model.ALL_CATALOGS |
CATALOG_NAME: | VARCHAR | Yes | See CATALOG_NAME in Table: model.ALL_CATALOGS |
DATASOURCE_ID: | INTEGER | See DATASOURCE_ID in Table: model.ALL_DATASOURCES | |
DATASOURCE_NAME: | VARCHAR | See DATASOURCE_NAME in Table: model.ALL_DATASOURCES | |
GUID: | VARCHAR | 128 bit unique identifier | |
ANNOTATION: | VARCHAR | Yes | Annotation for the table. |
OWNER_ID: | INTEGER | Identifier of the person who created/owns the table. Same as USER_ID in Table: ALL_USERS | |
OWNER: | VARCHAR | Name of the person who created/owns the table. Same as USERNAME in Table: ALL_USERS | |
PARENT_PATH: | VARCHAR | Path to the parent container | |
TABLE_CREATOR_ID: | INTEGER | Identifier of the user who created this table. Same as USER_ID in Table: ALL_USERS | |
TABLE_CREATION_TIMESTAMP: | BIGINT | Timestamp when the table was created. | |
TABLE_MODIFIER_ID: | INTEGER | Identifier of the user who last modified this table. Same as USER_ID in Table: ALL_USERS | |
TABLE_MODIFICATION_TIMESTAMP: | BIGINT | Timestamp of the last modification of this table. | |
IMPACT_MESSAGE | VARCHAR | Impact message indicating errors | |
IS_AUTO_GENERATED | VARCHAR | Indicates if the table has an attribute called “webui_model”. If the attribute is present, then the value of this column is 'YES' else it is 'NO’. |
Column name | TDV JDBC Data Type | Nullable | Description |
COLUMN_ID: | INTEGER | Primary key identifier of the column | |
COLUMN_NAME: | VARCHAR | Name of the column | |
DATA_TYPE: | VARCHAR | String representation of the data type | |
ORDINAL_POSITION: | INTEGER | Position of this column in relation to other columns in the same table | |
JDBC_DATA_TYPE: | SMALLINT | JDBC/ODBC data types. For JDBC data types, see http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Types.html | |
COLUMN_LENGTH: | INTEGER | If it is a CHAR or VARCHAR, the length is the maximum length allowed. If it is a DECIMAL or NUMERIC, then the value is the total number of digits. If it is none of the above types, then the value is NULL. | |
COLUMN_PRECISION: | INTEGER | If it is a DECIMAL or NUMERIC data type, then it is the number of digits. If it is not a DECIMAL or NUMERIC data type, then the value is NULL. | |
COLUMN_SCALE: | INTEGER | ||
COLUMN_RADIX: | INTEGER | 10 for all numeric data types. Null for all non-numeric types. | |
NULLABLE: | SMALLINT | Indicates whether the column is nullable 0 if NULL is not allowed 1 if NULL is allowed 2 if it is unknown | |
IS_NULLABLE: | VARCHAR | Indicates whether the column is nullable YES if it is nullable NO if it is not nullable Blank string is returned if value is not known | |
TABLE_ID: | INTEGER | See TABLE_ID in Table: model.ALL_TABLES | |
TABLE_NAME: | VARCHAR | See TABLE_NAME in Table: model.ALL_TABLES | |
SCHEMA_ID: | INTEGER | Yes | See SCHEMA_ID in Table: model.ALL_SCHEMAS |
SCHEMA_NAME: | VARCHAR | Yes | See SCHEMA_NAME in Table: model.ALL_SCHEMAS |
CATALOG_ID: | INTEGER | Yes | See CATALOG_ID in Table: model.ALL_CATALOGS |
CATALOG_NAME: | VARCHAR | See CATALOG_NAME in Table: model.ALL_CATALOGS | |
DATASOURCE_ID: | INTEGER | See DATASOURCE_ID in Table: model.ALL_DATASOURCES | |
DATASOURCE_NAME: | VARCHAR | See DATASOURCE_NAME in Table: model.ALL_DATASOURCES | |
ANNOTATION: | VARCHAR | Yes | Annotation for the column |
OWNER_ID: | INTEGER | Identifier for the user who created/owns the column. Same as USER_ID in Table: ALL_USERS | |
OWNER: | VARCHAR | User name of the person that owns/created the data source. Same as USERNAME in Table: ALL_USERS | |
PARENT_PATH: | VARCHAR | Path to the parent container. |