Diagrams


Table

Change Log Entry

Fields

# Name Type
1 Entry No. BigInteger AutoIncrement: Yes
2 Date and Time DateTime
3 Time Time
4 User ID Code50
5 Table No. Integer
6 Table Caption Text250 FlowField
7 Field No. Integer
8 Field Caption Text80 FlowField
9 Type of Change Option
10 Old Value Text250
11 New Value Text250
12 Primary Key Text250
13 Primary Key Field 1 No. Integer
14 Primary Key Field 1 Caption Text80 FlowField
15 Primary Key Field 1 Value Text50
16 Primary Key Field 2 No. Integer
17 Primary Key Field 2 Caption Text80 FlowField
18 Primary Key Field 2 Value Text50
19 Primary Key Field 3 No. Integer
20 Primary Key Field 3 Caption Text80 FlowField
21 Primary Key Field 3 Value Text50
22 Record ID RecordID

Keys

# Fields
0 Entry No. Clustered: Yes
1 Table No.,Primary Key Field 1 Value
2 Table No.,Date and Time

Table Relations To Other Tables

Field Related Table Related Field
Table No. AllObjWithCaption Object ID 1..n
Primary Key Field 3 No. Field No. 1..n
User ID User User Name 1..n

Table Relations From Other Tables

From Table From Field