Referential integrity
Referential integrity is a concept that applies to related records in a referential database. Where a record references another record, the data column that defines the relationship is known as a foreign key (FK). A referential issue occurs if the referenced record is removed from the database before the dependent record.
The following table shows a suggested order of tables to use when you are deleting records. If this order
is followed, referential integrity problems do not occur. In addition, the DDL that is supplied with FTM for the database includes the appropriate indexes for foreign key columns.
| Table name |
|---|
| TXN_PARTY_REL |
| ACTIVITY_BASE |
| H_ACTIVITY_BASE |
| TXN_PAYMENT_BASE |
| H_TXN_PAYMENT_BASE |
| TXN_SECURITIES_BASE |
| H_TXN_SECURITIES_BASE |
| TRANSACTION_BASE |
| H_TRANSACTION_BASE |
| BATCH_BASE |
| H_BATCH_BASE |
| FRAGMENT_BASE |
| H_FRAGMENT_BASE |
| TRANSMISSION_BASE |
| H_TRANSMISSION_BASE |
| OBJ_OBJ_REL |
| ERROR |
| ID_REFERENCE |
| OBJ_VALUE |
| H_OBJ_VALUE |
| OBJ_BASE |
| H_OBJ_BASE |
| EVENT |