Diagrams


Table

Activity Log

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

Keys

# Fields
0 ID (ID) Clustered: Yes

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