| ALARM_TREE.PK_ALARM_TREE |
| TableName | ALARM_TREE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ALARM_TREE.PK_ALARM_TREE Index Columns |
| ColumnName | Sort Order |
| COMPONENT_ID | Ascending |
| ALARM_TREE.PK_ALARM_TREE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | DIAG_TS |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ALARM_TREE.PK_ALARM_TREE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ALARM_TREE.PK_ALARM_TREE Bound Attachments |
| Name | Current Value |
| ALARM_TREE.FK_ALARM_TREE_TO_ALARM_TREE |
| TableName | ALARM_TREE |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX ALARM.FK_ALARM_TREE_TO_ALARM_TREE ON ALARM.ALARM_TREE(PARENT_CMPNT_ID) TABLESPACE DIAG_TS LOGGING ; |
| ALARM_TREE.FK_ALARM_TREE_TO_ALARM_TREE Index Columns |
| ColumnName | Sort Order |
| PARENT_CMPNT_ID | Ascending |
| ALARM_TREE.FK_ALARM_TREE_TO_ALARM_TREE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | DIAG_TS |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| ALARM_TREE.FK_ALARM_TREE_TO_ALARM_TREE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ALARM_TREE.FK_ALARM_TREE_TO_ALARM_TREE Bound Attachments |
| Name | Current Value |
| COMMAND.PK_COMMAND |
| TableName | COMMAND |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| COMMAND.PK_COMMAND Index Columns |
| ColumnName | Sort Order |
| COMPONENT_ID | Ascending |
| TITLE | Ascending |
| COMMAND.PK_COMMAND Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | DIAG_TS |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| COMMAND.PK_COMMAND Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| COMMAND.PK_COMMAND Bound Attachments |
| Name | Current Value |
| COMMAND.FK_COMMAND_TO_ALARM_TREE |
| TableName | COMMAND |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX ALARM.FK_COMMAND_TO_ALARM_TREE ON ALARM.COMMAND(COMPONENT_ID) TABLESPACE DIAG_TS LOGGING ; |
| COMMAND.FK_COMMAND_TO_ALARM_TREE Index Columns |
| ColumnName | Sort Order |
| COMPONENT_ID | Ascending |
| COMMAND.FK_COMMAND_TO_ALARM_TREE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | DIAG_TS |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| COMMAND.FK_COMMAND_TO_ALARM_TREE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| COMMAND.FK_COMMAND_TO_ALARM_TREE Bound Attachments |
| Name | Current Value |
| DISPLAY.PK_DISPLAY |
| TableName | DISPLAY |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DISPLAY.PK_DISPLAY Index Columns |
| ColumnName | Sort Order |
| COMPONENT_ID | Ascending |
| TITLE | Ascending |
| DISPLAY.PK_DISPLAY Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | DIAG_TS |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| DISPLAY.PK_DISPLAY Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DISPLAY.PK_DISPLAY Bound Attachments |
| Name | Current Value |
| DISPLAY.FK_DISPLAY_TO_ALARM_TREE |
| TableName | DISPLAY |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX ALARM.FK_DISPLAY_TO_ALARM_TREE ON ALARM.DISPLAY(COMPONENT_ID) TABLESPACE DIAG_TS LOGGING ; |
| DISPLAY.FK_DISPLAY_TO_ALARM_TREE Index Columns |
| ColumnName | Sort Order |
| COMPONENT_ID | Ascending |
| DISPLAY.FK_DISPLAY_TO_ALARM_TREE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | DIAG_TS |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| DISPLAY.FK_DISPLAY_TO_ALARM_TREE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DISPLAY.FK_DISPLAY_TO_ALARM_TREE Bound Attachments |
| Name | Current Value |
| GUIDANCE.PK_GUIDANCE |
| TableName | GUIDANCE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| GUIDANCE.PK_GUIDANCE Index Columns |
| ColumnName | Sort Order |
| COMPONENT_ID | Ascending |
| TITLE | Ascending |
| GUIDANCE.PK_GUIDANCE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | DIAG_TS |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| GUIDANCE.PK_GUIDANCE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| GUIDANCE.PK_GUIDANCE Bound Attachments |
| Name | Current Value |
| GUIDANCE.FK_GUIDANCE_TO_ALARM_TREE |
| TableName | GUIDANCE |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX ALARM.FK_GUIDANCE_TO_ALARM_TREE ON ALARM.GUIDANCE(COMPONENT_ID) TABLESPACE DIAG_TS LOGGING ; |
| GUIDANCE.FK_GUIDANCE_TO_ALARM_TREE Index Columns |
| ColumnName | Sort Order |
| COMPONENT_ID | Ascending |
| GUIDANCE.FK_GUIDANCE_TO_ALARM_TREE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | DIAG_TS |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| GUIDANCE.FK_GUIDANCE_TO_ALARM_TREE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| GUIDANCE.FK_GUIDANCE_TO_ALARM_TREE Bound Attachments |
| Name | Current Value |
| PV.PK_PV |
| TableName | PV |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PV.PK_PV Index Columns |
| ColumnName | Sort Order |
| COMPONENT_ID | Ascending |
| PV.PK_PV Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | DIAG_TS |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PV.PK_PV Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PV.PK_PV Bound Attachments |
| Name | Current Value |
| PV.FK_PV_TO_STATUS |
| TableName | PV |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX ALARM.FK_PV_TO_STATUS ON ALARM.PV(STATUS_ID) TABLESPACE DIAG_TS LOGGING ; |
| PV.FK_PV_TO_STATUS Index Columns |
| ColumnName | Sort Order |
| STATUS_ID | Ascending |
| PV.FK_PV_TO_STATUS Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | DIAG_TS |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PV.FK_PV_TO_STATUS Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PV.FK_PV_TO_STATUS Bound Attachments |
| Name | Current Value |
| PV.FK_PV_TO_SEVERITY |
| TableName | PV |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX ALARM.FK_PV_TO_SEVERITY ON ALARM.PV(SEVERITY_ID) TABLESPACE DIAG_TS LOGGING ; |
| PV.FK_PV_TO_SEVERITY Index Columns |
| ColumnName | Sort Order |
| SEVERITY_ID | Ascending |
| PV.FK_PV_TO_SEVERITY Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | DIAG_TS |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PV.FK_PV_TO_SEVERITY Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PV.FK_PV_TO_SEVERITY Bound Attachments |
| Name | Current Value |
| PV.FK_PV_TO_ALARM_TREE |
| TableName | PV |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX ALARM.FK_PV_TO_ALARM_TREE ON ALARM.PV(COMPONENT_ID) TABLESPACE DIAG_TS LOGGING ; |
| PV.FK_PV_TO_ALARM_TREE Index Columns |
| ColumnName | Sort Order |
| COMPONENT_ID | Ascending |
| PV.FK_PV_TO_ALARM_TREE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | DIAG_TS |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PV.FK_PV_TO_ALARM_TREE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PV.FK_PV_TO_ALARM_TREE Bound Attachments |
| Name | Current Value |
| SEVERITY.PK_SEVERITY |
| TableName | SEVERITY |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SEVERITY.PK_SEVERITY Index Columns |
| ColumnName | Sort Order |
| SEVERITY_ID | Ascending |
| SEVERITY.PK_SEVERITY Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | DIAG_TS |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SEVERITY.PK_SEVERITY Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SEVERITY.PK_SEVERITY Bound Attachments |
| Name | Current Value |
| STATUS.PK_STATUS |
| TableName | STATUS |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| STATUS.PK_STATUS Index Columns |
| ColumnName | Sort Order |
| STATUS_ID | Ascending |
| STATUS.PK_STATUS Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | DIAG_TS |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| STATUS.PK_STATUS Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| STATUS.PK_STATUS Bound Attachments |
| Name | Current Value |