Diagrams


Table

Activity Log

Fields

# Name Type
1 ID Integer AutoIncrement: Yes
2 Record ID RecordID
3 Activity Date DateTime
4 User ID Code50
5 Status Option
6 Context Text30
10 Description Text250
20 Activity Message Text250

Keys

# Fields
0 ID Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field