EJ table is used to store the EJ records. All the transaction share the
same table regardless of the types of the transaction. Five fields are fixed
as the following table shows:
Table 1. |
Key |
Fields ID |
Type |
Non-NULL |
1 |
Yes |
UserID |
CHAR(32) |
Yes |
2 |
Yes |
Date |
CHAR(8) |
Yes |
3 |
Yes |
RecordSeqNum |
INT |
Yes |
4 |
|
RestoreData |
VARCHAR(200) |
|
5 |
|
RestoreDetailData |
BLOB |
|
The
UserID, Date and RecordSeqNum are the primary keys. The
RestoreData is
the transaction data and
RestoreDetailData is the GUI information.
Both of them are needed for Electronic Journal Viewer's recurrence. The
RestoreDetailData can
be the path of the BTT XUI file, the content of the XUI, the snapshot of the
transaction UI, or some other kinds of GUI information.