USURDRIR

The USURDRIR table is used for referential Integrity process. The following table describes the columns in the USURDRIR table:

Column Type Length Decimal Domain
MCRECID BINARY 4 0 machine/company ID
DBNAME CHARACTER 128 0 Database Name
PSNAME CHARACTER 128 0 Primary Key Schema Name
PTNAME CHARACTER 128 0 Primary Key Table Name
PKNAME CHARACTER 128 0 Primary Key Name
PKCOLNAM CHARACTER 128 0 Field included in Primary Key
KCOLSEQ BINARY 4 0 Field sequence in Primary Key
KUPRULE BINARY 4 0 Primary Key Update Rule
KDELRULE BINARY 4 0 Primary Key Delete Rule
FSNAME CHARACTER 128 0 Foreign Key Schema Name
FTNAME CHARACTER 128 0 Foreign Key Table Name
FKNAME CHARACTER 128 0 Foreign Key Name
FKCOLNAM CHARACTER 128 0 Field Included In Foreign Key
Parent topic: Table and Column Descriptions