HFIR_OPER_STAT.PK_HFIR_OPER_STAT |
TableName | HFIR_OPER_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
HFIR_OPER_STAT.PK_HFIR_OPER_STAT Index Columns |
ColumnName | Sort Order |
STAT | Ascending |
HFIR_OPER_STAT.PK_HFIR_OPER_STAT 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 |
HFIR_OPER_STAT.PK_HFIR_OPER_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
HFIR_OPER_STAT.PK_HFIR_OPER_STAT Bound Attachments |
Name | Current Value |
INSTR_DOWNTIME_ACCT.PK_INSTR_DOWNTIME_ACCT |
TableName | INSTR_DOWNTIME_ACCT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR_DOWNTIME_ACCT.PK_INSTR_DOWNTIME_ACCT Index Columns |
ColumnName | Sort Order |
FACIL_ID | Ascending |
INSTR_ID | Ascending |
OPER_GRP_ID | Ascending |
CAL_DTE | Ascending |
PRPSL_ID | Ascending |
SHIFT_ID | Ascending |
INSTR_DOWNTIME_ACCT.PK_INSTR_DOWNTIME_ACCT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | NS_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 |
INSTR_DOWNTIME_ACCT.PK_INSTR_DOWNTIME_ACCT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR_DOWNTIME_ACCT.PK_INSTR_DOWNTIME_ACCT Bound Attachments |
Name | Current Value |
INSTR_GRP.PK_INSTR_GRP |
TableName | INSTR_GRP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR_GRP.PK_INSTR_GRP Index Columns |
ColumnName | Sort Order |
INSTR_GRP_ID | Ascending |
INSTR_GRP.PK_INSTR_GRP 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 |
INSTR_GRP.PK_INSTR_GRP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR_GRP.PK_INSTR_GRP Bound Attachments |
Name | Current Value |
INSTR_LOG_CAT_ASSC.PK_INSTR_LOG_CAT_ASSC |
TableName | INSTR_LOG_CAT_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR_LOG_CAT_ASSC.PK_INSTR_LOG_CAT_ASSC Index Columns |
ColumnName | Sort Order |
INSTR_ID | Ascending |
CAT_ID | Ascending |
INSTR_LOG_CAT_ASSC.PK_INSTR_LOG_CAT_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 |
INSTR_LOG_CAT_ASSC.PK_INSTR_LOG_CAT_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR_LOG_CAT_ASSC.PK_INSTR_LOG_CAT_ASSC Bound Attachments |
Name | Current Value |
INSTR_SHIFT_SUMM.PK_INSTR_SHIFT_SUMM |
TableName | INSTR_SHIFT_SUMM |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR_SHIFT_SUMM.PK_INSTR_SHIFT_SUMM Index Columns |
ColumnName | Sort Order |
SHIFT_ID | Ascending |
FACIL_ID | Ascending |
CAL_DTE | Ascending |
INSTR_SHIFT_SUMM.PK_INSTR_SHIFT_SUMM Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | NS_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 |
INSTR_SHIFT_SUMM.PK_INSTR_SHIFT_SUMM Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR_SHIFT_SUMM.PK_INSTR_SHIFT_SUMM Bound Attachments |
Name | Current Value |
INSTR_SUP_ACT.PK_INSTR_SUP_ACT |
TableName | INSTR_SUP_ACT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR_SUP_ACT.PK_INSTR_SUP_ACT Index Columns |
ColumnName | Sort Order |
INSTR_SUP_ACT_ID | Ascending |
INSTR_SUP_ACT.PK_INSTR_SUP_ACT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | NS_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 |
INSTR_SUP_ACT.PK_INSTR_SUP_ACT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR_SUP_ACT.PK_INSTR_SUP_ACT Bound Attachments |
Name | Current Value |
INSTR_SUP_ACT_STAT.PK_INSTR_SUP_ACT_STAT |
TableName | INSTR_SUP_ACT_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR_SUP_ACT_STAT.PK_INSTR_SUP_ACT_STAT Index Columns |
ColumnName | Sort Order |
STAT_ID | Ascending |
INSTR_SUP_ACT_STAT.PK_INSTR_SUP_ACT_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 |
INSTR_SUP_ACT_STAT.PK_INSTR_SUP_ACT_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR_SUP_ACT_STAT.PK_INSTR_SUP_ACT_STAT Bound Attachments |
Name | Current Value |
NS_OPER_ROLE.PK_NS_OPER_ROLE |
TableName | NS_OPER_ROLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
NS_OPER_ROLE.PK_NS_OPER_ROLE Index Columns |
ColumnName | Sort Order |
ROLE_ID | Ascending |
NS_OPER_ROLE.PK_NS_OPER_ROLE 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 |
NS_OPER_ROLE.PK_NS_OPER_ROLE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NS_OPER_ROLE.PK_NS_OPER_ROLE Bound Attachments |
Name | Current Value |
NS_OPER_ROLE_USR_ASSC.PK_NS_OPER_ROLE_USR_ASSC |
TableName | NS_OPER_ROLE_USR_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
NS_OPER_ROLE_USR_ASSC.PK_NS_OPER_ROLE_USR_ASSC Index Columns |
ColumnName | Sort Order |
ROLE_ID | Ascending |
USER_ID | Ascending |
NS_OPER_ROLE_USR_ASSC.PK_NS_OPER_ROLE_USR_ASSC 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 |
NS_OPER_ROLE_USR_ASSC.PK_NS_OPER_ROLE_USR_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NS_OPER_ROLE_USR_ASSC.PK_NS_OPER_ROLE_USR_ASSC Bound Attachments |
Name | Current Value |
NSSD_AREA.PK_NSSD_AREA |
TableName | NSSD_AREA |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
NSSD_AREA.PK_NSSD_AREA Index Columns |
ColumnName | Sort Order |
AREA_ID | Ascending |
NSSD_AREA.PK_NSSD_AREA Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | NS_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 |
NSSD_AREA.PK_NSSD_AREA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NSSD_AREA.PK_NSSD_AREA Bound Attachments |
Name | Current Value |
NSSD_AREA_ROLE.PK_NSSD_AREA_ROLE |
TableName | NSSD_AREA_ROLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
NSSD_AREA_ROLE.PK_NSSD_AREA_ROLE Index Columns |
ColumnName | Sort Order |
ROLE_ID | Ascending |
NSSD_AREA_ROLE.PK_NSSD_AREA_ROLE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | NS_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 |
NSSD_AREA_ROLE.PK_NSSD_AREA_ROLE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NSSD_AREA_ROLE.PK_NSSD_AREA_ROLE Bound Attachments |
Name | Current Value |
NSSD_AREA_ROLE_ASGN.FK_NSSD_ASGN_AREA |
TableName | NSSD_AREA_ROLE_ASGN |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX NS_OPER.FK_NSSD_ASGN_AREA ON NS_OPER.NSSD_AREA_ROLE_ASGN(AREA_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE NS_OPER      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
NSSD_AREA_ROLE_ASGN.FK_NSSD_ASGN_AREA Index Columns |
ColumnName | Sort Order |
AREA_ID | Ascending |
NSSD_AREA_ROLE_ASGN.FK_NSSD_ASGN_AREA Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | NS_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 |
NSSD_AREA_ROLE_ASGN.FK_NSSD_ASGN_AREA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NSSD_AREA_ROLE_ASGN.FK_NSSD_ASGN_AREA Bound Attachments |
Name | Current Value |
NSSD_AREA_ROLE_ASGN.FK_NSSD_ASGN_EMP |
TableName | NSSD_AREA_ROLE_ASGN |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX NS_OPER.FK_NSSD_ASGN_EMP ON NS_OPER.NSSD_AREA_ROLE_ASGN(BN)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE NS_OPER      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
NSSD_AREA_ROLE_ASGN.FK_NSSD_ASGN_EMP Index Columns |
ColumnName | Sort Order |
BN | Ascending |
NSSD_AREA_ROLE_ASGN.FK_NSSD_ASGN_EMP Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | NS_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 |
NSSD_AREA_ROLE_ASGN.FK_NSSD_ASGN_EMP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NSSD_AREA_ROLE_ASGN.FK_NSSD_ASGN_EMP Bound Attachments |
Name | Current Value |
NSSD_AREA_ROLE_ASGN.FK_NSSD_ASGN_ROLE |
TableName | NSSD_AREA_ROLE_ASGN |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX NS_OPER.FK_NSSD_ASGN_ROLE ON NS_OPER.NSSD_AREA_ROLE_ASGN(ROLE_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE NS_OPER      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
NSSD_AREA_ROLE_ASGN.FK_NSSD_ASGN_ROLE Index Columns |
ColumnName | Sort Order |
ROLE_ID | Ascending |
NSSD_AREA_ROLE_ASGN.FK_NSSD_ASGN_ROLE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | NS_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 |
NSSD_AREA_ROLE_ASGN.FK_NSSD_ASGN_ROLE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NSSD_AREA_ROLE_ASGN.FK_NSSD_ASGN_ROLE Bound Attachments |
Name | Current Value |
NSSD_AREA_ROLE_ASGN.PK_NSSD_AREA_ASGN |
TableName | NSSD_AREA_ROLE_ASGN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
NSSD_AREA_ROLE_ASGN.PK_NSSD_AREA_ASGN Index Columns |
ColumnName | Sort Order |
AREA_ID | Ascending |
ROLE_ID | Ascending |
BN | Ascending |
NSSD_AREA_ROLE_ASGN.PK_NSSD_AREA_ASGN 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 |
NSSD_AREA_ROLE_ASGN.PK_NSSD_AREA_ASGN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NSSD_AREA_ROLE_ASGN.PK_NSSD_AREA_ASGN 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 | NS_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 |
OPER_GRP.PK_OPER_GRP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPER_GRP.PK_OPER_GRP 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 | NS_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 |
OPER_SUBGRP1.PK_OPER_SUBGRP1 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPER_SUBGRP1.PK_OPER_SUBGRP1 Bound Attachments |
Name | Current Value |
PERS_ROLE_OPER_GRP_ASGN.PK_PERS_ROLE_OPER_GRP_ASGN |
TableName | PERS_ROLE_OPER_GRP_ASGN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PERS_ROLE_OPER_GRP_ASGN.PK_PERS_ROLE_OPER_GRP_ASGN Index Columns |
ColumnName | Sort Order |
OPER_GRP_ID | Ascending |
BN | Ascending |
PERS_ROLE_OPER_GRP_ASGN.PK_PERS_ROLE_OPER_GRP_ASGN Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | NS_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_ROLE_OPER_GRP_ASGN.PK_PERS_ROLE_OPER_GRP_ASGN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PERS_ROLE_OPER_GRP_ASGN.PK_PERS_ROLE_OPER_GRP_ASGN Bound Attachments |
Name | Current Value |
PERS_ROLE_OPER_SUBGRP_ASGN.PK_PERS_ROLE_OPER_SUBGRP_ASGN |
TableName | PERS_ROLE_OPER_SUBGRP_ASGN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PERS_ROLE_OPER_SUBGRP_ASGN.PK_PERS_ROLE_OPER_SUBGRP_ASGN Index Columns |
ColumnName | Sort Order |
OPER_GRP_ID | Ascending |
OPER_SUBGRP1_ID | Ascending |
BN | Ascending |
PERS_ROLE_OPER_SUBGRP_ASGN.PK_PERS_ROLE_OPER_SUBGRP_ASGN Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | NS_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_ROLE_OPER_SUBGRP_ASGN.PK_PERS_ROLE_OPER_SUBGRP_ASGN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PERS_ROLE_OPER_SUBGRP_ASGN.PK_PERS_ROLE_OPER_SUBGRP_ASGN Bound Attachments |
Name | Current Value |
PERS_ROLES.PK_PERS_ROLES |
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.PK_PERS_ROLES Index Columns |
ColumnName | Sort Order |
BN | Ascending |
PERS_ROLES.PK_PERS_ROLES Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | NS_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 |
PERS_ROLES.PK_PERS_ROLES Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PERS_ROLES.PK_PERS_ROLES Bound Attachments |
Name | Current Value |
RPT_DIST.PK_RPT_DIST |
TableName | RPT_DIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
RPT_DIST.PK_RPT_DIST Index Columns |
ColumnName | Sort Order |
EMAIL_ADDR | Ascending |
RPT_DIST.PK_RPT_DIST 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 |
RPT_DIST.PK_RPT_DIST Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RPT_DIST.PK_RPT_DIST Bound Attachments |
Name | Current Value |
SHIFT_INSTR_NOTE.PK_SHIFT_INSTR_NOTE |
TableName | SHIFT_INSTR_NOTE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SHIFT_INSTR_NOTE.PK_SHIFT_INSTR_NOTE Index Columns |
ColumnName | Sort Order |
FACIL_ID | Ascending |
CAL_DTE | Ascending |
LOGBOOK_ENTRY_ID | Ascending |
INSTR_ID | Ascending |
SHIFT_ID | Ascending |
SHIFT_INSTR_NOTE.PK_SHIFT_INSTR_NOTE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | NS_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_INSTR_NOTE.PK_SHIFT_INSTR_NOTE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SHIFT_INSTR_NOTE.PK_SHIFT_INSTR_NOTE Bound Attachments |
Name | Current Value |
SHIFT_INSTR_NOTE_GRP_ASGN.PK_SHIFT_INSTR_NOTE_GRP_ASGN |
TableName | SHIFT_INSTR_NOTE_GRP_ASGN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SHIFT_INSTR_NOTE_GRP_ASGN.PK_SHIFT_INSTR_NOTE_GRP_ASGN Index Columns |
ColumnName | Sort Order |
SHIFT_ID | Ascending |
FACIL_ID | Ascending |
CAL_DTE | Ascending |
INSTR_ID | Ascending |
OPER_GRP_ID | Ascending |
OPER_SUBGRP1_ID | Ascending |
LOGBOOK_ENTRY_ID | Ascending |
SHIFT_INSTR_NOTE_GRP_ASGN.PK_SHIFT_INSTR_NOTE_GRP_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 |
SHIFT_INSTR_NOTE_GRP_ASGN.PK_SHIFT_INSTR_NOTE_GRP_ASGN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SHIFT_INSTR_NOTE_GRP_ASGN.PK_SHIFT_INSTR_NOTE_GRP_ASGN Bound Attachments |
Name | Current Value |
TEXT_MSG_NOTIF.TEXT_MSG_NOTIF_IND1 |
TableName | TEXT_MSG_NOTIF |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX NS_OPER.TEXT_MSG_NOTIF_IND1 ON NS_OPER.TEXT_MSG_NOTIF(CREATE_DTE)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE NS_OPER      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
TEXT_MSG_NOTIF.TEXT_MSG_NOTIF_IND1 Index Columns |
ColumnName | Sort Order |
CREATE_DTE | Ascending |
TEXT_MSG_NOTIF.TEXT_MSG_NOTIF_IND1 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | NS_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 |
TEXT_MSG_NOTIF.TEXT_MSG_NOTIF_IND1 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
TEXT_MSG_NOTIF.TEXT_MSG_NOTIF_IND1 Bound Attachments |
Name | Current Value |
TEXT_MSG_NOTIF.PK_TEXT_MSG_NOTIF |
TableName | TEXT_MSG_NOTIF |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
TEXT_MSG_NOTIF.PK_TEXT_MSG_NOTIF Index Columns |
ColumnName | Sort Order |
NOTIF_ID | Ascending |
TEXT_MSG_NOTIF.PK_TEXT_MSG_NOTIF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | NS_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 |
TEXT_MSG_NOTIF.PK_TEXT_MSG_NOTIF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
TEXT_MSG_NOTIF.PK_TEXT_MSG_NOTIF Bound Attachments |
Name | Current Value |
TEXT_MSG_NOTIF_REG.PK_TEXT_MSG_NOTIF_REG |
TableName | TEXT_MSG_NOTIF_REG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
TEXT_MSG_NOTIF_REG.PK_TEXT_MSG_NOTIF_REG Index Columns |
ColumnName | Sort Order |
REG_ID | Ascending |
TEXT_MSG_NOTIF_REG.PK_TEXT_MSG_NOTIF_REG Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | NS_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 |
TEXT_MSG_NOTIF_REG.PK_TEXT_MSG_NOTIF_REG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
TEXT_MSG_NOTIF_REG.PK_TEXT_MSG_NOTIF_REG Bound Attachments |
Name | Current Value |
TEXT_MSG_NOTIF_SENT.PK_TEXT_MSG_NOTIF_SENT |
TableName | TEXT_MSG_NOTIF_SENT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
TEXT_MSG_NOTIF_SENT.PK_TEXT_MSG_NOTIF_SENT Index Columns |
ColumnName | Sort Order |
NOTIF_ID | Ascending |
REG_ID | Ascending |
TEXT_MSG_NOTIF_SENT.PK_TEXT_MSG_NOTIF_SENT 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 |
TEXT_MSG_NOTIF_SENT.PK_TEXT_MSG_NOTIF_SENT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
TEXT_MSG_NOTIF_SENT.PK_TEXT_MSG_NOTIF_SENT Bound Attachments |
Name | Current Value |