C H A P T E R 1 6 - C H A N G E L O G
AT5600 User Manual 98-119 issue 14 Page 404
INDEX IDS
The index IDs for the database storage (shown in BOLD in the above
tables) are strings based on the following pattern:
• PPyyyyMMddHHmmssRRRRRRRR
where,
• PP is two digits representing the COM port number that the AT is on.
• yyyy is the four-digit year the entry was created.
• MM is the two-digit month the entry was created.
• dd is the two-digit day the entry was created.
• HH is the two-digit hour (0-23) the entry was created.
• mm is the two-digit minute the entry was created.
• ss is the two-digit second the entry was created.
• RRRRRRRR is a 32-bit random number expressed in hexadecimal
notation with characters 0-9 and A-F.
Table Relationships
The relationship between the four tables is relatively simple.
It is best expressed using the below query diagram from ACCESS