| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPHierarchical Derivation Service |
| 1 | THDS_GENCATL | Catalog for Generation | 7 | VERSIONGUID | General Version ID for the Tree | varbinary | 16 | 0 | | |
| 2 | THDS_GENCATL_A | Catalog for Generation | 7 | VERSIONGUID | General Version ID for the Tree | varbinary | 16 | 0 | | |
| 3 | THDS_GENCATL_S | Catalog for Generation | 6 | VERSIONGUID | General Version ID for the Tree | varbinary | 16 | 0 | | |
| 4 | THDS_TREE | Header of a Derivation Tree | 6 | VERSIONGUID | General Version ID for the Tree | varbinary | 16 | 0 | | |
| 5 | THDS_TREE_A | Header of a Derivation Tree | 6 | VERSIONGUID | General Version ID for the Tree | varbinary | 16 | 0 | | |
| 6 | THDS_TREE_ACTIVE | Comprises Active Versions of Trees | 4 | VERSIONGUID | General Version ID for the Tree | varbinary | 16 | 0 | | |
| 7 | THDS_TREE_ACT_A | Comprises Active Versions of Trees | 4 | VERSIONGUID | General Version ID for the Tree | varbinary | 16 | 0 | | |
| 8 | THDS_TREE_ACT_S | Comprises Active Versions of Trees | 3 | VERSIONGUID | General Version ID for the Tree | varbinary | 16 | 0 | | |
| 9 | THDS_TREE_HIST | History Table - HDS Trees | 4 | VERSIONGUID | General Version ID for the Tree | varbinary | 16 | 0 | | |
| 10 | THDS_TREE_HIST_A | History Table - HDS Trees | 4 | VERSIONGUID | General Version ID for the Tree | varbinary | 16 | 0 | | |
| 11 | THDS_TREE_HIST_S | History Table - HDS Trees | 3 | VERSIONGUID | General Version ID for the Tree | varbinary | 16 | 0 | | |
| 12 | THDS_TREE_S | Header of a Derivation Tree | 5 | VERSIONGUID | General Version ID for the Tree | varbinary | 16 | 0 | | |
