| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPData Retention Tool |
| 1 | DARTEOL_LOG | Lock object for log file | 1 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 2 | TXW_C_VOLD | Data file directories | 3 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 3 | TXW_DIR | Data file log (replaced by txw_dir2, use of guids) | 3 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 4 | TXW_DIR2 | Data file log | 3 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 5 | TXW_DIRAL | Data file log - ArchiveLink (obsolete after rel 99) | 3 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 6 | TXW_DIRAL2 | Data file log - ArchiveLink | 3 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 7 | TXW_DIRSEG | Data file segment directory (replaced by txw_dirsg2: uuids) | 7 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 8 | TXW_DIRSG2 | Data file segment directory | 7 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 9 | TXW_INDEX | Temporary table for data segment index | 5 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 10 | TXW_INDEX_01 | Temporary table for data segment index | 5 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 11 | TXW_INDEX_02 | Temporary table for data segment index | 5 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 12 | TXW_INDEX_03 | Temporary table for data segment index | 5 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 13 | TXW_INDEX_04 | Temporary table for data segment index | 5 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 14 | TXW_INDEX_05 | Temporary table for data segment index | 5 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 15 | TXW_VWLOG | View query log (replaced by txw_vwlog2: uuids) | 5 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 16 | TXW_VWLOG2 | View query log | 3 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 17 | TXW_VWLOG2_U | Data view query log | 3 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
| 18 | TXW_VWLOGAL2 | View query log - ArchiveLink | 3 | VOL_ID | Volume ID | nvarchar | 2 | 0 | | |
