| ACCEL_PROD_SCHED.PK_ACCEL_PROD_SCHED |
| TableName | ACCEL_PROD_SCHED |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ACCEL_PROD_SCHED.PK_ACCEL_PROD_SCHED Index Columns |
| ColumnName | Sort Order |
| RUN_SCHED_ACT_ID | Ascending |
| START_DTE | Ascending |
| ACCEL_PROD_SCHED.PK_ACCEL_PROD_SCHED Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| ACCEL_PROD_SCHED.PK_ACCEL_PROD_SCHED Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ACCEL_PROD_SCHED.PK_ACCEL_PROD_SCHED Bound Attachments |
| Name | Current Value |
| ACCEL_RUN_SCHED.PK_ACCEL_RUN_SCHED |
| TableName | ACCEL_RUN_SCHED |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ACCEL_RUN_SCHED.PK_ACCEL_RUN_SCHED Index Columns |
| ColumnName | Sort Order |
| ACCEL_RUN_SCHED_ID | Ascending |
| ACCEL_RUN_SCHED.PK_ACCEL_RUN_SCHED Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| ACCEL_RUN_SCHED.PK_ACCEL_RUN_SCHED Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ACCEL_RUN_SCHED.PK_ACCEL_RUN_SCHED Bound Attachments |
| Name | Current Value |
| ACCEL_RUN_SCHED_ACT.PK_RUN_SCHED_ACT |
| TableName | ACCEL_RUN_SCHED_ACT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ACCEL_RUN_SCHED_ACT.PK_RUN_SCHED_ACT Index Columns |
| ColumnName | Sort Order |
| RUN_SCHED_ACT_ID | Ascending |
| ACCEL_RUN_SCHED_ACT.PK_RUN_SCHED_ACT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| ACCEL_RUN_SCHED_ACT.PK_RUN_SCHED_ACT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ACCEL_RUN_SCHED_ACT.PK_RUN_SCHED_ACT Bound Attachments |
| Name | Current Value |
| BEAM_ACCT_ACT_DELIV.BEAM_ACCT_ACT_DELIV_PK |
| TableName | BEAM_ACCT_ACT_DELIV |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | PK_BEAM_ACCT_ACT_DELIV |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BEAM_ACCT_ACT_DELIV.BEAM_ACCT_ACT_DELIV_PK Index Columns |
| ColumnName | Sort Order |
| DELIV_DATE | Ascending |
| DELIV_SHIFT | Ascending |
| DELIV_TYPE | Ascending |
| BEAM_ACCT_ACT_DELIV.BEAM_ACCT_ACT_DELIV_PK Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BEAM_ACCT_ACT_DELIV.BEAM_ACCT_ACT_DELIV_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BEAM_ACCT_ACT_DELIV.BEAM_ACCT_ACT_DELIV_PK Bound Attachments |
| Name | Current Value |
| BEAM_ACCT_ACT_REQ.BEAM_ACCT_ACT_REQ_PK |
| TableName | BEAM_ACCT_ACT_REQ |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | PK_BEAM_ACCT_ACT_REQ |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BEAM_ACCT_ACT_REQ.BEAM_ACCT_ACT_REQ_PK Index Columns |
| ColumnName | Sort Order |
| REQ_DATE | Ascending |
| REQ_SHIFT | Ascending |
| REQ_TYPE | Ascending |
| BEAM_ACCT_ACT_REQ.BEAM_ACCT_ACT_REQ_PK Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BEAM_ACCT_ACT_REQ.BEAM_ACCT_ACT_REQ_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BEAM_ACCT_ACT_REQ.BEAM_ACCT_ACT_REQ_PK Bound Attachments |
| Name | Current Value |
| BEAM_ACCT_DELIV_TYPE.BEAM_ACCT_DELIV_TYPE_PK |
| TableName | BEAM_ACCT_DELIV_TYPE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | PK_BEAM_ACCT_DELIV_TYPE |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BEAM_ACCT_DELIV_TYPE.BEAM_ACCT_DELIV_TYPE_PK Index Columns |
| ColumnName | Sort Order |
| DELIV_TYPE | Ascending |
| BEAM_ACCT_DELIV_TYPE.BEAM_ACCT_DELIV_TYPE_PK Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BEAM_ACCT_DELIV_TYPE.BEAM_ACCT_DELIV_TYPE_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BEAM_ACCT_DELIV_TYPE.BEAM_ACCT_DELIV_TYPE_PK Bound Attachments |
| Name | Current Value |
| BEAM_ACCT_REQ_TYPE.BEAM_ACCT_REQ_TYPE_PK |
| TableName | BEAM_ACCT_REQ_TYPE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | PK_BEAM_ACCT_REQ_TYPE |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BEAM_ACCT_REQ_TYPE.BEAM_ACCT_REQ_TYPE_PK Index Columns |
| ColumnName | Sort Order |
| REQ_TYPE | Ascending |
| BEAM_ACCT_REQ_TYPE.BEAM_ACCT_REQ_TYPE_PK Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BEAM_ACCT_REQ_TYPE.BEAM_ACCT_REQ_TYPE_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BEAM_ACCT_REQ_TYPE.BEAM_ACCT_REQ_TYPE_PK Bound Attachments |
| Name | Current Value |
| BEAM_ACCT_RPT_PERIOD.BEAM_ACCT_RPT_PERIOD_PK |
| TableName | BEAM_ACCT_RPT_PERIOD |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | PK_BEAM_ACCT_RPT_PERIOD |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BEAM_ACCT_RPT_PERIOD.BEAM_ACCT_RPT_PERIOD_PK Index Columns |
| ColumnName | Sort Order |
| PERIOD_ID | Ascending |
| BEAM_ACCT_RPT_PERIOD.BEAM_ACCT_RPT_PERIOD_PK Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BEAM_ACCT_RPT_PERIOD.BEAM_ACCT_RPT_PERIOD_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BEAM_ACCT_RPT_PERIOD.BEAM_ACCT_RPT_PERIOD_PK Bound Attachments |
| Name | Current Value |
| BEAM_DOWNTIME_ACCT.beam_downtime_acct_pk |
| TableName | BEAM_DOWNTIME_ACCT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BEAM_DOWNTIME_ACCT.beam_downtime_acct_pk Index Columns |
| ColumnName | Sort Order |
| OPER_GRP_ID | Ascending |
| OPER_SUBGRP1_ID | Ascending |
| downtime_dte | Ascending |
| BEAM_DOWNTIME_ACCT.beam_downtime_acct_pk Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| BEAM_DOWNTIME_ACCT.beam_downtime_acct_pk Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BEAM_DOWNTIME_ACCT.beam_downtime_acct_pk Bound Attachments |
| Name | Current Value |
| BYPASS_DVC.PK_BYPASS_DVC |
| TableName | BYPASS_DVC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BYPASS_DVC.PK_BYPASS_DVC Index Columns |
| ColumnName | Sort Order |
| BYPASS_NBR | Ascending |
| DVC_ID | Ascending |
| BYPASS_DVC.PK_BYPASS_DVC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| BYPASS_DVC.PK_BYPASS_DVC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BYPASS_DVC.PK_BYPASS_DVC Bound Attachments |
| Name | Current Value |
| BYPASS_IMG.PK_BYPASS_IMG |
| TableName | BYPASS_IMG |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BYPASS_IMG.PK_BYPASS_IMG Index Columns |
| ColumnName | Sort Order |
| BYPASS_NBR | Ascending |
| SEQ_ID | Ascending |
| BYPASS_IMG.PK_BYPASS_IMG Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| BYPASS_IMG.PK_BYPASS_IMG Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BYPASS_IMG.PK_BYPASS_IMG Bound Attachments |
| Name | Current Value |
| BYPASS_MECH.PK_BYPASS_MECH |
| TableName | BYPASS_MECH |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BYPASS_MECH.PK_BYPASS_MECH Index Columns |
| ColumnName | Sort Order |
| BYPASS_MECH_NM | Ascending |
| BYPASS_MECH.PK_BYPASS_MECH Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| BYPASS_MECH.PK_BYPASS_MECH Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BYPASS_MECH.PK_BYPASS_MECH Bound Attachments |
| Name | Current Value |
| BYPASS_REQ.PK_BYPASS_REQ |
| TableName | BYPASS_REQ |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BYPASS_REQ.PK_BYPASS_REQ Index Columns |
| ColumnName | Sort Order |
| BYPASS_NBR | Ascending |
| BYPASS_REQ.PK_BYPASS_REQ Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| BYPASS_REQ.PK_BYPASS_REQ Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BYPASS_REQ.PK_BYPASS_REQ Bound Attachments |
| Name | Current Value |
| Call_List_Grp_Note.PK_CALL_LIST_GRP_NOTE |
| TableName | Call_List_Grp_Note |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| Call_List_Grp_Note.PK_CALL_LIST_GRP_NOTE Index Columns |
| ColumnName | Sort Order |
| OPER_GRP_ID | Ascending |
| Call_List_Grp_Note.PK_CALL_LIST_GRP_NOTE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| Call_List_Grp_Note.PK_CALL_LIST_GRP_NOTE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| Call_List_Grp_Note.PK_CALL_LIST_GRP_NOTE Bound Attachments |
| Name | Current Value |
| Call_List_SubGrp_Note.PK_CALL_LIST_SUBGRP_NOTE |
| TableName | Call_List_SubGrp_Note |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| Call_List_SubGrp_Note.PK_CALL_LIST_SUBGRP_NOTE Index Columns |
| ColumnName | Sort Order |
| OPER_GRP_ID | Ascending |
| Equip Subcat Id | Ascending |
| Call_List_SubGrp_Note.PK_CALL_LIST_SUBGRP_NOTE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| Call_List_SubGrp_Note.PK_CALL_LIST_SUBGRP_NOTE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| Call_List_SubGrp_Note.PK_CALL_LIST_SUBGRP_NOTE Bound Attachments |
| Name | Current Value |
| CHKLST.chklst_pk |
| TableName | CHKLST |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | PK_CHKLST |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CHKLST.chklst_pk Index Columns |
| ColumnName | Sort Order |
| Chklst Id | Ascending |
| Chklst Rev | Ascending |
| CHKLST.chklst_pk Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CHKLST.chklst_pk Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CHKLST.chklst_pk Bound Attachments |
| Name | Current Value |
| CHKLST_STEP.chklst_step_pk |
| TableName | CHKLST_STEP |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | PK_CHKLST_STEP |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CHKLST_STEP.chklst_step_pk Index Columns |
| ColumnName | Sort Order |
| Chklst Id | Ascending |
| Chklst Rev | Ascending |
| Step Nbr | Ascending |
| CHKLST_STEP.chklst_step_pk Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CHKLST_STEP.chklst_step_pk Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CHKLST_STEP.chklst_step_pk Bound Attachments |
| Name | Current Value |
| DELEG.PK_DELEG |
| TableName | DELEG |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DELEG.PK_DELEG Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| START_DTE | Ascending |
| DELEG_START_DTE | Ascending |
| DELEG.PK_DELEG Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| DELEG.PK_DELEG Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DELEG.PK_DELEG Bound Attachments |
| Name | Current Value |
| DELEG_OF_AUTH.PK_DELEG_OF_AUTH |
| TableName | DELEG_OF_AUTH |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DELEG_OF_AUTH.PK_DELEG_OF_AUTH Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| DELEG_OF_AUTH.PK_DELEG_OF_AUTH Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| DELEG_OF_AUTH.PK_DELEG_OF_AUTH Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DELEG_OF_AUTH.PK_DELEG_OF_AUTH Bound Attachments |
| Name | Current Value |
| DELEG_OF_AUTH_NOTIF.PK_DELEG_OF_AUTH_NOTIF |
| TableName | DELEG_OF_AUTH_NOTIF |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DELEG_OF_AUTH_NOTIF.PK_DELEG_OF_AUTH_NOTIF Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| NOTIF_BN | Ascending |
| DELEG_OF_AUTH_NOTIF.PK_DELEG_OF_AUTH_NOTIF Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| DELEG_OF_AUTH_NOTIF.PK_DELEG_OF_AUTH_NOTIF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DELEG_OF_AUTH_NOTIF.PK_DELEG_OF_AUTH_NOTIF Bound Attachments |
| Name | Current Value |
| DELEG_PER.PK_DELEG_PER |
| TableName | DELEG_PER |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DELEG_PER.PK_DELEG_PER Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| START_DTE | Ascending |
| DELEG_PER.PK_DELEG_PER Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| DELEG_PER.PK_DELEG_PER Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DELEG_PER.PK_DELEG_PER Bound Attachments |
| Name | Current Value |
| DELEG_PROXY.PK_DELEG_PROXY |
| TableName | DELEG_PROXY |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DELEG_PROXY.PK_DELEG_PROXY Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| PROX_BN | Ascending |
| DELEG_PROXY.PK_DELEG_PROXY Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| DELEG_PROXY.PK_DELEG_PROXY Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DELEG_PROXY.PK_DELEG_PROXY Bound Attachments |
| Name | Current Value |
| DOWNTIME_EVT.PK_DOWNTIME_EVT |
| TableName | DOWNTIME_EVT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DOWNTIME_EVT.PK_DOWNTIME_EVT Index Columns |
| ColumnName | Sort Order |
| DOWNTIME_EVT_ID | Ascending |
| DOWNTIME_EVT.PK_DOWNTIME_EVT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| DOWNTIME_EVT.PK_DOWNTIME_EVT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DOWNTIME_EVT.PK_DOWNTIME_EVT Bound Attachments |
| Name | Current Value |
| DOWNTIME_TIMER.PK_DOWNTIME_TIMER |
| TableName | DOWNTIME_TIMER |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DOWNTIME_TIMER.PK_DOWNTIME_TIMER Index Columns |
| ColumnName | Sort Order |
| SEQ_ID | Ascending |
| DOWNTIME_TIMER.PK_DOWNTIME_TIMER Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| DOWNTIME_TIMER.PK_DOWNTIME_TIMER Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DOWNTIME_TIMER.PK_DOWNTIME_TIMER Bound Attachments |
| Name | Current Value |
| DOWNTIME_TIMER_EVT.PK_DOWNTIME_TIMER_EVT |
| TableName | DOWNTIME_TIMER_EVT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DOWNTIME_TIMER_EVT.PK_DOWNTIME_TIMER_EVT Index Columns |
| ColumnName | Sort Order |
| DT_TIMER_EVT_ID | Ascending |
| DOWNTIME_TIMER_EVT.PK_DOWNTIME_TIMER_EVT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| DOWNTIME_TIMER_EVT.PK_DOWNTIME_TIMER_EVT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DOWNTIME_TIMER_EVT.PK_DOWNTIME_TIMER_EVT Bound Attachments |
| Name | Current Value |
| DT_TIMER_ACCT_ASSC.PK_DT_TIMER_ACCT_ASSC |
| TableName | DT_TIMER_ACCT_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DT_TIMER_ACCT_ASSC.PK_DT_TIMER_ACCT_ASSC Index Columns |
| ColumnName | Sort Order |
| OPER_GRP_ID | Ascending |
| OPER_SUBGRP1_ID | Ascending |
| downtime_dte | Ascending |
| timer_seq_id | Ascending |
| DT_TIMER_ACCT_ASSC.PK_DT_TIMER_ACCT_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| DT_TIMER_ACCT_ASSC.PK_DT_TIMER_ACCT_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DT_TIMER_ACCT_ASSC.PK_DT_TIMER_ACCT_ASSC Bound Attachments |
| Name | Current Value |
| DT_TIMER_EVT_ASSC.PK_DT_TIMER_EVT_ASSC |
| TableName | DT_TIMER_EVT_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DT_TIMER_EVT_ASSC.PK_DT_TIMER_EVT_ASSC Index Columns |
| ColumnName | Sort Order |
| DT_TIMER_EVT_ID | Ascending |
| SEQ_ID | Ascending |
| DT_TIMER_EVT_ASSC.PK_DT_TIMER_EVT_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| DT_TIMER_EVT_ASSC.PK_DT_TIMER_EVT_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DT_TIMER_EVT_ASSC.PK_DT_TIMER_EVT_ASSC Bound Attachments |
| Name | Current Value |
| DVC_OUTAGE.PK_DVC_OUTAGE |
| TableName | DVC_OUTAGE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DVC_OUTAGE.PK_DVC_OUTAGE Index Columns |
| ColumnName | Sort Order |
| DVC_ID | Ascending |
| OUTAGE_DTE | Ascending |
| DVC_OUTAGE.PK_DVC_OUTAGE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| DVC_OUTAGE.PK_DVC_OUTAGE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DVC_OUTAGE.PK_DVC_OUTAGE Bound Attachments |
| Name | Current Value |
| EMPLOYEE.PK_EMPLOYEE |
| TableName | EMPLOYEE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EMPLOYEE.PK_EMPLOYEE Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| EMPLOYEE.PK_EMPLOYEE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| EMPLOYEE.PK_EMPLOYEE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMPLOYEE.PK_EMPLOYEE Bound Attachments |
| Name | Current Value |
| FISCAL_YEAR.PK_FISCAL_YEAR |
| TableName | FISCAL_YEAR |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| FISCAL_YEAR.PK_FISCAL_YEAR Index Columns |
| ColumnName | Sort Order |
| FY_ID | Ascending |
| FISCAL_YEAR.PK_FISCAL_YEAR Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| FISCAL_YEAR.PK_FISCAL_YEAR Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| FISCAL_YEAR.PK_FISCAL_YEAR Bound Attachments |
| Name | Current Value |
| HOLIDAY.PK_HOLIDAY |
| TableName | HOLIDAY |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| HOLIDAY.PK_HOLIDAY Index Columns |
| ColumnName | Sort Order |
| NM | Ascending |
| HOLIDAY.PK_HOLIDAY Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| HOLIDAY.PK_HOLIDAY Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| HOLIDAY.PK_HOLIDAY Bound Attachments |
| Name | Current Value |
| HOLIDAY_SCHED.PK_HOLIDAY_SCHED |
| TableName | HOLIDAY_SCHED |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| HOLIDAY_SCHED.PK_HOLIDAY_SCHED Index Columns |
| ColumnName | Sort Order |
| NM | Ascending |
| HOLIDAY_DTE | Ascending |
| HOLIDAY_SCHED.PK_HOLIDAY_SCHED Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| HOLIDAY_SCHED.PK_HOLIDAY_SCHED Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| HOLIDAY_SCHED.PK_HOLIDAY_SCHED Bound Attachments |
| Name | Current Value |
| JOB_TITLE.PK_JOB_TITLE |
| TableName | JOB_TITLE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| JOB_TITLE.PK_JOB_TITLE Index Columns |
| ColumnName | Sort Order |
| JOB_TITLE_ID | Ascending |
| JOB_TITLE.PK_JOB_TITLE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| JOB_TITLE.PK_JOB_TITLE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| JOB_TITLE.PK_JOB_TITLE Bound Attachments |
| Name | Current Value |
| MSG_CHAN.PK_MSG_CHAN |
| TableName | MSG_CHAN |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| MSG_CHAN.PK_MSG_CHAN Index Columns |
| ColumnName | Sort Order |
| MSG_CHAN_ID | Ascending |
| MSG_CHAN.PK_MSG_CHAN Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| MSG_CHAN.PK_MSG_CHAN Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MSG_CHAN.PK_MSG_CHAN Bound Attachments |
| Name | Current Value |
| MSG_CHAN_ACCESS.PK_MSG_CHAN_ACCESS |
| TableName | MSG_CHAN_ACCESS |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| MSG_CHAN_ACCESS.PK_MSG_CHAN_ACCESS Index Columns |
| ColumnName | Sort Order |
| ACCESS_ID | Ascending |
| MSG_CHAN_ACCESS.PK_MSG_CHAN_ACCESS Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| MSG_CHAN_ACCESS.PK_MSG_CHAN_ACCESS Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MSG_CHAN_ACCESS.PK_MSG_CHAN_ACCESS Bound Attachments |
| Name | Current Value |
| MSG_CHAN_MSG.IDX_MSG_CHANG_ID |
| TableName | MSG_CHAN_MSG |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX OPER.IDX_MSG_CHANG_ID ON OPER.MSG_CHAN_MSG(MSG_CHAN_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE OPER LOGGING STORAGE(INITIAL 256K NEXT 1024K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) ; |
| MSG_CHAN_MSG.IDX_MSG_CHANG_ID Index Columns |
| ColumnName | Sort Order |
| MSG_CHAN_ID | Ascending |
| MSG_CHAN_MSG.IDX_MSG_CHANG_ID Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| MSG_CHAN_MSG.IDX_MSG_CHANG_ID Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MSG_CHAN_MSG.IDX_MSG_CHANG_ID Bound Attachments |
| Name | Current Value |
| MSG_CHAN_MSG.PK_MSG_CHAN_MSG |
| TableName | MSG_CHAN_MSG |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| MSG_CHAN_MSG.PK_MSG_CHAN_MSG Index Columns |
| ColumnName | Sort Order |
| MSG_ID | Ascending |
| MSG_CHAN_MSG.PK_MSG_CHAN_MSG Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| MSG_CHAN_MSG.PK_MSG_CHAN_MSG Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MSG_CHAN_MSG.PK_MSG_CHAN_MSG Bound Attachments |
| Name | Current Value |
| NSSD_ROOM.PK_NSSD_ROOM |
| TableName | NSSD_ROOM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| NSSD_ROOM.PK_NSSD_ROOM Index Columns |
| ColumnName | Sort Order |
| BUILDING | Ascending |
| ROOM | Ascending |
| NSSD_ROOM.PK_NSSD_ROOM Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| NSSD_ROOM.PK_NSSD_ROOM Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| NSSD_ROOM.PK_NSSD_ROOM Bound Attachments |
| Name | Current Value |
| OPER_ACT.PK_RUN_CYCLE_PER |
| TableName | OPER_ACT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPER_ACT.PK_RUN_CYCLE_PER Index Columns |
| ColumnName | Sort Order |
| ACT_ID | Ascending |
| OPER_ACT.PK_RUN_CYCLE_PER Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| OPER_ACT.PK_RUN_CYCLE_PER Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPER_ACT.PK_RUN_CYCLE_PER Bound Attachments |
| Name | Current Value |
| OPER_GRP.PK_OPER_GRP |
| TableName | OPER_GRP |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPER_GRP.PK_OPER_GRP Index Columns |
| ColumnName | Sort Order |
| OPER_GRP_ID | Ascending |
| OPER_GRP.PK_OPER_GRP Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| OPER_GRP.PK_OPER_GRP Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPER_GRP.PK_OPER_GRP Bound Attachments |
| Name | Current Value |
| OPER_PROC_MAN.PK_OPER_PROC_MAN |
| TableName | OPER_PROC_MAN |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPER_PROC_MAN.PK_OPER_PROC_MAN Index Columns |
| ColumnName | Sort Order |
| OPER_PROC_MAN_ID | Ascending |
| OPER_PROC_MAN.PK_OPER_PROC_MAN Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| OPER_PROC_MAN.PK_OPER_PROC_MAN Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPER_PROC_MAN.PK_OPER_PROC_MAN Bound Attachments |
| Name | Current Value |
| OPER_PROC_MAN_REV.PK_OPER_PROC_MAN_REV |
| TableName | OPER_PROC_MAN_REV |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPER_PROC_MAN_REV.PK_OPER_PROC_MAN_REV Index Columns |
| ColumnName | Sort Order |
| OPER_PROC_MAN_ID | Ascending |
| REV_NBR | Ascending |
| OPER_PROC_MAN_REV.PK_OPER_PROC_MAN_REV Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| OPER_PROC_MAN_REV.PK_OPER_PROC_MAN_REV Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPER_PROC_MAN_REV.PK_OPER_PROC_MAN_REV Bound Attachments |
| Name | Current Value |
| OPER_STAT.PK_OPER_STAT |
| TableName | OPER_STAT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPER_STAT.PK_OPER_STAT Index Columns |
| ColumnName | Sort Order |
| OPER_STAT_ID | Ascending |
| OPER_STAT.PK_OPER_STAT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| OPER_STAT.PK_OPER_STAT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPER_STAT.PK_OPER_STAT Bound Attachments |
| Name | Current Value |
| OPER_STATE.PK_OPER_STATE |
| TableName | OPER_STATE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPER_STATE.PK_OPER_STATE Index Columns |
| ColumnName | Sort Order |
| CUR_STATE_DTE | Ascending |
| OPER_STATE.PK_OPER_STATE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| OPER_STATE.PK_OPER_STATE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPER_STATE.PK_OPER_STATE Bound Attachments |
| Name | Current Value |
| OPER_SUBGRP1.pk_oper_subgrp1 |
| TableName | OPER_SUBGRP1 |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPER_SUBGRP1.pk_oper_subgrp1 Index Columns |
| ColumnName | Sort Order |
| OPER_GRP_ID | Ascending |
| OPER_SUBGRP1_ID | Ascending |
| OPER_SUBGRP1.pk_oper_subgrp1 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| OPER_SUBGRP1.pk_oper_subgrp1 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPER_SUBGRP1.pk_oper_subgrp1 Bound Attachments |
| Name | Current Value |
| OPER_SUBGRP2.PK_OPER_SBGRP2 |
| TableName | OPER_SUBGRP2 |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPER_SUBGRP2.PK_OPER_SBGRP2 Index Columns |
| ColumnName | Sort Order |
| OPER_GRP_ID | Ascending |
| OPER_SUBGRP1_ID | Ascending |
| OPER_SUBGRP2_ID | Ascending |
| OPER_SUBGRP2.PK_OPER_SBGRP2 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| OPER_SUBGRP2.PK_OPER_SBGRP2 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPER_SUBGRP2.PK_OPER_SBGRP2 Bound Attachments |
| Name | Current Value |
| OPER_SUBGRP3.PK_OPER_SUBGRP3 |
| TableName | OPER_SUBGRP3 |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | PK_OPER_SUBGRP3 |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPER_SUBGRP3.PK_OPER_SUBGRP3 Index Columns |
| ColumnName | Sort Order |
| OPER_GRP_ID | Ascending |
| OPER_SUBGRP1_ID | Ascending |
| OPER_SUBGRP2_ID | Ascending |
| OPER_SUBGRP3_ID | Ascending |
| OPER_SUBGRP3.PK_OPER_SUBGRP3 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| OPER_SUBGRP3.PK_OPER_SUBGRP3 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPER_SUBGRP3.PK_OPER_SUBGRP3 Bound Attachments |
| Name | Current Value |
| OPER_SUBGRP4.PK_OPER_SUBGRP4 |
| TableName | OPER_SUBGRP4 |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPER_SUBGRP4.PK_OPER_SUBGRP4 Index Columns |
| ColumnName | Sort Order |
| OPER_GRP_ID | Ascending |
| OPER_SUBGRP1_ID | Ascending |
| OPER_SUBGRP2_ID | Ascending |
| OPER_SUBGRP3_ID | Ascending |
| OPER_SUBGRP4_ID | Ascending |
| OPER_SUBGRP4.PK_OPER_SUBGRP4 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| OPER_SUBGRP4.PK_OPER_SUBGRP4 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPER_SUBGRP4.PK_OPER_SUBGRP4 Bound Attachments |
| Name | Current Value |
| OPER_SUBGRP5.PK_OPER_SUBGRP5 |
| TableName | OPER_SUBGRP5 |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPER_SUBGRP5.PK_OPER_SUBGRP5 Index Columns |
| ColumnName | Sort Order |
| OPER_GRP_ID | Ascending |
| OPER_SUBGRP1_ID | Ascending |
| OPER_SUBGRP2_ID | Ascending |
| OPER_SUBGRP3_ID | Ascending |
| OPER_SUBGRP4_ID | Ascending |
| OPER_SUBGRP5_ID | Ascending |
| OPER_SUBGRP5.PK_OPER_SUBGRP5 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| OPER_SUBGRP5.PK_OPER_SUBGRP5 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPER_SUBGRP5.PK_OPER_SUBGRP5 Bound Attachments |
| Name | Current Value |
| OPM_AUTHOR_ASSC.PK_OPM_AUTHOR_ASSC |
| TableName | OPM_AUTHOR_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPM_AUTHOR_ASSC.PK_OPM_AUTHOR_ASSC Index Columns |
| ColumnName | Sort Order |
| OPER_PROC_MAN_ID | Ascending |
| REV_NBR | Ascending |
| BN | Ascending |
| OPM_AUTHOR_ASSC.PK_OPM_AUTHOR_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| OPM_AUTHOR_ASSC.PK_OPM_AUTHOR_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPM_AUTHOR_ASSC.PK_OPM_AUTHOR_ASSC Bound Attachments |
| Name | Current Value |
| OPM_CHAP.PK_OPM_CHAP |
| TableName | OPM_CHAP |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPM_CHAP.PK_OPM_CHAP Index Columns |
| ColumnName | Sort Order |
| OPER_PROC_MAN_ID | Ascending |
| REV_NBR | Ascending |
| CHAP_NBR | Ascending |
| OPM_CHAP.PK_OPM_CHAP Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| OPM_CHAP.PK_OPM_CHAP Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPM_CHAP.PK_OPM_CHAP Bound Attachments |
| Name | Current Value |
| OPM_GRP.PK_OPM_GRP |
| TableName | OPM_GRP |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPM_GRP.PK_OPM_GRP Index Columns |
| ColumnName | Sort Order |
| GRP_ID | Ascending |
| OPM_GRP.PK_OPM_GRP Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| OPM_GRP.PK_OPM_GRP Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPM_GRP.PK_OPM_GRP Bound Attachments |
| Name | Current Value |
| OPM_REVIEW_STAT.PK_OPM_REVIEW_STAT |
| TableName | OPM_REVIEW_STAT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPM_REVIEW_STAT.PK_OPM_REVIEW_STAT Index Columns |
| ColumnName | Sort Order |
| REVIEW_STAT_ID | Ascending |
| OPM_REVIEW_STAT.PK_OPM_REVIEW_STAT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| OPM_REVIEW_STAT.PK_OPM_REVIEW_STAT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPM_REVIEW_STAT.PK_OPM_REVIEW_STAT Bound Attachments |
| Name | Current Value |
| OPM_REVIEWER_ASSC.PK_OPM_REVIEWER_ASSC |
| TableName | OPM_REVIEWER_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPM_REVIEWER_ASSC.PK_OPM_REVIEWER_ASSC Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| OPER_PROC_MAN_ID | Ascending |
| REV_NBR | Ascending |
| OPM_REVIEWER_ASSC.PK_OPM_REVIEWER_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| OPM_REVIEWER_ASSC.PK_OPM_REVIEWER_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPM_REVIEWER_ASSC.PK_OPM_REVIEWER_ASSC Bound Attachments |
| Name | Current Value |
| OPR_CHKLST.opr_chklst_pk |
| TableName | OPR_CHKLST |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | PK_OPR_CHKLST |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPR_CHKLST.opr_chklst_pk Index Columns |
| ColumnName | Sort Order |
| Chklst Id | Ascending |
| Chklst Rev | Ascending |
| Chklst Dte | Ascending |
| OPR_CHKLST.opr_chklst_pk Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| OPR_CHKLST.opr_chklst_pk Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPR_CHKLST.opr_chklst_pk Bound Attachments |
| Name | Current Value |
| OPR_CHKLST_ITEM.opr_chklst_item_pk |
| TableName | OPR_CHKLST_ITEM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | PK_OPR_CHKLST_ITEM |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPR_CHKLST_ITEM.opr_chklst_item_pk Index Columns |
| ColumnName | Sort Order |
| Chklst Id | Ascending |
| Chklst Rev | Ascending |
| Chklst Dte | Ascending |
| Step Nbr | Ascending |
| OPR_CHKLST_ITEM.opr_chklst_item_pk Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| OPR_CHKLST_ITEM.opr_chklst_item_pk Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPR_CHKLST_ITEM.opr_chklst_item_pk Bound Attachments |
| Name | Current Value |
| ORG_MATRIX.PK_ORG_MATRIX |
| TableName | ORG_MATRIX |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ORG_MATRIX.PK_ORG_MATRIX Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| ORG_MATRIX.PK_ORG_MATRIX Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| ORG_MATRIX.PK_ORG_MATRIX Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ORG_MATRIX.PK_ORG_MATRIX Bound Attachments |
| Name | Current Value |
| PERS_LOC.PK_PERS_LOC |
| TableName | PERS_LOC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PERS_LOC.PK_PERS_LOC Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| START_DTE | Ascending |
| PERS_LOC.PK_PERS_LOC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| PERS_LOC.PK_PERS_LOC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PERS_LOC.PK_PERS_LOC Bound Attachments |
| Name | Current Value |
| PERS_ROLE_EQUIP_CAT_ASGN.PK_PERS_ROLE_EQUIP_CAT |
| TableName | PERS_ROLE_EQUIP_CAT_ASGN |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PERS_ROLE_EQUIP_CAT_ASGN.PK_PERS_ROLE_EQUIP_CAT Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| BN | Ascending |
| BN | Ascending |
| PERS_ROLE_EQUIP_CAT_ASGN.PK_PERS_ROLE_EQUIP_CAT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PERS_ROLE_EQUIP_CAT_ASGN.PK_PERS_ROLE_EQUIP_CAT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PERS_ROLE_EQUIP_CAT_ASGN.PK_PERS_ROLE_EQUIP_CAT Bound Attachments |
| Name | Current Value |
| PERS_ROLE_EQUIP_SUBCAT_ASGN.PK_PERS_ROLE_EQUIP_SUBCAT_ASGN |
| TableName | PERS_ROLE_EQUIP_SUBCAT_ASGN |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PERS_ROLE_EQUIP_SUBCAT_ASGN.PK_PERS_ROLE_EQUIP_SUBCAT_ASGN Index Columns |
| ColumnName | Sort Order |
| EQUIP_CAT_ID | Ascending |
| EQUIP_SUBCAT_ID | Ascending |
| BN | Ascending |
| PERS_ROLE_EQUIP_SUBCAT_ASGN.PK_PERS_ROLE_EQUIP_SUBCAT_ASGN Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| PERS_ROLE_EQUIP_SUBCAT_ASGN.PK_PERS_ROLE_EQUIP_SUBCAT_ASGN Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PERS_ROLE_EQUIP_SUBCAT_ASGN.PK_PERS_ROLE_EQUIP_SUBCAT_ASGN Bound Attachments |
| Name | Current Value |
| PERS_ROLES.pers_roles_pk |
| TableName | PERS_ROLES |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PERS_ROLES.pers_roles_pk Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| PERS_ROLES.pers_roles_pk Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PERS_ROLES.pers_roles_pk Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PERS_ROLES.pers_roles_pk Bound Attachments |
| Name | Current Value |
| RAD_AREA.PK_RAD_AREA |
| TableName | RAD_AREA |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| RAD_AREA.PK_RAD_AREA Index Columns |
| ColumnName | Sort Order |
| AREA_ID | Ascending |
| RAD_AREA.PK_RAD_AREA Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| RAD_AREA.PK_RAD_AREA Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| RAD_AREA.PK_RAD_AREA Bound Attachments |
| Name | Current Value |
| RAD_AREA_ROLE.PK_RAD_AREA_ROLE |
| TableName | RAD_AREA_ROLE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| RAD_AREA_ROLE.PK_RAD_AREA_ROLE Index Columns |
| ColumnName | Sort Order |
| ROLE_ID | Ascending |
| RAD_AREA_ROLE.PK_RAD_AREA_ROLE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| RAD_AREA_ROLE.PK_RAD_AREA_ROLE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| RAD_AREA_ROLE.PK_RAD_AREA_ROLE Bound Attachments |
| Name | Current Value |
| RAD_AREA_ROLE_ASGN.PK_RAD_AREA_ASGN |
| TableName | RAD_AREA_ROLE_ASGN |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| RAD_AREA_ROLE_ASGN.PK_RAD_AREA_ASGN Index Columns |
| ColumnName | Sort Order |
| AREA_ID | Ascending |
| ROLE_ID | Ascending |
| BN | Ascending |
| RAD_AREA_ROLE_ASGN.PK_RAD_AREA_ASGN Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| RAD_AREA_ROLE_ASGN.PK_RAD_AREA_ASGN Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| RAD_AREA_ROLE_ASGN.PK_RAD_AREA_ASGN Bound Attachments |
| Name | Current Value |
| REAC_FUEL_CYC.PK_REAC_FULE_CYC |
| TableName | REAC_FUEL_CYC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| REAC_FUEL_CYC.PK_REAC_FULE_CYC Index Columns |
| ColumnName | Sort Order |
| FUEL_CYC_ID | Ascending |
| REAC_FUEL_CYC.PK_REAC_FULE_CYC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| REAC_FUEL_CYC.PK_REAC_FULE_CYC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| REAC_FUEL_CYC.PK_REAC_FULE_CYC Bound Attachments |
| Name | Current Value |
| REAC_OPER_ACT.PK_REAC_OPER_ACT |
| TableName | REAC_OPER_ACT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| REAC_OPER_ACT.PK_REAC_OPER_ACT Index Columns |
| ColumnName | Sort Order |
| ACT_TYPE_ID | Ascending |
| REAC_OPER_ACT.PK_REAC_OPER_ACT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| REAC_OPER_ACT.PK_REAC_OPER_ACT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| REAC_OPER_ACT.PK_REAC_OPER_ACT Bound Attachments |
| Name | Current Value |
| REAC_RUN_SCHED.PK_REAC_RUN_SCHED |
| TableName | REAC_RUN_SCHED |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| REAC_RUN_SCHED.PK_REAC_RUN_SCHED Index Columns |
| ColumnName | Sort Order |
| FUEL_CYC_ID | Ascending |
| ACT_TYPE_ID | Ascending |
| START_DTE | Ascending |
| REAC_RUN_SCHED.PK_REAC_RUN_SCHED Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| REAC_RUN_SCHED.PK_REAC_RUN_SCHED Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| REAC_RUN_SCHED.PK_REAC_RUN_SCHED Bound Attachments |
| Name | Current Value |
| RUN_SCHED_STAT.PK_RUN_SCHED_STAT |
| TableName | RUN_SCHED_STAT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| RUN_SCHED_STAT.PK_RUN_SCHED_STAT Index Columns |
| ColumnName | Sort Order |
| STAT_ID | Ascending |
| RUN_SCHED_STAT.PK_RUN_SCHED_STAT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| RUN_SCHED_STAT.PK_RUN_SCHED_STAT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| RUN_SCHED_STAT.PK_RUN_SCHED_STAT Bound Attachments |
| Name | Current Value |
| SHIFT.PK_SHIFT |
| TableName | SHIFT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SHIFT.PK_SHIFT Index Columns |
| ColumnName | Sort Order |
| SHIFT_ID | Ascending |
| SHIFT.PK_SHIFT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| SHIFT.PK_SHIFT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SHIFT.PK_SHIFT Bound Attachments |
| Name | Current Value |
| SHIFT_ACT.PK_SHIFT_ACT |
| TableName | SHIFT_ACT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SHIFT_ACT.PK_SHIFT_ACT Index Columns |
| ColumnName | Sort Order |
| SHIFT_ACT_ID | Ascending |
| SHIFT_ACT.PK_SHIFT_ACT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| SHIFT_ACT.PK_SHIFT_ACT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SHIFT_ACT.PK_SHIFT_ACT Bound Attachments |
| Name | Current Value |
| SHIFT_HOLI_SCHED.PK_SHIFT_HOLI_SCHED |
| TableName | SHIFT_HOLI_SCHED |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SHIFT_HOLI_SCHED.PK_SHIFT_HOLI_SCHED Index Columns |
| ColumnName | Sort Order |
| SHIFT_ID | Ascending |
| CAL_DTE | Ascending |
| SHIFT_HOLI_SCHED.PK_SHIFT_HOLI_SCHED Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| SHIFT_HOLI_SCHED.PK_SHIFT_HOLI_SCHED Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SHIFT_HOLI_SCHED.PK_SHIFT_HOLI_SCHED Bound Attachments |
| Name | Current Value |
| SHIFT_SCHED_WORK_ASGN.PK_SHIFT_PERS_ASGN |
| TableName | SHIFT_SCHED_WORK_ASGN |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SHIFT_SCHED_WORK_ASGN.PK_SHIFT_PERS_ASGN Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| SHIFT_ID | Ascending |
| CAL_DTE | Ascending |
| SHIFT_SCHED_WORK_ASGN.PK_SHIFT_PERS_ASGN Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SHIFT_SCHED_WORK_ASGN.PK_SHIFT_PERS_ASGN Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SHIFT_SCHED_WORK_ASGN.PK_SHIFT_PERS_ASGN Bound Attachments |
| Name | Current Value |
| SHIFT_SUM_PROC_VAR_ASSC.PK_SHIFT_SUM_PROC_VAR_ASSC |
| TableName | SHIFT_SUM_PROC_VAR_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SHIFT_SUM_PROC_VAR_ASSC.PK_SHIFT_SUM_PROC_VAR_ASSC Index Columns |
| ColumnName | Sort Order |
| SHIFT_ID | Ascending |
| CAL_DTE | Ascending |
| SGNL_ID | Ascending |
| SHIFT_SUM_PROC_VAR_ASSC.PK_SHIFT_SUM_PROC_VAR_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| SHIFT_SUM_PROC_VAR_ASSC.PK_SHIFT_SUM_PROC_VAR_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SHIFT_SUM_PROC_VAR_ASSC.PK_SHIFT_SUM_PROC_VAR_ASSC Bound Attachments |
| Name | Current Value |
| SHIFT_SUMM.PK_SHIFT_SUMM |
| TableName | SHIFT_SUMM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SHIFT_SUMM.PK_SHIFT_SUMM Index Columns |
| ColumnName | Sort Order |
| SHIFT_ID | Ascending |
| CAL_DTE | Ascending |
| SHIFT_SUMM.PK_SHIFT_SUMM Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SHIFT_SUMM.PK_SHIFT_SUMM Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SHIFT_SUMM.PK_SHIFT_SUMM Bound Attachments |
| Name | Current Value |
| SHIFT_SUMM_FILE_ATTACH.PK_SHIFT_SUMM_FILE_ATTACH |
| TableName | SHIFT_SUMM_FILE_ATTACH |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SHIFT_SUMM_FILE_ATTACH.PK_SHIFT_SUMM_FILE_ATTACH Index Columns |
| ColumnName | Sort Order |
| SHIFT_ID | Ascending |
| CAL_DTE | Ascending |
| ATTACH_SEQ_ID | Ascending |
| SHIFT_SUMM_FILE_ATTACH.PK_SHIFT_SUMM_FILE_ATTACH Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SHIFT_SUMM_FILE_ATTACH.PK_SHIFT_SUMM_FILE_ATTACH Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SHIFT_SUMM_FILE_ATTACH.PK_SHIFT_SUMM_FILE_ATTACH Bound Attachments |
| Name | Current Value |
| SHIFT_SUMM_PROC_VAR.PK_SHIFT_SUMM_PROC_VAR |
| TableName | SHIFT_SUMM_PROC_VAR |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SHIFT_SUMM_PROC_VAR.PK_SHIFT_SUMM_PROC_VAR Index Columns |
| ColumnName | Sort Order |
| SGNL_ID | Ascending |
| SHIFT_SUMM_PROC_VAR.PK_SHIFT_SUMM_PROC_VAR Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| SHIFT_SUMM_PROC_VAR.PK_SHIFT_SUMM_PROC_VAR Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SHIFT_SUMM_PROC_VAR.PK_SHIFT_SUMM_PROC_VAR Bound Attachments |
| Name | Current Value |
| SHIFT_WORK_SCHED.PK_SHIFT_WORK_SCHED |
| TableName | SHIFT_WORK_SCHED |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SHIFT_WORK_SCHED.PK_SHIFT_WORK_SCHED Index Columns |
| ColumnName | Sort Order |
| SHIFT_ID | Ascending |
| CAL_DTE | Ascending |
| SHIFT_WORK_SCHED.PK_SHIFT_WORK_SCHED Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SHIFT_WORK_SCHED.PK_SHIFT_WORK_SCHED Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SHIFT_WORK_SCHED.PK_SHIFT_WORK_SCHED Bound Attachments |
| Name | Current Value |
| SNS_EMPLOYEE_MV.PK580 |
| TableName | SNS_EMPLOYEE_MV |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SNS_EMPLOYEE_MV.PK580 Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| SNS_EMPLOYEE_MV.PK580 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| SNS_EMPLOYEE_MV.PK580 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SNS_EMPLOYEE_MV.PK580 Bound Attachments |
| Name | Current Value |
| TGT_BEAM_PARM.PK_TGT_BEAM_PARM |
| TableName | TGT_BEAM_PARM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| TGT_BEAM_PARM.PK_TGT_BEAM_PARM Index Columns |
| ColumnName | Sort Order |
| CREATE_DTE | Ascending |
| TGT_BEAM_PARM.PK_TGT_BEAM_PARM Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | OPER |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 64 |
| Next | 1024 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| TGT_BEAM_PARM.PK_TGT_BEAM_PARM Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| TGT_BEAM_PARM.PK_TGT_BEAM_PARM Bound Attachments |
| Name | Current Value |
| UOM.PK_UOM |
| TableName | UOM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| UOM.PK_UOM Index Columns |
| ColumnName | Sort Order |
| UOM_ID | Ascending |
| UOM.PK_UOM Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| 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 |
| UOM.PK_UOM Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| UOM.PK_UOM Bound Attachments |
| Name | Current Value |