Type Alias FieldInTableData

type FieldInTableData = {
    qComment?: string;
    qDerivedFields?: DerivedFieldsInTableData[];
    qHasDuplicates?: boolean;
    qHasNull?: boolean;
    qHasWild?: boolean;
    qInformationDensity?: number;
    qIsFieldOnTheFly?: boolean;
    qIsSynthetic?: boolean;
    qKeyType?: KeyType;
    qName?: string;
    qnNonNulls?: number;
    qnPresentDistinctValues?: number;
    qnRows?: number;
    qnTotalDistinctValues?: number;
    qOriginalFields?: string[];
    qPresent?: boolean;
    qReadableName?: string;
    qSubsetRatio?: number;
    qTags?: string[];
}
Index

Properties

qComment?: string

Comment related to the field.

qDerivedFields?: DerivedFieldsInTableData[]

List of the derived fields.

qHasDuplicates?: boolean

This property is set to true if the field contains some duplicate values.

qHasNull?: boolean

This property is set to true if the field contains some Null values.

qHasWild?: boolean
qInformationDensity?: number

Number of records that have values (for example, not NULL) in the field as compared to the total number of records in the table.

qIsFieldOnTheFly?: boolean
qIsSynthetic?: boolean

This property is set to true if the field contains a synthetic key.

qKeyType?: KeyType

Tells if the field is a key field.

One of:

  • NOT_KEY
  • ANY_KEY
  • PRIMARY_KEY
  • PERFECT_KEY
qName?: string

Name of the field.

qnNonNulls?: number

Number of values that are non Null.

qnPresentDistinctValues?: number
qnRows?: number

Number of rows in the field.

qnTotalDistinctValues?: number

Number of distinct values in the field.

qOriginalFields?: string[]

Is shown for fixed records. qOriginalFieldName and qName are identical if no field names are used in the file. qOriginalFieldName differs from qName if embedded file names are used in the file.

qPresent?: boolean
qReadableName?: string
qSubsetRatio?: number

Number of distinct values in the field (in the current table) as compared to the total number of distinct values of this field (in all tables).

qTags?: string[]

List of tags related to the field.