15.10 - RI_Parent_TablesV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Integrity

DBC

 

View Column

Data Type

Format

Source Table.Column

IndexID

SMALLINT

NOT NULL

---,--9

ReferencedTbls.ReferenceIdx

IndexName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

ReferencedTbls.ReferenceIdxName

ParentDbID

BYTE(4)

NOT NULL

X(8)

ReferencedTbls.ReferencedDbID (Composite NUPI)

ParentTID

BYTE(6)

NOT NULL

X(12)

ReferencedTbls.ReferencedTblid (Composite NUPI)

ParentKeyFID

SMALLINT

NOT NULL

---,--9

ReferencedTbls.ParentKeyFID

ChildDbID

BYTE(4)

NOT NULL

X(8)

ReferencedTbls.ReferencingDbID

ChildTID

BYTE(6)

NOT NULL

X(12)

ReferencedTbls.ReferencingTblID

ChildKeyFID

SMALLINT

NOT NULL

---,--9

ReferencedTbls.ForeignKeyFID

InconsistencyFlag

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

ReferencedTbls.InconsistentFlag

CreatorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

CreateTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReferencedTbls.CreateTimeStamp

VTPKType

CHAR(1) LATIN

X(1)

ReferencedTbls.VTPKType

TTPKType

CHAR(1) LATIN

X(1)

ReferencedTbls.TTPKType

VTFKType

CHAR(1) LATIN

X(1)

ReferencedTbls.VTFKType

TTFKType

CHAR(1) LATIN

X(1)

ReferencedTbls.TTFKType

The corresponding table for DBC.RI_Parent_TablesV is DBC.ReferencedTbls.

The corresponding tables for DBC.RI_Parent_TablesV[X] are:

  • DBC.AccessRights
  • DBC.DBase
  • DBC.Owners
  • DBC.ReferencedTbls
  • DBC.RoleGrants
  • DBC.Roles
  • The RI_Parent_Tables view is similar to the All_RI_Parents view, but contains the IDs of databases, tables, and columns instead of the names for access control purposes.

    The administrator can control who has access to internal ID numbers by limiting the access to the RI_Parent_Tables view while allowing more (or all) users to access the names via the All_RI_Parents view.

    Some of the column values show information related to a Teradata temporal table or an ANSI temporal table. For more information about these tables, see ANSI Temporal Table Support and Temporal Table Support.

    InconsistencyFlag

    If the value in the InconsistencyFlag column is Y, it may be possible to validate the reference indexes that have been marked as inconsistent.

    Possible Values for TTFKType

     

    Value

    Description

    C

    Current foreign key

    N

    Nonsequenced foreign key

    NULL

    A child table is a nontemporal table or a table that does not support TransactionTime

    S

    Sequenced foreign key

    Possible Values for TTPKType

     

    Value

    Description

    C

    Current parent key

    S

    Sequenced parent key

    N

    Nonsequenced parent key

    NULL

    If the parent table is a nontemporal table or the table does not support either ValidTime or TransactionTime

    Possible Values for VTFKType

     

    Value

    Description

    A

    ANSIQUALIFIER

    Note: The Teradata temporal valid-time tables are compatible with ANSI valid-time tables, however to use ANSI temporal tables requires that the session temporal qualifier for systems using Teradata temporal tables be explicitly set to ANSIQUALIFIER.

    C

    Current foreign key

    N

    Nonsequenced foreign key

    P

    Referential integrity constraint for ANSI Temporal tables. Temporal constraints can be defined for valid-time period column names with the special PERIOD keyword.

    R

    Temporal relationship constraint (TRC) referential integrity

    S

    Sequenced foreign key

    NULL

    The child table is non-temporal or does not support ValidTime.

    Possible Values for VTPKType

     

    Value

    Description

    A

    ANSIQUALIFIER

    C

    Current parent key

    S

    Sequenced parent key

    N

    Nonsequenced parent key

    NULL

    If the parent table is a nontemporal table or the table does not support either ValidTime or TransactionTime

    P

    Referential integrity constraint for ANSI Temporal tables. Temporal referential constraints can be defined for valid-time period column in temporal tables by specifying the valid-time derived PERIOD column names with the special PERIOD keyword.