Diagrams

Table

Activity Log

DynamicsDocs.comActivity Log«Table 710»Activity LogID [PK]Record IDActivity DateUser IDStatus; [Success,Failed]ContextDescriptionActivity MessageDetailed InfoTable No Filter«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 ID>

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

Fields

# Name Type
1 ID (ID) Integer AutoIncrement: Yes
2 Record ID (Record ID) RecordID
3 Activity Date (Activity Date) DateTime
4 User ID (User ID) Code50
5 Status (Status) Option
6 Context (Context) Text30
10 Description (Description) Text250
20 Activity Message (Activity Message) Text250
21 Detailed Info (Detailed Info) BLOB
22 Table No Filter (Table No Filter) Integer

Keys

# Fields
0 ID (ID) Clustered: Yes
1 Activity Date (Activity Date)

Table Relations To Other Tables

Field Related Table Related Field
User ID (User ID) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field