2.5.3 Contents of the .tbl.xml Files
Each file that contains metadata for a table (.tbl.xml file) contains an XMSimpleTable object. These table metadata files differ according to which columns exist in the Columns collection of the XMSimpleTable object. The following table specifies which columns exist for each type of table metadata file.
Type of table metadata file |
Example file name |
Columns collection content |
---|---|---|
Column hierarchy file |
H$Table-Diet$wt.0.tbl.xml |
One column collection item for each of the system-generated hierarchy indexes: ID_TO_POS and POS_TO_ID. |
User hierarchy metadata file |
U$Hierarchy$1.0.tbl.xml |
One column collection item for each of the system-generated user hierarchy columns: CHILD_COUNT, FIRST_CHILD_POS, and MULTI_LEVEL_ID, PARENT_POS. |
Table relationship file |
R$Table-Diet$ec91bf00-f577-4c86-b7f8-8c5dcd44a2ac.64.tbl.xml |
One column collection item for the system-generated relationship file column: INDEX. |
Table metadata file |
Table-Diet.31.tbl.xml |
One column collection item for each column in the source data table. |