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
21 Detailed Info BLOB
22 Table No Filter Integer

Keys

# Fields
0 ID Clustered: Yes
1 Activity Date

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