Column | TDV JDBC Data Type | Nullable | Description |
PROCEDURE_ID | INTEGER | Identifier of the procedure. Primary key. | |
PROCEDURE_NAME | VARCHAR(255) | Name of the procedure. | |
PROCEDURE_TYPE | SMALLINT | Procedure type. Possible values: 1—A relational data source. 2—A WSDL type of data source. 3—A flat file. 4—The workspace. 5—An LDAP data source. | |
BD_PROCEDURE_TYPE | CHAR | BD type of the procedure. | |
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. | |
SITE_NAME | VARCHAR | Name of the site. | |
GUID | VARCHAR(36) | Nearly unique 128-bit identifier. | |
ANNOTATION | VARCHAR(2147483647) | Annotation for the procedure. | |
OWNER_ID | INTEGER | Identifier of the person who created or owns the procedure. | |
OWNER | VARCHAR(255) | User name of the person who created or owns the procedure. | |
PARENT_PATH | VARCHAR(787) | Path to the parent container. | |
BD_PARENT_PATH | VARCHAR | BD path to the parent container. | |
PROCEDURE_CREATOR_ID | INTEGER | Identifier of the user who created this procedure. Same as USER_ID in ALL_USERS. | |
PROCEDURE_ CREATION_TIMESTAMP | BIGINT | Timestamp when the procedure was created. | |
PROCEDURE_MODIFIER_ID | INTEGER | Identifier of the user who last modified this procedure. Same as USER_ID in ALL_USERS. | |
PROCEDURE_ MODIFICATION_TIMESTAMP | BIGINT | Timestamp when the procedure was modified. | |
LAST_MODIFICATION_ TIMESTAMP | BIGINT | Timestamp when the procedure was last modified. |