McDewey

Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. 2.3.186.5 userstate (FI-3017) Type: long Default Value: 0 Uniqueness: No multicolumn uniqueness constraints 2.3.187 endusercustomermap (TI-21053) Description: mapping table for HCS-SA for customers to users Fields: 2.3.187.1 fkcustomer (FI-28275) Type: guid (Indexed, Cascade Delete, Not Modifiable) Remarks: Reference to parent record in table Customer 2.3.187.2 fkenduser (FI-28274) Type: guid (Indexed, Cascade Delete, Not Modifiable) Remarks: Reference to parent record in table EndUser 2.3.187.3 pkid (FI-28273) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Migration Source: Generated Remarks: Unique ID to identify a record. 2.3.187.4 timestamp (FI-28277) Type: long Default Value: 0 Remarks: UTC time of creation/modification Rule (RI-2383): Type: Active (Insert/Update) Rule Name: Update timestamp for EndUserCustomerMa Description: When a EndUserCustomerMap record is upd value Test Condition: ON INSERT/UPDATE INTO EndUserCustomer return currentTime (INTO timestamp); Rule (RI-2383): Type: Active (Insert/Update) This field is modified by this rule. Rule Name: Update timestamp for EndUserCustomerMa Description: When a EndUserCustomerMap record is upd value