Discovery Guide > Introducing Discovery > About the Relationships Discovered > Table Statistics Displayed for Relationship Discovery
 
Table Statistics Displayed for Relationship Discovery
When Discovery is present in Studio, tables in each TDV data sources display additional details about relationships in the Columns tab. Such data is shown only after relationship discovery has occurred for this data source.
Columns 1-10:
Columns 10-20:
The first three columns are shown for all tables in Studio. (See the TDV User Guide.) All other columns are specific to Discovery
Table Columns/
Discovery-Specific Statistic
Description
In Relationship
Indicates if this column is involved in a Discovery relationship.
Click Display Results to see the relationships of each type in the Result tab.
Relationships
The number of relationships in which this column is involved.
<#>—The number of relationships for this column.
Click Display Results to see details about the relationships in the Result tab.
Key Type
If this column is a primary or foreign key, displays the key type:
PK— Primary key.
FK— Foreign key.
Null Permitted?
Y if nulls are permitted; blank if nulls are not permitted.
% Null
The percentage of null values in this column.
Total Null
The total number of rows that have a null in this column.
<#>—The number of nulls in this column.
Click Display Results to see the data in this table in the Result tab.
Total Non Null
The total number of rows that have a value in this column.
<#>—The number of rows that have a value in this column.
Click Display Results to see the data in this table on the Result tab.
Unique Constraint?
Y if the values in this column must be unique; N if not.
% Unique
The percentage of unique values in this column.
Total Unique
The total number of rows that have unique values in this column.
<#>—The number of rows that have unique values in this column.
Click Display Results to see the rows with unique data on the Result tab.
Total Non Unique
The total number of rows that have non unique values in this column.
<#>—The number of rows that have non unique values in this column.
Click Display Results to see the rows with non unique data in the Result tab.
Distinct
The total number of rows that have distinct values in this column.
<#>—The number of rows that have distinct values in this column.
Click Display Results to see the rows with distinct values in the Result tab.
Min
The minimum value in this column. If numeric, the lowest numeric value. If alphabetic, the value that begins with the lowest letter in the alphabet where A is low and Z is high.
Max
The maximum value in this column. If numeric, the highest numeric value. If alphabetic, the value that begins with the highest letter in the alphabet where A is low and Z is high.
Mode
Which term happens most frequently.
% Mode
The percentage of time the mode occurs.
Denormalize
The separator to use for denormalization. Typically, a comma, period, space (\s), or tab (\t).