Diagrams

Table

Notification Entry

DynamicsDocs.comNotification Entry«Table 1511»Notification EntryID [PK]Type; [New Record,Approval,Overdue]Recipient User IDTriggered By RecordLink Target PageCustom LinkError MessageCreated Date-TimeCreated ByError Message 2Error Message 3Error Message 4«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<Created By>

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
3 Type (Type) Option
4 Recipient User ID (Recipient User ID) Code50
5 Triggered By Record (Triggered By Record) RecordID
6 Link Target Page (Link Target Page) Integer
7 Custom Link (Custom Link) Text250 [URL]
8 Error Message (Error Message) Text250 Editable: No
9 Created Date-Time (Created Date-Time) DateTime Editable: No
10 Created By (Created By) Code50 Editable: No
15 Error Message 2 (Error Message 2) Text250
16 Error Message 3 (Error Message 3) Text250
17 Error Message 4 (Error Message 4) Text250

Keys

# Fields
0 ID (ID) Clustered: Yes
1 Created Date-Time (Created Date-Time)

Table Relations To Other Tables

Field Related Table Related Field
Link Target Page (Link Target Page) Page Metadata ID (ID) 1..n
Created By (Created By) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field