Column | TDV JDBC Data Type | Nullable | Description |
TABLE_ID | INTEGER | Identifier of the table. Primary key. | |
TABLE_NAME | VARCHAR(255) | Name of the table. | |
TABLE_TYPE | VARCHAR(24) | Data type of the table. | |
BD_TABLE_TYPE | VARCHAR(24) | BD table type. | |
SCHEMA_ID | INTEGER | Yes | Identifier of the schema. |
SCHEMA_NAME | VARCHAR(255) | Yes | Name of the schema. |
CATALOG_ID | INTEGER | Yes | Identifier of the catalog. |
CATALOG_NAME | VARCHAR(255) | Yes | Name of the catalog. |
DATASOURCE_ID | INTEGER | Identifier of the data source. | |
DATASOURCE_NAME | VARCHAR(255) | Name of the data source. | |
BD_DATASOURCE_NAME | VARCHAR(255) | BD name of the data source. | |
GUID | VARCHAR(36) | Nearly unique 128-bit identifier. (CHAR in BD.) | |
ANNOTATION | VARCHAR(2147483647) | Yes | Annotation for the table. |
OWNER_ID | INTEGER | Identifier of the person who created or owns the table. | |
OWNER | VARCHAR(255) | Name of the person who created or owns the table. | |
PARENT_PATH | VARCHAR(787) | Path to the parent container. | |
BD_PARENT_PATH | VARCHAR(787) | BD path to the parent container. | |
TABLE_CREATOR_ID | INTEGER | Identifier of the user who created this table. Same as USER_ID in 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 ALL_USERS. | |
TABLE_MODIFICATION_ TIMESTAMP | BIGINT | Timestamp when the table was modified. | |
LAST_MODIFICATION_ TIMESTAMP | BIGINT | Timestamp when the table was last modified. |