Trumping_Common Code_FK1Trumping_Common Code_FKTrumper OrganismTrumping_Common Code_FK2
| Business Data Model Data Model |
| Description | The rules that govern which items are displayed when viewing patient detail records and journals. There could be a laundry list of observations and organisms submitted and the trumping rules are used to display only the most critical observations and/or organisms. |
| Relationship | |
| Trumping_Common Code_FK1 |
|
| Trumping_Common Code_FK |
|
| Trumper Organism |
|
| Trumping_Common Code_FK2 |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Relationship Details |
Trumping_Common Code_FK1
| Is Identifying Relationship | false |
| Child Table | Organism Trumping |
| Child Role Name | trumpee organism |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Common Code |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Trumping_Common Code_FK
| Is Identifying Relationship | false |
| Child Table | Organism Trumping |
| Child Role Name | trumper observation |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Common Code |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Trumper Organism
| Is Identifying Relationship | false |
| Child Table | Organism Trumping |
| Child Role Name | trumper organism |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Common Code |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Trumping_Common Code_FK2
| Is Identifying Relationship | false |
| Child Table | Organism Trumping |
| Child Role Name | trumpee observation |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Common Code |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |