Column | TDV JDBC Data Type | Nullable | Description |
RELATIONSHIP_ID | INTEGER | Identifier of the relationship. | |
ORDINAL_POSITION | INTEGER | The order in which this column appears in the relationship. | |
FROM_COLUMN_ID | INTEGER | Identifier of the “from” column in the relationship. | |
FROM_COLUMN_NAME | VARCHAR(255) | Name of the “from” column in the relationship. | |
FROM_COLUMN_DATA_TYPE | VARCHAR(255) | Data type of the “from” column in the relationship. | |
FROM_TABLE_ID | INTEGER | Identifier of the “from” table in the relationship. | |
FROM_TABLE_NAME | VARCHAR(255) | Name of the “from” table in the relationship. | |
FROM_SCHEMA_ID | INTEGER | Yes | Identifier of the “from” schema in the relationship. |
FROM_SCHEMA_NAME | VARCHAR(255) | Yes | Name of the “from” schema in the relationship. |
FROM_CATALOG_ID | INTEGER | Yes | Identifier of the “from” catalog in the relationship. |
FROM_CATALOG_NAME | VARCHAR(255) | Yes | Name of the “from” catalog in the relationship. |
FROM_DATASOURCE_ID | INTEGER | Identifier of the “from” data source in the relationship. | |
FROM_DATASOURCE_NAME | VARCHAR(255) | Name of the “from” data source in the relationship. | |
TO_COLUMN_ID | INTEGER | Identifier of the “to” column in the relationship. | |
TO_COLUMN_NAME | VARCHAR(255) | Name of the “to” column in the relationship. | |
TO_COLUMN_DATA_TYPE | VARCHAR(255) | Yes | Data type of the “to” column in the relationship. |
TO_TABLE_ID | INTEGER | Identifier of the “to” table in the relationship. | |
TO_TABLE_NAME | VARCHAR(255) | Name of the “to” table in the relationship. | |
TO_SCHEMA_ID | INTEGER | Yes | Identifier of the “to” schema in the relationship. |
TO_SCHEMA_NAME | VARCHAR(255) | Yes | Name of the “to” schema in the relationship. |
TO_CATALOG_ID | INTEGER | Yes | Identifier of the “to” catalog in the relationship. |
TO_CATALOG_NAME | VARCHAR(255) | Yes | Name of the “to” catalog in the relationship. |
TO_DATASOURCE_ID | INTEGER | Identifier of the “to” data source in the relationship. | |
TO_DATASOURCE_NAME | VARCHAR(255) | Name of the “to” data source in the relationship. | |
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. | |
FROM_DATA_OBJECT_NAME | VARCHAR(2147483647) | Name of the “from” data object in the relationship. | |
TO_DATA_OBJECT_NAME | VARCHAR(2147483647) | Name of the “to” data object in the relationship. |