Category: Integrity
Database: DBC
View Column | Data Type | Format | Description |
---|---|---|---|
IndexID | SMALLINT NOT NULL | ---,--9 | The reference index number. Note: This is not the same as IndexNumber. |
IndexName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The name of the reference index. |
ParentDbID | BYTE(4) NOT NULL | X(8) | The database ID of the referenced table. |
ParentTID | BYTE(6) NOT NULL | X(12) | The table ID of the referenced table. |
ParentKeyFID | SMALLINT NOT NULL | ---,--9 | The field ID of a column in the referenced key. |
ChildDbID | BYTE(4) NOT NULL | X(8) | The database ID of the referencing table. |
ChildTID | BYTE(6) NOT NULL | X(12) | The table ID of the referencing table. |
ChildKeyFID | SMALLINT NOT NULL | ---,--9 | The field ID of a column in the referencing key. |
InconsistencyFlag | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Inconsistencies allowed between related parent-child object definitions after restore: Y (yes), N (no). |
CreatorName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The table or database creator. For DBC.AllRights, the grantor of explicit rights, otherwise the user who ran the CREATE statement. |
CreateTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The date and time that the object in the row was created. |
VTPKType | CHAR(1) LATIN UPPERCASE | X(1) | ValidTime dimension for the parent key. |
TTPKType | CHAR(1) LATIN UPPERCASE | X(1) | The TransactionTime dimension for the parent key. |
VTFKType | CHAR(1) LATIN UPPERCASE | X(1) | The ValidTime dimension for the foreign key. |
TTFKType | CHAR(1) LATIN UPPERCASE | X(1) | The TransactionTime dimension for the foreign key. |