Diagrams

Table

Posted Approval Comment Line

DynamicsDocs.comPosted Approval Comment Line«Table 457»Posted Approval Comment LineEntry No. [PK]Table IDDocument No.User IDDate and TimeCommentPosted Record ID«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 Entry No. (Entry No.) Integer
2 Table ID (Table ID) Integer
4 Document No. (Document No.) Code20
5 User ID (User ID) Code50
6 Date and Time (Date and Time) DateTime
7 Comment (Comment) Text80
8 Posted Record ID (Posted Record ID) RecordID

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Table ID,Document No.,Date and Time (Table ID,Document No.,Date and Time)

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