Diagrams

Table

Page Data Personalization

DynamicsDocs.comPage Data Personalization«Table 2000000080»Page Data PersonalizationUser SID [PK]User IDObject Type; [,,,Report,,,XMLport,,Pag...Object ID [PK]DateTimePersonalization ID [PK]ValueName [PK]Value«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID<User SID>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
3 User SID (User SID) GUID
6 User ID (User ID) Code50 FlowField
9 Object Type (Object Type) Option
12 Object ID (Object ID) Integer
15 Date (Date) Date
18 Time (Time) Time
21 Personalization ID (Personalization ID) Code40
24 ValueName (ValueName) Code40
27 Value (Value) BLOB

Keys

# Fields
0 User SID,Object Type,Object ID,Personalization ID,ValueName (User SID,Object Type,Object ID,Personalization ID,ValueName) Clustered: Yes
1 Date (Date)

Table Relations To Other Tables

Field Related Table Related Field
Object ID (Object ID) Object ID (ID) 1..n
User SID (User SID) User User Security ID (User Security ID) 1..n

Table Relations From Other Tables

From Table From Field