McDewey

2.3.11 analogaccess (TI-2) Description: This subclasses the device table for analog access information not in the Devic Fields: 2.3.11.1 fkdevice (FI-14) Type: guid (Unique, Indexed, Cascade Delete) Migration Source: convert from DeviceName Remarks: Points to the device record being "subclassed." Device.tkMo Rule (RI-13): Type: Validation (Insert/Update) Rule Name: AnalogAccess device Description: The records in AnalogAccess table must refe protocol Test Condition: AnalogAccess.fkDevice IN (SELECT pkid FRO Error Message: AnalogAccess table may only reference devi (AnalogAccess). Remedy: Correct the fkDevice value to refer to an Ana 2.3.11.2 pkid (FI-13) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Migration Source: Generated Remarks: Unique ID to identify a record. 2.3.11.3 tktrunkselectionorder (FI-15) Type: enum Migration Source: TrunkSelectionOrder Remarks: IE. Bottom up or top down. Uniqueness: No multicolumn uniqueness constraints 2.3.12 analogaccessport (TI-3) Description: Analog access ports associtated with an analog access Device. Fields: 2.3.12.1 attendantdn (FI-22) Type: dn DN Type: DN_TYPE_ALL_DIGITS Default Value: EMPTY Validation: ^[0-9*#+]{0,50}$ Migration Source: AttendantNumber Remarks: