| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCATT Computer Aided Test Tool |
1 | CAT_FDATA | CATT contents for field lists in CAT_FINFO | 7 | COL_ID | Natural Number | int | 10 | 0 | | |
2 | CAT_FINFO | General Control field info | 22 | COL_ID | Natural Number | int | 10 | 0 | | |
TOPCollaboration Folders |
3 | CFX_AREA | Collaboration Folders: Area | 3 | COL_ID | Collaboration ID | varbinary | 16 | 0 | | |
4 | CFX_COL | Collaboration Folders: Collaboration | 2 | COL_ID | Collaboration ID | varbinary | 16 | 0 | | |
5 | CFX_COL_OBJTYPE | Object Types (and Categories) per Collaboration | 2 | COL_ID | Collaboration ID | varbinary | 16 | 0 | | |
6 | CFX_HIERARCHY | Collaboration Folders: Topic Hierarchy | 3 | COL_ID | Collaboration ID | varbinary | 16 | 0 | | |
7 | CFX_HIST_AUTH | Saves all Changes to Authorization Objects | 11 | COL_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
8 | CFX_HIST_AUX | Help Table for Aggregation Report | 2 | COL_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
9 | CFX_HIST_FOL | CFX: Redundant Storage Topic ID for Folder ID (1:n) | 2 | COL_ID | Collaboration ID | varbinary | 16 | 0 | | |
10 | CFX_NTF_OBJECT | Collaboration Folders: Objects for the Notifications | 5 | COL_ID | Collaboration ID | varbinary | 16 | 0 | | |
TOPMaster Recipe |
11 | KALC | Material Quantity Calculation - Formulas | 10 | COL_ID | Object ID | nvarchar | 30 | 0 | | |
TOPProcess Monitoring Infrastructure |
12 | SSPIUICUCD | SPI: Definition of Step Collections | 3 | COL_ID | ID of Collection for Process | nvarchar | 32 | 0 | | |
13 | SSPIUICUCD_T | SPI: Short Texts for Step Transitions | 4 | COL_ID | ID of Collection for Process | nvarchar | 32 | 0 | | |
14 | SSPIUICUCE | SPI: Elements of Step Collection | 2 | COL_ID | ID of Collection for Process | nvarchar | 32 | 0 | | |
TOPResourcen Management |
15 | FRMLC32 | RMS-FRM: Layout-Dependent Field Catalog Superset | 1 | COL_ID | Table Column | nvarchar | 30 | 0 | | |
16 | FRMLC32T | Column Keys and Texts | 1 | COL_ID | Table Column | nvarchar | 30 | 0 | | |
17 | FRMLC33 | RMS-FRM: Layout-Dependent Field Catalog | 4 | COL_ID | Table Column | nvarchar | 30 | 0 | | |
18 | RMSAT_STD_LAY_P | RMS-ATL: Item Table Layout Standardization | 3 | COL_ID | Object ID for Standardization | nvarchar | 32 | 0 | | |
19 | RMSAT_STD_PARA_P | RMS-ATL: Item Table Parameter Standardization | 4 | COL_ID | Object ID for Standardization | nvarchar | 32 | 0 | | |
TOPSAP Utilities |
20 | ISU_BOLTREE_OCA | Utilities BOL Tree: One Click Actions | 7 | COL_ID | Utilities BOL Tree: Alternative Column ID | nvarchar | 2 | 0 | | |
21 | ISU_BOLTREE_PCOL | Utilities BOL Tree: Column Definition | 3 | COL_ID | Utilities BOL Tree: Column ID | nvarchar | 2 | 0 | | |
22 | ISU_BOLTREE_PCOT | Utilities BOL Tree: Column Titles | 3 | COL_ID | Utilities BOL Tree: Column ID | nvarchar | 2 | 0 | | |
23 | ISU_BOLTREE_PRCO | Utilities BOL Tree: Column Presentation | 3 | COL_ID | Utilities BOL Tree: Column ID | nvarchar | 2 | 0 | | |
TOPStorage and Retention Service |
24 | DAS_COLLECTIONS | ILM SRS: Collections | 2 | COL_ID | Collection ID | nvarchar | 19 | 0 | | |
25 | DAS_COL_INDEX | ILM SRS: Relationship Between Indices and Collections | 3 | COL_ID | Collection ID | nvarchar | 19 | 0 | | |
26 | DAS_COL_PROP | ILM SRS: Collection Properties; ORIGINS | 2 | COL_ID | Collection ID | nvarchar | 19 | 0 | | |
27 | DAS_COL_STORE | ILM SRS: Relationship Between Collection and Store | 2 | COL_ID | Collection ID | nvarchar | 19 | 0 | | |
28 | DAS_INV_REASON | ILM SRS: Reason for Setting a Resource to Invalid | 3 | COL_ID | Collection ID | nvarchar | 19 | 0 | | |
29 | DAS_RESOURCES | ILM SRS: Resources | 9 | COL_ID | Collection ID | nvarchar | 19 | 0 | | |
TOPUI Configuration Design Layer |
30 | BSPC_DL_FSLAY_TI | Fact Sheet Tile Layout Tiles | 4 | COL_ID | Tile / Column | smallint | 5 | 0 | | |