Reference Guide > TDV and Business Directory System Tables > ALL_RELATIONSHIPS
 
ALL_RELATIONSHIPS
The ALL_RELATIONSHIPS system table exposes all relationships to which the current user has access. Users can see relationships if they have privileges on the tables involved.
For further information about this system table, see the Discovery User Guide.
Column
TDV
JDBC Data Type
Nullable
Description
RELATIONSHIP_ID
INTEGER
 
Identifier of the relationship.
RELATIONSHIP_TYPE
VARCHAR(40)
 
Relationship type.
RELATIONSHIP_CARDINALITY
VARCHAR(32)
 
Relationship cardinality.
RELATIONSHIP_STATUS
VARCHAR(40)
 
Relationship status.
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_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.
NUM_MATCHES
INTEGER
 
Number-of-matches factor used in calculating a relationship probability score.
KEY_FACTOR
NUMERIC(7,4)
 
Index key factor used in calculating a relationship probability score.
NAME_FACTOR
NUMERIC(7,4)
 
Column name comparison factor used in calculating a relationship probability score.
MATCH_PERCENTAGE_FACTOR
NUMERIC(7,4)
 
Match percentage factor used in calculating a relationship probability score.
LOCALITY_FACTOR
NUMERIC(7,4)
 
Schema locality factor used in calculating a relationship probability score.
KEY_FACTOR_WEIGHT
NUMERIC(7,4)
 
Percentage importance to apply to KEY_FACTOR when calculating a relationship probability score.
NAME_FACTOR_WEIGHT
NUMERIC(7,4)
 
Percentage importance to apply to NAME_FACTOR when calculating a relationship probability score.
NUM_MATCHES_WEIGHT
NUMERIC(7,4)
 
Percentage importance to apply to NUM_MATCHES when calculating a relationship probability score.
MATCH_PERCENTAGE_WEIGHT
NUMERIC(7,4)
 
Percentage importance to apply to MATCH_PERCENTAGE_FACTOR when calculating a relationship probability score.
LOCALITY_WEIGHT
NUMERIC(7,4)
 
Percentage importance to apply to LOCALITY_FACTOR when calculating a relationship probability score.
SCORE
NUMERIC(7,4)
 
Relationship probability score.
SCAN_ID
INTEGER
 
Identifier for the scan that created the relationship.
OWNER_ID
INTEGER
 
Identifier for the person who created or owns the procedure.
OWNER
VARCHAR(255)
 
User name of the person who created or owns the procedure.
CID
INTEGER
 
For internal use only.