McDewey

2.0 Table Details 2.1 Table Relationships pkid is the primary key ID. It is always of type GUID (a 36 character UUID). Fields that begin with the letters "fk" represent foriegn keys into another table. The name of the field following the "fk" prefix up to but not including an underscore character is the name of the related table. The field in related table is always pkid. and is a GUID. Fields that begin with the letters "ik" represent internal keys into the same table. Fields that begin with a "tk" represent an enumerated type. This field is related to a table whose name begins with "Type" and ends with the name of the field following the prefix up to but not including an underscore character. The field in the related table is always "enum" and is an integer. Some tables do not allow insert or delete. These tables are populated by installation programs and migrated. Some tables do not allow any modifications at all and are populated by installation only. Some fields do not allow modification. These fields are populated by triggers in response to changes in other records, or they are set when the record is inserted. 2.2 Field Types DN This field is a directory number. This is currently defined as a variable length string of max length 23. enum This field is related to another table. The table name begins with "Type" and is followed by the field name without the "tk" prefix. GUID This is a globally unique ID. It is represented as a string of length 36 (string representation of UUID). long This is an integer stored as signed 4 byte value (+/-2^31-1). Refer to the Check Constraint for limitations on possible values. string