HAZ_CAT_3_NUCLIDE.FK_SAPEU_SMPL_HAZ |
TableName | HAZ_CAT_3_NUCLIDE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SMPLACT.FK_SAPEU_SMPL_HAZ ON SMPLACT.HAZ_CAT_3_NUCLIDE(SAPEU_RUN_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SMPLACT      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
HAZ_CAT_3_NUCLIDE.FK_SAPEU_SMPL_HAZ Index Columns |
ColumnName | Sort Order |
SAPEU_RUN_ID | Ascending |
HAZ_CAT_3_NUCLIDE.FK_SAPEU_SMPL_HAZ Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SMPLACT |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
HAZ_CAT_3_NUCLIDE.FK_SAPEU_SMPL_HAZ Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
HAZ_CAT_3_NUCLIDE.FK_SAPEU_SMPL_HAZ Bound Attachments |
Name | Current Value |
NEUTRON_SOURCE_FLUX.FK_SAPEU_SMPL_FLUX |
TableName | NEUTRON_SOURCE_FLUX |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SMPLACT.FK_SAPEU_SMPL_FLUX ON SMPLACT.NEUTRON_SOURCE_FLUX(SAPEU_RUN_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SMPLACT      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
NEUTRON_SOURCE_FLUX.FK_SAPEU_SMPL_FLUX Index Columns |
ColumnName | Sort Order |
SAPEU_RUN_ID | Ascending |
NEUTRON_SOURCE_FLUX.FK_SAPEU_SMPL_FLUX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SMPLACT |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
NEUTRON_SOURCE_FLUX.FK_SAPEU_SMPL_FLUX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NEUTRON_SOURCE_FLUX.FK_SAPEU_SMPL_FLUX Bound Attachments |
Name | Current Value |
NUCLIDE_INFO.FK_SAPEU_SMPL_NUCLIDE |
TableName | NUCLIDE_INFO |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SMPLACT.FK_SAPEU_SMPL_NUCLIDE ON SMPLACT.NUCLIDE_INFO(SAPEU_RUN_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SMPLACT      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
NUCLIDE_INFO.FK_SAPEU_SMPL_NUCLIDE Index Columns |
ColumnName | Sort Order |
SAPEU_RUN_ID | Ascending |
NUCLIDE_INFO.FK_SAPEU_SMPL_NUCLIDE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SMPLACT |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
NUCLIDE_INFO.FK_SAPEU_SMPL_NUCLIDE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NUCLIDE_INFO.FK_SAPEU_SMPL_NUCLIDE Bound Attachments |
Name | Current Value |
RAD_DOSE.FK_SAPEU_SMPL_RAD_DOSE |
TableName | RAD_DOSE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SMPLACT.FK_SAPEU_SMPL_RAD_DOSE ON SMPLACT.RAD_DOSE(SAPEU_RUN_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SMPLACT      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
RAD_DOSE.FK_SAPEU_SMPL_RAD_DOSE Index Columns |
ColumnName | Sort Order |
SAPEU_RUN_ID | Ascending |
RAD_DOSE.FK_SAPEU_SMPL_RAD_DOSE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SMPLACT |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
RAD_DOSE.FK_SAPEU_SMPL_RAD_DOSE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RAD_DOSE.FK_SAPEU_SMPL_RAD_DOSE Bound Attachments |
Name | Current Value |
RADIONUCLIDE_ACT.FK_SAPEU_SMPL_RAD_ACT |
TableName | RADIONUCLIDE_ACT |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SMPLACT.FK_SAPEU_SMPL_RAD_ACT ON SMPLACT.RADIONUCLIDE_ACT(SAPEU_RUN_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SMPLACT      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
RADIONUCLIDE_ACT.FK_SAPEU_SMPL_RAD_ACT Index Columns |
ColumnName | Sort Order |
SAPEU_RUN_ID | Ascending |
RADIONUCLIDE_ACT.FK_SAPEU_SMPL_RAD_ACT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SMPLACT |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
RADIONUCLIDE_ACT.FK_SAPEU_SMPL_RAD_ACT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RADIONUCLIDE_ACT.FK_SAPEU_SMPL_RAD_ACT Bound Attachments |
Name | Current Value |
RESID_ISOTOPE.FK_SAPEU_SMPL_RESID |
TableName | RESID_ISOTOPE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SMPLACT.FK_SAPEU_SMPL_RESID ON SMPLACT.RESID_ISOTOPE(SAPEU_RUN_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SMPLACT      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
RESID_ISOTOPE.FK_SAPEU_SMPL_RESID Index Columns |
ColumnName | Sort Order |
SAPEU_RUN_ID | Ascending |
RESID_ISOTOPE.FK_SAPEU_SMPL_RESID Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SMPLACT |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
RESID_ISOTOPE.FK_SAPEU_SMPL_RESID Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RESID_ISOTOPE.FK_SAPEU_SMPL_RESID Bound Attachments |
Name | Current Value |
SAPEU_SMPL.SAPEU_SMPL_RUNS_LIST |
TableName | SAPEU_SMPL |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SMPLACT.SAPEU_SMPL_RUNS_LIST ON SMPLACT.SAPEU_SMPL(PRPSL_ID, SMPL_NM, SAPEU_RUN_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SMPLACT      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
SAPEU_SMPL.SAPEU_SMPL_RUNS_LIST Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SMPL_NM | Ascending |
SAPEU_RUN_ID | Ascending |
SAPEU_SMPL.SAPEU_SMPL_RUNS_LIST Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SMPLACT |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
SAPEU_SMPL.SAPEU_SMPL_RUNS_LIST Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SAPEU_SMPL.SAPEU_SMPL_RUNS_LIST Bound Attachments |
Name | Current Value |
SAPEU_SMPL.SAPEU_SMPL_PK |
TableName | SAPEU_SMPL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SAPEU_SMPL.SAPEU_SMPL_PK Index Columns |
ColumnName | Sort Order |
SAPEU_RUN_ID | Ascending |
SAPEU_SMPL.SAPEU_SMPL_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SMPLACT |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
SAPEU_SMPL.SAPEU_SMPL_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SAPEU_SMPL.SAPEU_SMPL_PK Bound Attachments |
Name | Current Value |
SAPEU_SMPL.SAPEU_SMPL_PRPSL |
TableName | SAPEU_SMPL |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX SMPLACT.SAPEU_SMPL_PRPSL ON SMPLACT.SAPEU_SMPL(PRPSL_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE SMPLACT      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
SAPEU_SMPL.SAPEU_SMPL_PRPSL Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SAPEU_SMPL.SAPEU_SMPL_PRPSL Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | SMPLACT |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
SAPEU_SMPL.SAPEU_SMPL_PRPSL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SAPEU_SMPL.SAPEU_SMPL_PRPSL Bound Attachments |
Name | Current Value |