| EQUIP_CAT.EQUIP_CAT_PK |
| TableName | EQUIP_CAT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EQUIP_CAT.EQUIP_CAT_PK Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| EQUIP_CAT.EQUIP_CAT_PK Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EQUIP_CAT.EQUIP_CAT_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EQUIP_CAT.EQUIP_CAT_PK Bound Attachments |
| Name | Current Value |
| SCORE_SNAPSHOT_GRP.PK_SCORE_SNAPSHOT_GRP |
| TableName | SCORE_SNAPSHOT_GRP |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SCORE_SNAPSHOT_GRP.PK_SCORE_SNAPSHOT_GRP Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| MOD_DTE | Ascending |
| SCORE_SNAPSHOT_GRP.PK_SCORE_SNAPSHOT_GRP Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SCORE_SNAPSHOT_GRP.PK_SCORE_SNAPSHOT_GRP Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SCORE_SNAPSHOT_GRP.PK_SCORE_SNAPSHOT_GRP Bound Attachments |
| Name | Current Value |
| SCORE_SNAPSHOT_GRP_SGNL.PK_SCORE_SNAPSHOT_GRP_SGNL |
| TableName | SCORE_SNAPSHOT_GRP_SGNL |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SCORE_SNAPSHOT_GRP_SGNL.PK_SCORE_SNAPSHOT_GRP_SGNL Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| SET_PT_SGNL_ID | Ascending |
| RB_SGNL_ID | Ascending |
| SCORE_SNAPSHOT_GRP_SGNL.PK_SCORE_SNAPSHOT_GRP_SGNL Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SCORE_SNAPSHOT_GRP_SGNL.PK_SCORE_SNAPSHOT_GRP_SGNL Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SCORE_SNAPSHOT_GRP_SGNL.PK_SCORE_SNAPSHOT_GRP_SGNL Bound Attachments |
| Name | Current Value |
| SCORE_SNAPSHOT_SGNL.PK_SCORE_SNAPSHOT_SGNL |
| TableName | SCORE_SNAPSHOT_SGNL |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SCORE_SNAPSHOT_SGNL.PK_SCORE_SNAPSHOT_SGNL Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| MOD_DTE | Ascending |
| RB_SGNL_ID | Ascending |
| SET_PT_SGNL_ID | Ascending |
| SCORE_SNAPSHOT_SGNL.PK_SCORE_SNAPSHOT_SGNL Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SCORE_SNAPSHOT_SGNL.PK_SCORE_SNAPSHOT_SGNL Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SCORE_SNAPSHOT_SGNL.PK_SCORE_SNAPSHOT_SGNL Bound Attachments |
| Name | Current Value |
| SCORE_SNAPSHOT_SGNL.FK_SCORE_SNAPSHOT_GRP |
| TableName | SCORE_SNAPSHOT_SGNL |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX FK_SCORE_SNAPSHOT_GRP ON SCORE_SNAPSHOT_SGNL(EQUIP_CAT_ID, MOD_DTE) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| SCORE_SNAPSHOT_SGNL.FK_SCORE_SNAPSHOT_GRP Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| MOD_DTE | Ascending |
| SCORE_SNAPSHOT_SGNL.FK_SCORE_SNAPSHOT_GRP Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SCORE_SNAPSHOT_SGNL.FK_SCORE_SNAPSHOT_GRP Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SCORE_SNAPSHOT_SGNL.FK_SCORE_SNAPSHOT_GRP Bound Attachments |
| Name | Current Value |
| SCORE_SNAPSHOT_SGNL.FK_SCORE_SNAPSHOT_GRP_SGNL |
| TableName | SCORE_SNAPSHOT_SGNL |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX FK_SCORE_SNAPSHOT_GRP_SGNL ON SCORE_SNAPSHOT_SGNL(EQUIP_CAT_ID, SET_PT_SGNL_ID, RB_SGNL_ID) TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ) ; |
| SCORE_SNAPSHOT_SGNL.FK_SCORE_SNAPSHOT_GRP_SGNL Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| SET_PT_SGNL_ID | Ascending |
| RB_SGNL_ID | Ascending |
| SCORE_SNAPSHOT_SGNL.FK_SCORE_SNAPSHOT_GRP_SGNL Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | EPICS_INDEX_TS |
| PctFree | |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 64 |
| PctIncrease | 0 |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SCORE_SNAPSHOT_SGNL.FK_SCORE_SNAPSHOT_GRP_SGNL Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SCORE_SNAPSHOT_SGNL.FK_SCORE_SNAPSHOT_GRP_SGNL Bound Attachments |
| Name | Current Value |