McDewey

2.3.177 elingroupmember (TI-2864) Description: Table to store the ELIN Groups to ELIN mapping Records may be modified only by installation and/or DB triggers. Fields: 2.3.177.1 datetimestamp (FI-27204) Type: long (Not Modifiable) Default Value: 0 Remarks: Updates when the record is inserted or updated. Rule (RI-2250): Type: Active (Insert/Update) Rule Name: To check for ELINGroupMember DateTimeS Description: update the datetimestamp for every insert o Test Condition: ON INSERT/UPDATE INTO ELINGroupMemb Rule (RI-2250): Type: Active (Insert/Update) This field is modified by this rule. Rule Name: To check for ELINGroupMember DateTimeS Description: update the datetimestamp for every insert o Test Condition: ON INSERT/UPDATE INTO ELINGroupMemb 2.3.177.2 fkelingroup (FI-26906) Type: guid (Indexed, Cascade Delete, Not Modifiable) Remarks: The pkid of the ELINGroup 2.3.177.3 fknumplan_elin (FI-26907) Type: guid (Unique, Indexed, Not Modifiable) Remarks: The pkid of the ELIN Rule (RI-2205): Type: Active (Insert) Rule Name: Insert into ElinGroupMember table Description: When a record is inserted into ElinGroupMe (PatterUsage of 105 (PATTERN_ELIN)), insert Test Condition: ON INSERT in ElinGroupMember : IF (tk_Pat ElinMappingDynamic (pkid,fknumPlan_ELI Rule (RI-2206): Type: Active (Delete) Rule Name: Delete from ELINGroupMember Description: When an ELIN is deleted from this table,del ELINMappingDynamic. And delete the ELIN Test Condition: ON DELETE from ELINGroupMember (DELE fkNumplan_ELIN = ELINGroupMember.fkNu