APPL_FILE.PK_APPL_FILE |
TableName | APPL_FILE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
APPL_FILE.PK_APPL_FILE Index Columns |
ColumnName | Sort Order |
APPL_FILE_ID | Ascending |
APPL_FILE.PK_APPL_FILE 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 |
APPL_FILE.PK_APPL_FILE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
APPL_FILE.PK_APPL_FILE Bound Attachments |
Name | Current Value |
APPL_MSG.PK_APPL_MSG |
TableName | APPL_MSG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
APPL_MSG.PK_APPL_MSG Index Columns |
ColumnName | Sort Order |
MSG_ID | Ascending |
APPL_MSG.PK_APPL_MSG 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 |
APPL_MSG.PK_APPL_MSG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
APPL_MSG.PK_APPL_MSG Bound Attachments |
Name | Current Value |
BAC_ALLOC_HIST.PK_BAC_ALLOC_HIST |
TableName | BAC_ALLOC_HIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
BAC_ALLOC_HIST.PK_BAC_ALLOC_HIST Index Columns |
ColumnName | Sort Order |
CUR_DTE | Ascending |
INSTR_ID | Ascending |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
BAC_ALLOC_HIST.PK_BAC_ALLOC_HIST 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 |
BAC_ALLOC_HIST.PK_BAC_ALLOC_HIST Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
BAC_ALLOC_HIST.PK_BAC_ALLOC_HIST Bound Attachments |
Name | Current Value |
BEAM_ALLOC.PK_BEAM_ALLOC |
TableName | BEAM_ALLOC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
BEAM_ALLOC.PK_BEAM_ALLOC Index Columns |
ColumnName | Sort Order |
INSTR_ID | Ascending |
FACIL_ID | Ascending |
RUN_CYCLE_ID | Ascending |
ALLOT_ID | Ascending |
PRPSL_TYPE_ID | Ascending |
BEAM_ALLOC.PK_BEAM_ALLOC 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_ALLOC.PK_BEAM_ALLOC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
BEAM_ALLOC.PK_BEAM_ALLOC Bound Attachments |
Name | Current Value |
BEAM_ALLOC_ALLOT.PK_BEAM_ALLOC_ALLOT |
TableName | BEAM_ALLOC_ALLOT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
BEAM_ALLOC_ALLOT.PK_BEAM_ALLOC_ALLOT Index Columns |
ColumnName | Sort Order |
ALLOT_ID | Ascending |
BEAM_ALLOC_ALLOT.PK_BEAM_ALLOC_ALLOT 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_ALLOC_ALLOT.PK_BEAM_ALLOC_ALLOT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
BEAM_ALLOC_ALLOT.PK_BEAM_ALLOC_ALLOT Bound Attachments |
Name | Current Value |
BES_RSCH_AREA.PK_BES_RSCH_AREA |
TableName | BES_RSCH_AREA |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
BES_RSCH_AREA.PK_BES_RSCH_AREA Index Columns |
ColumnName | Sort Order |
RSCH_AREA_ID | Ascending |
BES_RSCH_AREA.PK_BES_RSCH_AREA 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 |
BES_RSCH_AREA.PK_BES_RSCH_AREA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
BES_RSCH_AREA.PK_BES_RSCH_AREA 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 |
ESS_SIGN_ROLE.PK_ESS_SIGN_ROLE |
TableName | ESS_SIGN_ROLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ESS_SIGN_ROLE.PK_ESS_SIGN_ROLE Index Columns |
ColumnName | Sort Order |
ROLE_ID | Ascending |
ESS_SIGN_ROLE.PK_ESS_SIGN_ROLE 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 |
ESS_SIGN_ROLE.PK_ESS_SIGN_ROLE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ESS_SIGN_ROLE.PK_ESS_SIGN_ROLE Bound Attachments |
Name | Current Value |
EXPT_FACIL.PK_EXPT_FACIL |
TableName | EXPT_FACIL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_FACIL.PK_EXPT_FACIL Index Columns |
ColumnName | Sort Order |
FACIL_ID | Ascending |
EXPT_FACIL.PK_EXPT_FACIL 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 |
EXPT_FACIL.PK_EXPT_FACIL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_FACIL.PK_EXPT_FACIL Bound Attachments |
Name | Current Value |
EXPT_INSTR_TM_SFTY_REV.PK_EXPT_INSTR_TM_SFTY_REV |
TableName | EXPT_INSTR_TM_SFTY_REV |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_INSTR_TM_SFTY_REV.PK_EXPT_INSTR_TM_SFTY_REV Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
INSTR_ID | Ascending |
RUN_NBR | Ascending |
BN | Ascending |
EXPT_INSTR_TM_SFTY_REV.PK_EXPT_INSTR_TM_SFTY_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 |
EXPT_INSTR_TM_SFTY_REV.PK_EXPT_INSTR_TM_SFTY_REV Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_INSTR_TM_SFTY_REV.PK_EXPT_INSTR_TM_SFTY_REV Bound Attachments |
Name | Current Value |
EXPT_RSRC_SCHED.PK_EXPT_RSRC_SCHED |
TableName | EXPT_RSRC_SCHED |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_SCHED.PK_EXPT_RSRC_SCHED Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_ID | Ascending |
EXPT_RSRC_SCHED.PK_EXPT_RSRC_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 |
EXPT_RSRC_SCHED.PK_EXPT_RSRC_SCHED Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_SCHED.PK_EXPT_RSRC_SCHED Bound Attachments |
Name | Current Value |
EXPT_SCHED.PK_EXPT_SCHED |
TableName | EXPT_SCHED |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_SCHED.PK_EXPT_SCHED Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
INSTR_ID | Ascending |
RUN_NBR | Ascending |
EXPT_SCHED.PK_EXPT_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 |
EXPT_SCHED.PK_EXPT_SCHED Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SCHED.PK_EXPT_SCHED Bound Attachments |
Name | Current Value |
EXPT_SMPL.PK_EXPT_SMPL |
TableName | EXPT_SMPL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_SMPL.PK_EXPT_SMPL Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
SMPL_ID | Ascending |
EXPT_SMPL.PK_EXPT_SMPL 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 |
EXPT_SMPL.PK_EXPT_SMPL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SMPL.PK_EXPT_SMPL Bound Attachments |
Name | Current Value |
EXPT_SMPL.EXPT_SMPL_IND1 |
TableName | EXPT_SMPL |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.EXPT_SMPL_IND1 ON PRPSL.EXPT_SMPL(APPRV_ID)      LOGGING ; |
EXPT_SMPL.EXPT_SMPL_IND1 Index Columns |
ColumnName | Sort Order |
APPRV_ID | Ascending |
EXPT_SMPL.EXPT_SMPL_IND1 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 |
EXPT_SMPL.EXPT_SMPL_IND1 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SMPL.EXPT_SMPL_IND1 Bound Attachments |
Name | Current Value |
EXPT_SMPL_APPR_CODE.PK_EXPT_SMPL_APPR_CODE |
TableName | EXPT_SMPL_APPR_CODE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_SMPL_APPR_CODE.PK_EXPT_SMPL_APPR_CODE Index Columns |
ColumnName | Sort Order |
APPRV_ID | Ascending |
EXPT_SMPL_APPR_CODE.PK_EXPT_SMPL_APPR_CODE 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 |
EXPT_SMPL_APPR_CODE.PK_EXPT_SMPL_APPR_CODE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SMPL_APPR_CODE.PK_EXPT_SMPL_APPR_CODE Bound Attachments |
Name | Current Value |
EXPT_SMPL_ENV.PK_EXPT_SMPL_ENV |
TableName | EXPT_SMPL_ENV |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_SMPL_ENV.PK_EXPT_SMPL_ENV Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
EXPT_SMPL_ENV.PK_EXPT_SMPL_ENV 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 |
EXPT_SMPL_ENV.PK_EXPT_SMPL_ENV Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SMPL_ENV.PK_EXPT_SMPL_ENV Bound Attachments |
Name | Current Value |
EXPT_SMPL_FORM_ASSC.PK_EXPT_SMPL_FORM_ASSC |
TableName | EXPT_SMPL_FORM_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_SMPL_FORM_ASSC.PK_EXPT_SMPL_FORM_ASSC Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
SMPL_ID | Ascending |
SMPL_FORM_ID | Ascending |
EXPT_SMPL_FORM_ASSC.PK_EXPT_SMPL_FORM_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 |
EXPT_SMPL_FORM_ASSC.PK_EXPT_SMPL_FORM_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SMPL_FORM_ASSC.PK_EXPT_SMPL_FORM_ASSC Bound Attachments |
Name | Current Value |
EXPT_SMPL_HAZ_ASSC.PK_EXPT_SMPL_HAZ_ASSC |
TableName | EXPT_SMPL_HAZ_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_SMPL_HAZ_ASSC.PK_EXPT_SMPL_HAZ_ASSC Index Columns |
ColumnName | Sort Order |
SMPL_ID | Ascending |
SMPL_HAZ_ID | Ascending |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
EXPT_SMPL_HAZ_ASSC.PK_EXPT_SMPL_HAZ_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 |
EXPT_SMPL_HAZ_ASSC.PK_EXPT_SMPL_HAZ_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SMPL_HAZ_ASSC.PK_EXPT_SMPL_HAZ_ASSC Bound Attachments |
Name | Current Value |
EXPT_SMPL_HIST.PK_EXPT_SMPL_HIST |
TableName | EXPT_SMPL_HIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_SMPL_HIST.PK_EXPT_SMPL_HIST Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SMPL_ID | Ascending |
CUR_DTE | Ascending |
EXPT_SMPL_HIST.PK_EXPT_SMPL_HIST 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 |
EXPT_SMPL_HIST.PK_EXPT_SMPL_HIST Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SMPL_HIST.PK_EXPT_SMPL_HIST Bound Attachments |
Name | Current Value |
EXPT_SMPL_HIST.FK_EXPT_SMPL_HIST_TO_EXPT_SMPL |
TableName | EXPT_SMPL_HIST |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_EXPT_SMPL_HIST_TO_EXPT_SMPL ON PRPSL.EXPT_SMPL_HIST(PRPSL_ID, SMPL_ID)      LOGGING ; |
EXPT_SMPL_HIST.FK_EXPT_SMPL_HIST_TO_EXPT_SMPL Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SMPL_ID | Ascending |
EXPT_SMPL_HIST.FK_EXPT_SMPL_HIST_TO_EXPT_SMPL 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 |
EXPT_SMPL_HIST.FK_EXPT_SMPL_HIST_TO_EXPT_SMPL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SMPL_HIST.FK_EXPT_SMPL_HIST_TO_EXPT_SMPL Bound Attachments |
Name | Current Value |
EXPT_SMPL_SMPL_COND_ASSC.PK_EXPT_SMPL_SMPL_COND_ASSC |
TableName | EXPT_SMPL_SMPL_COND_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_SMPL_SMPL_COND_ASSC.PK_EXPT_SMPL_SMPL_COND_ASSC Index Columns |
ColumnName | Sort Order |
SMPL_ID | Ascending |
SMPL_ENV_ID | Ascending |
SMPL_COND_ID | Ascending |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
EXPT_SMPL_SMPL_COND_ASSC.PK_EXPT_SMPL_SMPL_COND_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 |
EXPT_SMPL_SMPL_COND_ASSC.PK_EXPT_SMPL_SMPL_COND_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SMPL_SMPL_COND_ASSC.PK_EXPT_SMPL_SMPL_COND_ASSC Bound Attachments |
Name | Current Value |
EXPT_SMPL_SMPL_ENV_ASSC.PK_EXPT_SMPL_SMPL_ENV_ASSC |
TableName | EXPT_SMPL_SMPL_ENV_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_SMPL_SMPL_ENV_ASSC.PK_EXPT_SMPL_SMPL_ENV_ASSC Index Columns |
ColumnName | Sort Order |
SMPL_ID | Ascending |
SMPL_ENV_ID | Ascending |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
EXPT_SMPL_SMPL_ENV_ASSC.PK_EXPT_SMPL_SMPL_ENV_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 |
EXPT_SMPL_SMPL_ENV_ASSC.PK_EXPT_SMPL_SMPL_ENV_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SMPL_SMPL_ENV_ASSC.PK_EXPT_SMPL_SMPL_ENV_ASSC Bound Attachments |
Name | Current Value |
EXPT_SMPL_SMPL_SAFE_ASSC.PK_EXPT_SMPL_SMPL_SAFE_ASSC |
TableName | EXPT_SMPL_SMPL_SAFE_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_SMPL_SMPL_SAFE_ASSC.PK_EXPT_SMPL_SMPL_SAFE_ASSC Index Columns |
ColumnName | Sort Order |
SMPL_ID | Ascending |
SMPL_SAFE_ID | Ascending |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
EXPT_SMPL_SMPL_SAFE_ASSC.PK_EXPT_SMPL_SMPL_SAFE_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 |
EXPT_SMPL_SMPL_SAFE_ASSC.PK_EXPT_SMPL_SMPL_SAFE_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SMPL_SMPL_SAFE_ASSC.PK_EXPT_SMPL_SMPL_SAFE_ASSC Bound Attachments |
Name | Current Value |
EXPT_SMPL_SPEC_REQ_ASSC.PK_EXPT_SMPL_SPEC_REQ_ASSC |
TableName | EXPT_SMPL_SPEC_REQ_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_SMPL_SPEC_REQ_ASSC.PK_EXPT_SMPL_SPEC_REQ_ASSC Index Columns |
ColumnName | Sort Order |
SMPL_ID | Ascending |
SPEC_REQ_ID | Ascending |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
EXPT_SMPL_SPEC_REQ_ASSC.PK_EXPT_SMPL_SPEC_REQ_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 |
EXPT_SMPL_SPEC_REQ_ASSC.PK_EXPT_SMPL_SPEC_REQ_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SMPL_SPEC_REQ_ASSC.PK_EXPT_SMPL_SPEC_REQ_ASSC Bound Attachments |
Name | Current Value |
FAQ.PK794 |
TableName | FAQ |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
FAQ.PK794 Index Columns |
ColumnName | Sort Order |
QUES | Ascending |
VIS_CD | Ascending |
FAQ.PK794 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 |
FAQ.PK794 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
FAQ.PK794 Bound Attachments |
Name | Current Value |
FEAS_REV_CAT.PK_FEAS_REV_CAT |
TableName | FEAS_REV_CAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
FEAS_REV_CAT.PK_FEAS_REV_CAT Index Columns |
ColumnName | Sort Order |
FEAS_REV_CAT_ID | Ascending |
FEAS_REV_CAT.PK_FEAS_REV_CAT 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 |
FEAS_REV_CAT.PK_FEAS_REV_CAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
FEAS_REV_CAT.PK_FEAS_REV_CAT Bound Attachments |
Name | Current Value |
FEAS_REVIEW_STAT.PK_FEAS_REVIEW_STAT |
TableName | FEAS_REVIEW_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
FEAS_REVIEW_STAT.PK_FEAS_REVIEW_STAT Index Columns |
ColumnName | Sort Order |
FEAS_REV_CAT_ID | Ascending |
FEAS_REVIEW_STAT_ID | Ascending |
FEAS_REVIEW_STAT.PK_FEAS_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 |
FEAS_REVIEW_STAT.PK_FEAS_REVIEW_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
FEAS_REVIEW_STAT.PK_FEAS_REVIEW_STAT Bound Attachments |
Name | Current Value |
FEEDBACK.PK_FEEDBACK |
TableName | FEEDBACK |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
FEEDBACK.PK_FEEDBACK Index Columns |
ColumnName | Sort Order |
PERSON_ID | Ascending |
CUR_DTE | Ascending |
FEEDBACK.PK_FEEDBACK 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 |
FEEDBACK.PK_FEEDBACK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
FEEDBACK.PK_FEEDBACK Bound Attachments |
Name | Current Value |
HIST_PRPSL_TYPE_MAP.PK_HIST_PRPSL_TYPE_MAP |
TableName | HIST_PRPSL_TYPE_MAP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
HIST_PRPSL_TYPE_MAP.PK_HIST_PRPSL_TYPE_MAP Index Columns |
ColumnName | Sort Order |
PRPSL_TYPE_ID | Ascending |
PREV_PRPSL_TYPE_ID | Ascending |
IPTS_VER | Ascending |
HIST_PRPSL_TYPE_MAP.PK_HIST_PRPSL_TYPE_MAP 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 |
HIST_PRPSL_TYPE_MAP.PK_HIST_PRPSL_TYPE_MAP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
HIST_PRPSL_TYPE_MAP.PK_HIST_PRPSL_TYPE_MAP Bound Attachments |
Name | Current Value |
IDT_REV.PK_IDT_REV |
TableName | IDT_REV |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
IDT_REV.PK_IDT_REV Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
INSTR_ID | Ascending |
PERSON_ID | Ascending |
IDT_REV.PK_IDT_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 |
IDT_REV.PK_IDT_REV Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IDT_REV.PK_IDT_REV Bound Attachments |
Name | Current Value |
IDT_REV_COMM.PK_IDT_REV_COMM |
TableName | IDT_REV_COMM |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
IDT_REV_COMM.PK_IDT_REV_COMM Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
INSTR_ID | Ascending |
IDT_REV_COMM.PK_IDT_REV_COMM 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 |
IDT_REV_COMM.PK_IDT_REV_COMM Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IDT_REV_COMM.PK_IDT_REV_COMM Bound Attachments |
Name | Current Value |
INSTR.PK_INSTR |
TableName | INSTR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR.PK_INSTR Index Columns |
ColumnName | Sort Order |
INSTR_ID | Ascending |
INSTR.PK_INSTR 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.PK_INSTR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR.PK_INSTR Bound Attachments |
Name | Current Value |
INSTR_INSTR_PRPSL_ASSC.PK_INSTR_INSTR_PRPSL_ASSC |
TableName | INSTR_INSTR_PRPSL_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR_INSTR_PRPSL_ASSC.PK_INSTR_INSTR_PRPSL_ASSC Index Columns |
ColumnName | Sort Order |
QUESTION_ID | Ascending |
INSTR_ID | Ascending |
INSTR_INSTR_PRPSL_ASSC.PK_INSTR_INSTR_PRPSL_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_INSTR_PRPSL_ASSC.PK_INSTR_INSTR_PRPSL_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR_INSTR_PRPSL_ASSC.PK_INSTR_INSTR_PRPSL_ASSC Bound Attachments |
Name | Current Value |
INSTR_PDRC_ASSC.PK_INSTR_PDRC_ASSC |
TableName | INSTR_PDRC_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR_PDRC_ASSC.PK_INSTR_PDRC_ASSC Index Columns |
ColumnName | Sort Order |
INSTR_ID | Ascending |
ROLE_ID | Ascending |
PERSON_ID | Ascending |
INSTR_PDRC_ASSC.PK_INSTR_PDRC_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_PDRC_ASSC.PK_INSTR_PDRC_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR_PDRC_ASSC.PK_INSTR_PDRC_ASSC Bound Attachments |
Name | Current Value |
INSTR_PRPSL_QUES.PK_INSTR_PRPSL_QUES |
TableName | INSTR_PRPSL_QUES |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR_PRPSL_QUES.PK_INSTR_PRPSL_QUES Index Columns |
ColumnName | Sort Order |
QUESTION_ID | Ascending |
INSTR_PRPSL_QUES.PK_INSTR_PRPSL_QUES 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_PRPSL_QUES.PK_INSTR_PRPSL_QUES Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR_PRPSL_QUES.PK_INSTR_PRPSL_QUES Bound Attachments |
Name | Current Value |
INSTR_PRPSL_TYPE_SOR_ASSC.PK_INSTR_PRPSL_TYPE_SOR_ASSC |
TableName | INSTR_PRPSL_TYPE_SOR_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR_PRPSL_TYPE_SOR_ASSC.PK_INSTR_PRPSL_TYPE_SOR_ASSC Index Columns |
ColumnName | Sort Order |
INSTR_ID | Ascending |
PRPSL_TYPE_ID | Ascending |
INSTR_PRPSL_TYPE_SOR_ASSC.PK_INSTR_PRPSL_TYPE_SOR_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_PRPSL_TYPE_SOR_ASSC.PK_INSTR_PRPSL_TYPE_SOR_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR_PRPSL_TYPE_SOR_ASSC.PK_INSTR_PRPSL_TYPE_SOR_ASSC Bound Attachments |
Name | Current Value |
IPTS_ACT.PK_IPTS_ACT |
TableName | IPTS_ACT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
IPTS_ACT.PK_IPTS_ACT Index Columns |
ColumnName | Sort Order |
ACT_ID | Ascending |
IPTS_ACT.PK_IPTS_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 |
IPTS_ACT.PK_IPTS_ACT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IPTS_ACT.PK_IPTS_ACT Bound Attachments |
Name | Current Value |
IPTS_LOG.PK_IPTS_LOG |
TableName | IPTS_LOG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
IPTS_LOG.PK_IPTS_LOG Index Columns |
ColumnName | Sort Order |
ACT_ID | Ascending |
MOD_DTE | Ascending |
IPTS_LOG.PK_IPTS_LOG 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 |
IPTS_LOG.PK_IPTS_LOG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IPTS_LOG.PK_IPTS_LOG Bound Attachments |
Name | Current Value |
IPTS_PROJ_TRACK.PK_IPTS_PROJ_TRACK |
TableName | IPTS_PROJ_TRACK |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
IPTS_PROJ_TRACK.PK_IPTS_PROJ_TRACK Index Columns |
ColumnName | Sort Order |
TRACK_ID | Ascending |
IPTS_PROJ_TRACK.PK_IPTS_PROJ_TRACK 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 |
IPTS_PROJ_TRACK.PK_IPTS_PROJ_TRACK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IPTS_PROJ_TRACK.PK_IPTS_PROJ_TRACK Bound Attachments |
Name | Current Value |
IPTS_REL_NBR.PK_IPTS_REL_NBR |
TableName | IPTS_REL_NBR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
IPTS_REL_NBR.PK_IPTS_REL_NBR Index Columns |
ColumnName | Sort Order |
REL_ID | Ascending |
IPTS_REL_NBR.PK_IPTS_REL_NBR 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 |
IPTS_REL_NBR.PK_IPTS_REL_NBR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IPTS_REL_NBR.PK_IPTS_REL_NBR Bound Attachments |
Name | Current Value |
MBR_ROLE.PK_MBR_ROLE |
TableName | MBR_ROLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MBR_ROLE.PK_MBR_ROLE Index Columns |
ColumnName | Sort Order |
MBR_ROLE_ID | Ascending |
MBR_ROLE.PK_MBR_ROLE 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 |
MBR_ROLE.PK_MBR_ROLE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MBR_ROLE.PK_MBR_ROLE Bound Attachments |
Name | Current Value |
NONVAL_EXPT_TEAM_MBR.PK_NONVAL_EXPT_TEAM_MBR |
TableName | NONVAL_EXPT_TEAM_MBR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
NONVAL_EXPT_TEAM_MBR.PK_NONVAL_EXPT_TEAM_MBR Index Columns |
ColumnName | Sort Order |
EMAIL_ADDR | Ascending |
NONVAL_EXPT_TEAM_MBR.PK_NONVAL_EXPT_TEAM_MBR 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 |
NONVAL_EXPT_TEAM_MBR.PK_NONVAL_EXPT_TEAM_MBR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NONVAL_EXPT_TEAM_MBR.PK_NONVAL_EXPT_TEAM_MBR Bound Attachments |
Name | Current Value |
NONVAL_EXPT_TEAM_MBR.FK_NONVAL_EXPT_TM_INST |
TableName | NONVAL_EXPT_TEAM_MBR |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_NONVAL_EXPT_TM_INST ON PRPSL.NONVAL_EXPT_TEAM_MBR(INST_ID)      LOGGING ; |
NONVAL_EXPT_TEAM_MBR.FK_NONVAL_EXPT_TM_INST Index Columns |
ColumnName | Sort Order |
INST_ID | Ascending |
NONVAL_EXPT_TEAM_MBR.FK_NONVAL_EXPT_TM_INST 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 |
NONVAL_EXPT_TEAM_MBR.FK_NONVAL_EXPT_TM_INST Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NONVAL_EXPT_TEAM_MBR.FK_NONVAL_EXPT_TM_INST Bound Attachments |
Name | Current Value |
NONVAL_PRPSL_TM_ONSITE_ACC.PK_NONVAL_PRPSL_TM_ONSITE_ACC |
TableName | NONVAL_PRPSL_TM_ONSITE_ACC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
NONVAL_PRPSL_TM_ONSITE_ACC.PK_NONVAL_PRPSL_TM_ONSITE_ACC Index Columns |
ColumnName | Sort Order |
EMAIL_ADDR | Ascending |
NONVAL_PRPSL_TM_ONSITE_ACC.PK_NONVAL_PRPSL_TM_ONSITE_ACC 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 |
NONVAL_PRPSL_TM_ONSITE_ACC.PK_NONVAL_PRPSL_TM_ONSITE_ACC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NONVAL_PRPSL_TM_ONSITE_ACC.PK_NONVAL_PRPSL_TM_ONSITE_ACC Bound Attachments |
Name | Current Value |
NONVAL_TM_ONSITE_EXPT_SCH_ASSC.PK_NONVAL_TM_ONSITE_EXPT_SCH_ASSC |
TableName | NONVAL_TM_ONSITE_EXPT_SCH_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
NONVAL_TM_ONSITE_EXPT_SCH_ASSC.PK_NONVAL_TM_ONSITE_EXPT_SCH_ASSC Index Columns |
ColumnName | Sort Order |
EMAIL_ADDR | Ascending |
EXPT_START_DTE | Ascending |
NONVAL_TM_ONSITE_EXPT_SCH_ASSC.PK_NONVAL_TM_ONSITE_EXPT_SCH_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 |
NONVAL_TM_ONSITE_EXPT_SCH_ASSC.PK_NONVAL_TM_ONSITE_EXPT_SCH_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NONVAL_TM_ONSITE_EXPT_SCH_ASSC.PK_NONVAL_TM_ONSITE_EXPT_SCH_ASSC Bound Attachments |
Name | Current Value |
OPER_FEAS_REV_STAT.PK_OPER_FEAS_REV_STAT |
TableName | OPER_FEAS_REV_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
OPER_FEAS_REV_STAT.PK_OPER_FEAS_REV_STAT Index Columns |
ColumnName | Sort Order |
OPER_FEAS_REV_STAT_ID | Ascending |
OPER_FEAS_REV_STAT.PK_OPER_FEAS_REV_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_FEAS_REV_STAT.PK_OPER_FEAS_REV_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPER_FEAS_REV_STAT.PK_OPER_FEAS_REV_STAT Bound Attachments |
Name | Current Value |
PAGE_HELP.PK_PAGE_HELP |
TableName | PAGE_HELP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PAGE_HELP.PK_PAGE_HELP Index Columns |
ColumnName | Sort Order |
PAGE_ID | Ascending |
PAGE_HELP.PK_PAGE_HELP 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 |
PAGE_HELP.PK_PAGE_HELP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PAGE_HELP.PK_PAGE_HELP Bound Attachments |
Name | Current Value |
PERS_RSCH_AREA_ASSC.PK_PERS_RSCH_AREA_ASSC |
TableName | PERS_RSCH_AREA_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PERS_RSCH_AREA_ASSC.PK_PERS_RSCH_AREA_ASSC Index Columns |
ColumnName | Sort Order |
RSCH_AREA_ID | Ascending |
PERSON_ID | Ascending |
PERS_RSCH_AREA_ASSC.PK_PERS_RSCH_AREA_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 |
PERS_RSCH_AREA_ASSC.PK_PERS_RSCH_AREA_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PERS_RSCH_AREA_ASSC.PK_PERS_RSCH_AREA_ASSC Bound Attachments |
Name | Current Value |
PERSON.idx_username |
TableName | PERSON |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX XF_ADMIN.idx_username ON XF_ADMIN.PERSON(USRNM)      LOGGING ; |
PERSON.idx_username Index Columns |
ColumnName | Sort Order |
USRNM | Ascending |
PERSON.idx_username 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 |
PERSON.idx_username Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PERSON.idx_username Bound Attachments |
Name | Current Value |
PERSON.PK_PERSON |
TableName | PERSON |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PERSON.PK_PERSON Index Columns |
ColumnName | Sort Order |
PERSON_ID | Ascending |
PERSON.PK_PERSON 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 |
PERSON.PK_PERSON Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PERSON.PK_PERSON Bound Attachments |
Name | Current Value |
PERSON_PDF.PK_PERSON_PDF |
TableName | PERSON_PDF |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PERSON_PDF.PK_PERSON_PDF Index Columns |
ColumnName | Sort Order |
PERSON_ID | Ascending |
PERSON_PDF.PK_PERSON_PDF 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 |
PERSON_PDF.PK_PERSON_PDF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PERSON_PDF.PK_PERSON_PDF Bound Attachments |
Name | Current Value |
PROG_DEV_PRPSL_REV.PK_PROG_DEV_PRPSL_REV |
TableName | PROG_DEV_PRPSL_REV |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PROG_DEV_PRPSL_REV.PK_PROG_DEV_PRPSL_REV Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
PERSON_ID | Ascending |
PROG_DEV_PRPSL_REV.PK_PROG_DEV_PRPSL_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 |
PROG_DEV_PRPSL_REV.PK_PROG_DEV_PRPSL_REV Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PROG_DEV_PRPSL_REV.PK_PROG_DEV_PRPSL_REV Bound Attachments |
Name | Current Value |
PROG_DEV_REV_COMM.PK_PROG_DEV_REV_COMM |
TableName | PROG_DEV_REV_COMM |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PROG_DEV_REV_COMM.PK_PROG_DEV_REV_COMM Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
PROG_DEV_REV_COMM.PK_PROG_DEV_REV_COMM 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 |
PROG_DEV_REV_COMM.PK_PROG_DEV_REV_COMM Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PROG_DEV_REV_COMM.PK_PROG_DEV_REV_COMM Bound Attachments |
Name | Current Value |
PROJ_TASK.PK_TASK_ID |
TableName | PROJ_TASK |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PROJ_TASK.PK_TASK_ID Index Columns |
ColumnName | Sort Order |
TASK_ID | Ascending |
PROJ_TASK.PK_TASK_ID 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 |
PROJ_TASK.PK_TASK_ID Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PROJ_TASK.PK_TASK_ID Bound Attachments |
Name | Current Value |
PROPOSAL.PK_PROPOSAL |
TableName | PROPOSAL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PROPOSAL.PK_PROPOSAL Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
PROPOSAL.PK_PROPOSAL 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 |
PROPOSAL.PK_PROPOSAL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PROPOSAL.PK_PROPOSAL Bound Attachments |
Name | Current Value |
PROPOSAL.PROPOSAL_SOR_INDEX |
TableName | PROPOSAL |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.PROPOSAL_SOR_INDEX ON PRPSL.PROPOSAL(STMT_OF_RESCH)      LOGGING ; |
PROPOSAL.PROPOSAL_SOR_INDEX Index Columns |
ColumnName | Sort Order |
STMT_OF_RESCH | Ascending |
PROPOSAL.PROPOSAL_SOR_INDEX 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 |
PROPOSAL.PROPOSAL_SOR_INDEX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PROPOSAL.PROPOSAL_SOR_INDEX Bound Attachments |
Name | Current Value |
PROPOSAL.IDX_PRPSL_STAT_IND |
TableName | PROPOSAL |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.IDX_PRPSL_STAT_IND ON PRPSL.PROPOSAL(PRPSL_ID, STAT_ID)      LOGGING ; |
PROPOSAL.IDX_PRPSL_STAT_IND Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
STAT_ID | Ascending |
PROPOSAL.IDX_PRPSL_STAT_IND 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 |
PROPOSAL.IDX_PRPSL_STAT_IND Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PROPOSAL.IDX_PRPSL_STAT_IND Bound Attachments |
Name | Current Value |
PROPOSAL.FK_PRPSL_PRPSL_STAT |
TableName | PROPOSAL |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_PRPSL_PRPSL_STAT ON PRPSL.PROPOSAL(STAT_ID)      LOGGING ; |
PROPOSAL.FK_PRPSL_PRPSL_STAT Index Columns |
ColumnName | Sort Order |
STAT_ID | Ascending |
PROPOSAL.FK_PRPSL_PRPSL_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 |
PROPOSAL.FK_PRPSL_PRPSL_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PROPOSAL.FK_PRPSL_PRPSL_STAT Bound Attachments |
Name | Current Value |
PROPOSAL.FK_PRPSL_USR_CAT |
TableName | PROPOSAL |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_PRPSL_USR_CAT ON PRPSL.PROPOSAL(PRPSL_TYPE_ID)      LOGGING ; |
PROPOSAL.FK_PRPSL_USR_CAT Index Columns |
ColumnName | Sort Order |
PRPSL_TYPE_ID | Ascending |
PROPOSAL.FK_PRPSL_USR_CAT 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 |
PROPOSAL.FK_PRPSL_USR_CAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PROPOSAL.FK_PRPSL_USR_CAT Bound Attachments |
Name | Current Value |
PRPSL_ACT.PK_PRPSL_ACT |
TableName | PRPSL_ACT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_ACT.PK_PRPSL_ACT Index Columns |
ColumnName | Sort Order |
ACT_ID | Ascending |
PRPSL_ACT.PK_PRPSL_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 |
PRPSL_ACT.PK_PRPSL_ACT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_ACT.PK_PRPSL_ACT Bound Attachments |
Name | Current Value |
PRPSL_ATTACH.PK_PRPSL_ATTACH |
TableName | PRPSL_ATTACH |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_ATTACH.PK_PRPSL_ATTACH Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
MOD_DTE | Ascending |
ACT_ID | Ascending |
ATTACH_SEQ | Ascending |
PRPSL_ATTACH.PK_PRPSL_ATTACH 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 |
PRPSL_ATTACH.PK_PRPSL_ATTACH Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_ATTACH.PK_PRPSL_ATTACH Bound Attachments |
Name | Current Value |
PRPSL_BES_RSCH_AREA.FK_PRPSL_PRPSL_RSCH_AREA |
TableName | PRPSL_BES_RSCH_AREA |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_PRPSL_PRPSL_RSCH_AREA ON PRPSL.PRPSL_BES_RSCH_AREA(PRPSL_ID)      LOGGING ; |
PRPSL_BES_RSCH_AREA.FK_PRPSL_PRPSL_RSCH_AREA Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
PRPSL_BES_RSCH_AREA.FK_PRPSL_PRPSL_RSCH_AREA 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 |
PRPSL_BES_RSCH_AREA.FK_PRPSL_PRPSL_RSCH_AREA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_BES_RSCH_AREA.FK_PRPSL_PRPSL_RSCH_AREA Bound Attachments |
Name | Current Value |
PRPSL_BES_RSCH_AREA.FK_RSCH_AREA_PRPSL_RA |
TableName | PRPSL_BES_RSCH_AREA |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_RSCH_AREA_PRPSL_RA ON PRPSL.PRPSL_BES_RSCH_AREA(RSCH_AREA_ID)      LOGGING ; |
PRPSL_BES_RSCH_AREA.FK_RSCH_AREA_PRPSL_RA Index Columns |
ColumnName | Sort Order |
RSCH_AREA_ID | Ascending |
PRPSL_BES_RSCH_AREA.FK_RSCH_AREA_PRPSL_RA 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 |
PRPSL_BES_RSCH_AREA.FK_RSCH_AREA_PRPSL_RA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_BES_RSCH_AREA.FK_RSCH_AREA_PRPSL_RA Bound Attachments |
Name | Current Value |
PRPSL_BES_RSCH_AREA.PK_PRPSL_RSCH_AREA |
TableName | PRPSL_BES_RSCH_AREA |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_BES_RSCH_AREA.PK_PRPSL_RSCH_AREA Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
RSCH_AREA_ID | Ascending |
PRPSL_BES_RSCH_AREA.PK_PRPSL_RSCH_AREA 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 |
PRPSL_BES_RSCH_AREA.PK_PRPSL_RSCH_AREA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_BES_RSCH_AREA.PK_PRPSL_RSCH_AREA Bound Attachments |
Name | Current Value |
PRPSL_CLAR.PK_PRPSL_CLAR |
TableName | PRPSL_CLAR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_CLAR.PK_PRPSL_CLAR Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
INSTR_ID | Ascending |
PERSON_ID | Ascending |
CUR_DTE | Ascending |
PRPSL_CLAR.PK_PRPSL_CLAR 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 |
PRPSL_CLAR.PK_PRPSL_CLAR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_CLAR.PK_PRPSL_CLAR Bound Attachments |
Name | Current Value |
PRPSL_CLAR.FK_PRPSL_CLAR_COL_CLAR |
TableName | PRPSL_CLAR |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_PRPSL_CLAR_COL_CLAR ON PRPSL.PRPSL_CLAR(CUR_DTE)      LOGGING ; |
PRPSL_CLAR.FK_PRPSL_CLAR_COL_CLAR Index Columns |
ColumnName | Sort Order |
CUR_DTE | Ascending |
PRPSL_CLAR.FK_PRPSL_CLAR_COL_CLAR 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 |
PRPSL_CLAR.FK_PRPSL_CLAR_COL_CLAR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_CLAR.FK_PRPSL_CLAR_COL_CLAR Bound Attachments |
Name | Current Value |
PRPSL_CLAR.FK_PER_PRPSL_CLAR |
TableName | PRPSL_CLAR |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_PER_PRPSL_CLAR ON PRPSL.PRPSL_CLAR(PERSON_ID)      LOGGING ; |
PRPSL_CLAR.FK_PER_PRPSL_CLAR Index Columns |
ColumnName | Sort Order |
PERSON_ID | Ascending |
PRPSL_CLAR.FK_PER_PRPSL_CLAR 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 |
PRPSL_CLAR.FK_PER_PRPSL_CLAR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_CLAR.FK_PER_PRPSL_CLAR Bound Attachments |
Name | Current Value |
PRPSL_CONT_JUST.PK_PRPSL_CONT_JUST |
TableName | PRPSL_CONT_JUST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_CONT_JUST.PK_PRPSL_CONT_JUST Index Columns |
ColumnName | Sort Order |
CONT_JUST_ID | Ascending |
PRPSL_CONT_JUST.PK_PRPSL_CONT_JUST 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 |
PRPSL_CONT_JUST.PK_PRPSL_CONT_JUST Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_CONT_JUST.PK_PRPSL_CONT_JUST Bound Attachments |
Name | Current Value |
PRPSL_ESS_APPR.PK_PRPSL_ESS_APPR |
TableName | PRPSL_ESS_APPR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_ESS_APPR.PK_PRPSL_ESS_APPR Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
INSTR_ID | Ascending |
RUN_NBR | Ascending |
PERSON_ID | Ascending |
ROLE_ID | Ascending |
PRPSL_ESS_APPR.PK_PRPSL_ESS_APPR 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 |
PRPSL_ESS_APPR.PK_PRPSL_ESS_APPR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_ESS_APPR.PK_PRPSL_ESS_APPR Bound Attachments |
Name | Current Value |
PRPSL_FACIL.PK_PRPSL_FACIL |
TableName | PRPSL_FACIL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_FACIL.PK_PRPSL_FACIL Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
FACIL_ID | Ascending |
PRPSL_FACIL.PK_PRPSL_FACIL 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 |
PRPSL_FACIL.PK_PRPSL_FACIL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_FACIL.PK_PRPSL_FACIL Bound Attachments |
Name | Current Value |
PRPSL_FACIL.PRPSL_FACIL_IND1 |
TableName | PRPSL_FACIL |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.PRPSL_FACIL_IND1 ON PRPSL.PRPSL_FACIL(RUN_CYCLE_ID)      LOGGING ; |
PRPSL_FACIL.PRPSL_FACIL_IND1 Index Columns |
ColumnName | Sort Order |
RUN_CYCLE_ID | Ascending |
PRPSL_FACIL.PRPSL_FACIL_IND1 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 |
PRPSL_FACIL.PRPSL_FACIL_IND1 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_FACIL.PRPSL_FACIL_IND1 Bound Attachments |
Name | Current Value |
PRPSL_FACIL.REF5181074 |
TableName | PRPSL_FACIL |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.REF5181074 ON PRPSL.PRPSL_FACIL(FACIL_ID)      LOGGING ; |
PRPSL_FACIL.REF5181074 Index Columns |
ColumnName | Sort Order |
FACIL_ID | Ascending |
PRPSL_FACIL.REF5181074 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 |
PRPSL_FACIL.REF5181074 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_FACIL.REF5181074 Bound Attachments |
Name | Current Value |
PRPSL_FEAS_REV.PK_PRPSL_FEAS_REV |
TableName | PRPSL_FEAS_REV |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_FEAS_REV.PK_PRPSL_FEAS_REV Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
INSTR_ID | Ascending |
FEAS_REV_CAT_ID | Ascending |
FEAS_REVIEW_STAT_ID | Ascending |
PRPSL_FEAS_REV.PK_PRPSL_FEAS_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 |
PRPSL_FEAS_REV.PK_PRPSL_FEAS_REV Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_FEAS_REV.PK_PRPSL_FEAS_REV Bound Attachments |
Name | Current Value |
PRPSL_FUND.PK_PRPSL_FUND |
TableName | PRPSL_FUND |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_FUND.PK_PRPSL_FUND Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
FUND_ID | Ascending |
PRPSL_FUND.PK_PRPSL_FUND 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 |
PRPSL_FUND.PK_PRPSL_FUND Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_FUND.PK_PRPSL_FUND Bound Attachments |
Name | Current Value |
PRPSL_FUND.FK_PRPSL_FUND_PRPSL |
TableName | PRPSL_FUND |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_PRPSL_FUND_PRPSL ON PRPSL.PRPSL_FUND(PRPSL_ID)      LOGGING ; |
PRPSL_FUND.FK_PRPSL_FUND_PRPSL Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
PRPSL_FUND.FK_PRPSL_FUND_PRPSL 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 |
PRPSL_FUND.FK_PRPSL_FUND_PRPSL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_FUND.FK_PRPSL_FUND_PRPSL Bound Attachments |
Name | Current Value |
PRPSL_FUND.FK_PRPSL_FUND_FUND_SRC |
TableName | PRPSL_FUND |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_PRPSL_FUND_FUND_SRC ON PRPSL.PRPSL_FUND(FUND_ID)      LOGGING ; |
PRPSL_FUND.FK_PRPSL_FUND_FUND_SRC Index Columns |
ColumnName | Sort Order |
FUND_ID | Ascending |
PRPSL_FUND.FK_PRPSL_FUND_FUND_SRC 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 |
PRPSL_FUND.FK_PRPSL_FUND_FUND_SRC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_FUND.FK_PRPSL_FUND_FUND_SRC Bound Attachments |
Name | Current Value |
PRPSL_INSTR.PK_PRPSL_INSTR |
TableName | PRPSL_INSTR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_INSTR.PK_PRPSL_INSTR Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
INSTR_ID | Ascending |
PRPSL_INSTR.PK_PRPSL_INSTR 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 |
PRPSL_INSTR.PK_PRPSL_INSTR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_INSTR.PK_PRPSL_INSTR Bound Attachments |
Name | Current Value |
PRPSL_INSTR.PRPSL_INSTR_IND1 |
TableName | PRPSL_INSTR |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.PRPSL_INSTR_IND1 ON PRPSL.PRPSL_INSTR(INSTR_ID, INSTR_PREF)      LOGGING ; |
PRPSL_INSTR.PRPSL_INSTR_IND1 Index Columns |
ColumnName | Sort Order |
INSTR_ID | Ascending |
INSTR_PREF | Ascending |
PRPSL_INSTR.PRPSL_INSTR_IND1 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 |
PRPSL_INSTR.PRPSL_INSTR_IND1 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_INSTR.PRPSL_INSTR_IND1 Bound Attachments |
Name | Current Value |
PRPSL_INSTR.FK_INSTR_PRPSL_INSTR |
TableName | PRPSL_INSTR |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_INSTR_PRPSL_INSTR ON PRPSL.PRPSL_INSTR(INSTR_ID)      LOGGING ; |
PRPSL_INSTR.FK_INSTR_PRPSL_INSTR Index Columns |
ColumnName | Sort Order |
INSTR_ID | Ascending |
PRPSL_INSTR.FK_INSTR_PRPSL_INSTR 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 |
PRPSL_INSTR.FK_INSTR_PRPSL_INSTR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_INSTR.FK_INSTR_PRPSL_INSTR Bound Attachments |
Name | Current Value |
PRPSL_INSTR_GRP_CHAIR_REV.PK_PRPSL_INSTR_GRP_CHAIR_REV |
TableName | PRPSL_INSTR_GRP_CHAIR_REV |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_INSTR_GRP_CHAIR_REV.PK_PRPSL_INSTR_GRP_CHAIR_REV Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
FACIL_ID | Ascending |
GRP_ID | Ascending |
PERSON_ID | Ascending |
PRPSL_INSTR_GRP_CHAIR_REV.PK_PRPSL_INSTR_GRP_CHAIR_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 |
PRPSL_INSTR_GRP_CHAIR_REV.PK_PRPSL_INSTR_GRP_CHAIR_REV Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_INSTR_GRP_CHAIR_REV.PK_PRPSL_INSTR_GRP_CHAIR_REV Bound Attachments |
Name | Current Value |
PRPSL_INSTR_QUES.PK_PRPSL_INSTR_QUES |
TableName | PRPSL_INSTR_QUES |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_INSTR_QUES.PK_PRPSL_INSTR_QUES Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
INSTR_ID | Ascending |
QUESTION_ID | Ascending |
PRPSL_INSTR_QUES.PK_PRPSL_INSTR_QUES 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 |
PRPSL_INSTR_QUES.PK_PRPSL_INSTR_QUES Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_INSTR_QUES.PK_PRPSL_INSTR_QUES Bound Attachments |
Name | Current Value |
PRPSL_INSTR_SMPL_ENV_ASSC.PK_PRPSL_INSTR_SMPL_ENV_ASSC |
TableName | PRPSL_INSTR_SMPL_ENV_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_INSTR_SMPL_ENV_ASSC.PK_PRPSL_INSTR_SMPL_ENV_ASSC Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
SMPL_ENV_ID | Ascending |
INSTR_ID | Ascending |
PRPSL_INSTR_SMPL_ENV_ASSC.PK_PRPSL_INSTR_SMPL_ENV_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 |
PRPSL_INSTR_SMPL_ENV_ASSC.PK_PRPSL_INSTR_SMPL_ENV_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_INSTR_SMPL_ENV_ASSC.PK_PRPSL_INSTR_SMPL_ENV_ASSC Bound Attachments |
Name | Current Value |
PRPSL_INSTR_STAT.PK_PRPSL_INSTR_STAT |
TableName | PRPSL_INSTR_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_INSTR_STAT.PK_PRPSL_INSTR_STAT Index Columns |
ColumnName | Sort Order |
STAT_ID | Ascending |
PRPSL_INSTR_STAT.PK_PRPSL_INSTR_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 |
PRPSL_INSTR_STAT.PK_PRPSL_INSTR_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_INSTR_STAT.PK_PRPSL_INSTR_STAT Bound Attachments |
Name | Current Value |
PRPSL_LAB_REQ.PK_PRPSL_LAB_REQ |
TableName | PRPSL_LAB_REQ |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_LAB_REQ.PK_PRPSL_LAB_REQ Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
PRPSL_LAB_REQ.PK_PRPSL_LAB_REQ 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 |
PRPSL_LAB_REQ.PK_PRPSL_LAB_REQ Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_LAB_REQ.PK_PRPSL_LAB_REQ Bound Attachments |
Name | Current Value |
PRPSL_LAB_REQ_CHEM_ASSC.PK_PRPSL_LAB_REQ_CHEM_ASSC |
TableName | PRPSL_LAB_REQ_CHEM_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_LAB_REQ_CHEM_ASSC.PK_PRPSL_LAB_REQ_CHEM_ASSC Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
CHEM_NM | Ascending |
PRPSL_LAB_REQ_CHEM_ASSC.PK_PRPSL_LAB_REQ_CHEM_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 |
PRPSL_LAB_REQ_CHEM_ASSC.PK_PRPSL_LAB_REQ_CHEM_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_LAB_REQ_CHEM_ASSC.PK_PRPSL_LAB_REQ_CHEM_ASSC Bound Attachments |
Name | Current Value |
PRPSL_LAB_REQ_CHEM_PPE_ASSC.PK_LAB_REQ_CHEM_PPE_ASSC |
TableName | PRPSL_LAB_REQ_CHEM_PPE_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_LAB_REQ_CHEM_PPE_ASSC.PK_LAB_REQ_CHEM_PPE_ASSC Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
CHEM_NM | Ascending |
LAB_PPE_ID | Ascending |
PRPSL_LAB_REQ_CHEM_PPE_ASSC.PK_LAB_REQ_CHEM_PPE_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 |
PRPSL_LAB_REQ_CHEM_PPE_ASSC.PK_LAB_REQ_CHEM_PPE_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_LAB_REQ_CHEM_PPE_ASSC.PK_LAB_REQ_CHEM_PPE_ASSC Bound Attachments |
Name | Current Value |
PRPSL_LAB_REQ_FACIL_ASGN.PK_PRPSL_LAB_REQ_FACIL_ASGN |
TableName | PRPSL_LAB_REQ_FACIL_ASGN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_LAB_REQ_FACIL_ASGN.PK_PRPSL_LAB_REQ_FACIL_ASGN Index Columns |
ColumnName | Sort Order |
FACIL_ID | Ascending |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
PRPSL_LAB_REQ_FACIL_ASGN.PK_PRPSL_LAB_REQ_FACIL_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 |
PRPSL_LAB_REQ_FACIL_ASGN.PK_PRPSL_LAB_REQ_FACIL_ASGN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_LAB_REQ_FACIL_ASGN.PK_PRPSL_LAB_REQ_FACIL_ASGN Bound Attachments |
Name | Current Value |
PRPSL_LAB_REQ_HAZ_ASSC.PK_PRPSL_LAB_REQ_HAZ_ASSC |
TableName | PRPSL_LAB_REQ_HAZ_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_LAB_REQ_HAZ_ASSC.PK_PRPSL_LAB_REQ_HAZ_ASSC Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
CHEM_NM | Ascending |
SMPL_HAZ_ID | Ascending |
PRPSL_LAB_REQ_HAZ_ASSC.PK_PRPSL_LAB_REQ_HAZ_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 |
PRPSL_LAB_REQ_HAZ_ASSC.PK_PRPSL_LAB_REQ_HAZ_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_LAB_REQ_HAZ_ASSC.PK_PRPSL_LAB_REQ_HAZ_ASSC Bound Attachments |
Name | Current Value |
PRPSL_LAB_REQ_TM_ASSC.PK_PRPSL_LAB_REQ_TM_ASSC |
TableName | PRPSL_LAB_REQ_TM_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_LAB_REQ_TM_ASSC.PK_PRPSL_LAB_REQ_TM_ASSC Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
SEQ_ID | Ascending |
PRPSL_LAB_REQ_TM_ASSC.PK_PRPSL_LAB_REQ_TM_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 |
PRPSL_LAB_REQ_TM_ASSC.PK_PRPSL_LAB_REQ_TM_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_LAB_REQ_TM_ASSC.PK_PRPSL_LAB_REQ_TM_ASSC Bound Attachments |
Name | Current Value |
PRPSL_LAB_REQ_USAGE_ASSC.PK_LAB_REQ_USAGE_ASSC |
TableName | PRPSL_LAB_REQ_USAGE_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_LAB_REQ_USAGE_ASSC.PK_LAB_REQ_USAGE_ASSC Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
USAGE_TYPE_ID | Ascending |
PRPSL_LAB_REQ_USAGE_ASSC.PK_LAB_REQ_USAGE_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 |
PRPSL_LAB_REQ_USAGE_ASSC.PK_LAB_REQ_USAGE_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_LAB_REQ_USAGE_ASSC.PK_LAB_REQ_USAGE_ASSC Bound Attachments |
Name | Current Value |
PRPSL_LAB_SPEC_ASSC.PK_PRPSL_LAB_SPEC_ASSC |
TableName | PRPSL_LAB_SPEC_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_LAB_SPEC_ASSC.PK_PRPSL_LAB_SPEC_ASSC Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
SPEC_REQ_ID | Ascending |
PRPSL_LAB_SPEC_ASSC.PK_PRPSL_LAB_SPEC_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 |
PRPSL_LAB_SPEC_ASSC.PK_PRPSL_LAB_SPEC_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_LAB_SPEC_ASSC.PK_PRPSL_LAB_SPEC_ASSC Bound Attachments |
Name | Current Value |
PRPSL_LAB_SPEC_REQ_TYPE.PK_PRPSL_LAB_SPEC_REQ_TYPE |
TableName | PRPSL_LAB_SPEC_REQ_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_LAB_SPEC_REQ_TYPE.PK_PRPSL_LAB_SPEC_REQ_TYPE Index Columns |
ColumnName | Sort Order |
SPEC_REQ_ID | Ascending |
PRPSL_LAB_SPEC_REQ_TYPE.PK_PRPSL_LAB_SPEC_REQ_TYPE 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 |
PRPSL_LAB_SPEC_REQ_TYPE.PK_PRPSL_LAB_SPEC_REQ_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_LAB_SPEC_REQ_TYPE.PK_PRPSL_LAB_SPEC_REQ_TYPE Bound Attachments |
Name | Current Value |
PRPSL_LAB_USAGE_LVL.PK_PRPSL_LAB_USAGE_LVL |
TableName | PRPSL_LAB_USAGE_LVL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_LAB_USAGE_LVL.PK_PRPSL_LAB_USAGE_LVL Index Columns |
ColumnName | Sort Order |
WORK_LVL_ID | Ascending |
PRPSL_LAB_USAGE_LVL.PK_PRPSL_LAB_USAGE_LVL 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 |
PRPSL_LAB_USAGE_LVL.PK_PRPSL_LAB_USAGE_LVL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_LAB_USAGE_LVL.PK_PRPSL_LAB_USAGE_LVL Bound Attachments |
Name | Current Value |
PRPSL_LAB_USAGE_TYPE.PK_PRPSL_LAB_USAGE_TYPE |
TableName | PRPSL_LAB_USAGE_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_LAB_USAGE_TYPE.PK_PRPSL_LAB_USAGE_TYPE Index Columns |
ColumnName | Sort Order |
USAGE_TYPE_ID | Ascending |
PRPSL_LAB_USAGE_TYPE.PK_PRPSL_LAB_USAGE_TYPE 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 |
PRPSL_LAB_USAGE_TYPE.PK_PRPSL_LAB_USAGE_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_LAB_USAGE_TYPE.PK_PRPSL_LAB_USAGE_TYPE Bound Attachments |
Name | Current Value |
PRPSL_LOG.PK_PRPSL_LOG |
TableName | PRPSL_LOG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_LOG.PK_PRPSL_LOG Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
MOD_DTE | Ascending |
ACT_ID | Ascending |
PRPSL_LOG.PK_PRPSL_LOG 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 |
PRPSL_LOG.PK_PRPSL_LOG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_LOG.PK_PRPSL_LOG Bound Attachments |
Name | Current Value |
PRPSL_LOG.FK_PRPSL_LOG_PRPSL_ACT |
TableName | PRPSL_LOG |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_PRPSL_LOG_PRPSL_ACT ON PRPSL.PRPSL_LOG(ACT_ID)      LOGGING ; |
PRPSL_LOG.FK_PRPSL_LOG_PRPSL_ACT Index Columns |
ColumnName | Sort Order |
ACT_ID | Ascending |
PRPSL_LOG.FK_PRPSL_LOG_PRPSL_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 |
PRPSL_LOG.FK_PRPSL_LOG_PRPSL_ACT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_LOG.FK_PRPSL_LOG_PRPSL_ACT Bound Attachments |
Name | Current Value |
PRPSL_PDF.PK_PRPSL_PDF |
TableName | PRPSL_PDF |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_PDF.PK_PRPSL_PDF Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
PRPSL_PDF.PK_PRPSL_PDF 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 |
PRPSL_PDF.PK_PRPSL_PDF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_PDF.PK_PRPSL_PDF Bound Attachments |
Name | Current Value |
PRPSL_REV_WRKFLW.PK_PRPSL_WRKFLW |
TableName | PRPSL_REV_WRKFLW |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_REV_WRKFLW.PK_PRPSL_WRKFLW Index Columns |
ColumnName | Sort Order |
PRPSL_TYPE_ID | Ascending |
WORKFLOW_ID | Ascending |
ORDER_NBR | Ascending |
PRPSL_REV_WRKFLW.PK_PRPSL_WRKFLW 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 |
PRPSL_REV_WRKFLW.PK_PRPSL_WRKFLW Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_REV_WRKFLW.PK_PRPSL_WRKFLW Bound Attachments |
Name | Current Value |
PRPSL_REVIEW.PK_PRPSL_REVIEW |
TableName | PRPSL_REVIEW |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_REVIEW.PK_PRPSL_REVIEW Index Columns |
ColumnName | Sort Order |
REVIEW_ID | Ascending |
PRPSL_REVIEW.PK_PRPSL_REVIEW 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 |
PRPSL_REVIEW.PK_PRPSL_REVIEW Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_REVIEW.PK_PRPSL_REVIEW Bound Attachments |
Name | Current Value |
PRPSL_REVIEW_STAT.PK_PRPSL_REVIEW_STAT |
TableName | PRPSL_REVIEW_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_REVIEW_STAT.PK_PRPSL_REVIEW_STAT Index Columns |
ColumnName | Sort Order |
REVIEW_STAT_ID | Ascending |
PRPSL_REVIEW_STAT.PK_PRPSL_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 |
PRPSL_REVIEW_STAT.PK_PRPSL_REVIEW_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_REVIEW_STAT.PK_PRPSL_REVIEW_STAT Bound Attachments |
Name | Current Value |
PRPSL_ROLE.PK_PRPSL_ROLE |
TableName | PRPSL_ROLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_ROLE.PK_PRPSL_ROLE Index Columns |
ColumnName | Sort Order |
ROLE_ID | Ascending |
PRPSL_ROLE.PK_PRPSL_ROLE 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 |
PRPSL_ROLE.PK_PRPSL_ROLE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_ROLE.PK_PRPSL_ROLE Bound Attachments |
Name | Current Value |
PRPSL_ROLE_PERS_ASSC.PK_PRPSL_ROLE_PERS_ASSC |
TableName | PRPSL_ROLE_PERS_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_ROLE_PERS_ASSC.PK_PRPSL_ROLE_PERS_ASSC Index Columns |
ColumnName | Sort Order |
ROLE_ID | Ascending |
PERSON_ID | Ascending |
PRPSL_ROLE_PERS_ASSC.PK_PRPSL_ROLE_PERS_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 |
PRPSL_ROLE_PERS_ASSC.PK_PRPSL_ROLE_PERS_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_ROLE_PERS_ASSC.PK_PRPSL_ROLE_PERS_ASSC Bound Attachments |
Name | Current Value |
PRPSL_ROLE_PERS_ASSC.FK_PRPSL_ROLE_PRP_ASSC |
TableName | PRPSL_ROLE_PERS_ASSC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_PRPSL_ROLE_PRP_ASSC ON PRPSL.PRPSL_ROLE_PERS_ASSC(ROLE_ID)      LOGGING ; |
PRPSL_ROLE_PERS_ASSC.FK_PRPSL_ROLE_PRP_ASSC Index Columns |
ColumnName | Sort Order |
ROLE_ID | Ascending |
PRPSL_ROLE_PERS_ASSC.FK_PRPSL_ROLE_PRP_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 |
PRPSL_ROLE_PERS_ASSC.FK_PRPSL_ROLE_PRP_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_ROLE_PERS_ASSC.FK_PRPSL_ROLE_PRP_ASSC Bound Attachments |
Name | Current Value |
PRPSL_ROLE_PERS_ASSC.FK_PER_PRPSL_ROLE_ASSC |
TableName | PRPSL_ROLE_PERS_ASSC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_PER_PRPSL_ROLE_ASSC ON PRPSL.PRPSL_ROLE_PERS_ASSC(PERSON_ID)      LOGGING ; |
PRPSL_ROLE_PERS_ASSC.FK_PER_PRPSL_ROLE_ASSC Index Columns |
ColumnName | Sort Order |
PERSON_ID | Ascending |
PRPSL_ROLE_PERS_ASSC.FK_PER_PRPSL_ROLE_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 |
PRPSL_ROLE_PERS_ASSC.FK_PER_PRPSL_ROLE_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_ROLE_PERS_ASSC.FK_PER_PRPSL_ROLE_ASSC Bound Attachments |
Name | Current Value |
PRPSL_RSCH_AREA.PK_PRPSL_RSCH_AREA |
TableName | PRPSL_RSCH_AREA |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_RSCH_AREA.PK_PRPSL_RSCH_AREA Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
RSCH_AREA_ID | Ascending |
PRPSL_RSCH_AREA.PK_PRPSL_RSCH_AREA 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 |
PRPSL_RSCH_AREA.PK_PRPSL_RSCH_AREA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_RSCH_AREA.PK_PRPSL_RSCH_AREA Bound Attachments |
Name | Current Value |
PRPSL_SCI_REVIEW.PK_PRPSL_SCI_REVIEW |
TableName | PRPSL_SCI_REVIEW |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_SCI_REVIEW.PK_PRPSL_SCI_REVIEW Index Columns |
ColumnName | Sort Order |
PERSON_ID | Ascending |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
INSTR_ID | Ascending |
PRPSL_SCI_REVIEW.PK_PRPSL_SCI_REVIEW 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 |
PRPSL_SCI_REVIEW.PK_PRPSL_SCI_REVIEW Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_SCI_REVIEW.PK_PRPSL_SCI_REVIEW Bound Attachments |
Name | Current Value |
PRPSL_SCI_REVIEW.PRPSL_SCI_REV_PERS |
TableName | PRPSL_SCI_REVIEW |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.PRPSL_SCI_REV_PERS ON PRPSL.PRPSL_SCI_REVIEW(PERSON_ID, SUB_IND)      LOGGING ; |
PRPSL_SCI_REVIEW.PRPSL_SCI_REV_PERS Index Columns |
ColumnName | Sort Order |
PERSON_ID | Ascending |
SUB_IND | Ascending |
PRPSL_SCI_REVIEW.PRPSL_SCI_REV_PERS 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 |
PRPSL_SCI_REVIEW.PRPSL_SCI_REV_PERS Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_SCI_REVIEW.PRPSL_SCI_REV_PERS Bound Attachments |
Name | Current Value |
PRPSL_SCI_REVIEW.FK_PRPSL_SCI_RV_CRIT_TEAM_ABIL |
TableName | PRPSL_SCI_REVIEW |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_PRPSL_SCI_RV_CRIT_TEAM_ABIL ON PRPSL.PRPSL_SCI_REVIEW(CRIT_ID)      LOGGING ; |
PRPSL_SCI_REVIEW.FK_PRPSL_SCI_RV_CRIT_TEAM_ABIL Index Columns |
ColumnName | Sort Order |
CRIT_ID | Ascending |
PRPSL_SCI_REVIEW.FK_PRPSL_SCI_RV_CRIT_TEAM_ABIL 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 |
PRPSL_SCI_REVIEW.FK_PRPSL_SCI_RV_CRIT_TEAM_ABIL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_SCI_REVIEW.FK_PRPSL_SCI_RV_CRIT_TEAM_ABIL Bound Attachments |
Name | Current Value |
PRPSL_SCI_REVIEW.FK_PRPSL_SCI_RV_SCI_RV_MERIT |
TableName | PRPSL_SCI_REVIEW |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_PRPSL_SCI_RV_SCI_RV_MERIT ON PRPSL.PRPSL_SCI_REVIEW(RATING_ID)      LOGGING ; |
PRPSL_SCI_REVIEW.FK_PRPSL_SCI_RV_SCI_RV_MERIT Index Columns |
ColumnName | Sort Order |
RATING_ID | Ascending |
PRPSL_SCI_REVIEW.FK_PRPSL_SCI_RV_SCI_RV_MERIT 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 |
PRPSL_SCI_REVIEW.FK_PRPSL_SCI_RV_SCI_RV_MERIT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_SCI_REVIEW.FK_PRPSL_SCI_RV_SCI_RV_MERIT Bound Attachments |
Name | Current Value |
PRPSL_SRC_REVIEW.PK_PRPSL_SRC_REV |
TableName | PRPSL_SRC_REVIEW |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_SRC_REVIEW.PK_PRPSL_SRC_REV Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
INSTR_ID | Ascending |
PERSON_ID | Ascending |
PRPSL_SRC_REVIEW.PK_PRPSL_SRC_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 |
PRPSL_SRC_REVIEW.PK_PRPSL_SRC_REV Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_SRC_REVIEW.PK_PRPSL_SRC_REV Bound Attachments |
Name | Current Value |
PRPSL_SRCM_PI_STD_CMNT.PK_PRPSL_SRCM_PI_STD_CMNT |
TableName | PRPSL_SRCM_PI_STD_CMNT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_SRCM_PI_STD_CMNT.PK_PRPSL_SRCM_PI_STD_CMNT Index Columns |
ColumnName | Sort Order |
CMNT_ID | Ascending |
PRPSL_SRCM_PI_STD_CMNT.PK_PRPSL_SRCM_PI_STD_CMNT 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 |
PRPSL_SRCM_PI_STD_CMNT.PK_PRPSL_SRCM_PI_STD_CMNT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_SRCM_PI_STD_CMNT.PK_PRPSL_SRCM_PI_STD_CMNT Bound Attachments |
Name | Current Value |
PRPSL_STAT.PK_PRPSL_STAT |
TableName | PRPSL_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_STAT.PK_PRPSL_STAT Index Columns |
ColumnName | Sort Order |
STAT_ID | Ascending |
PRPSL_STAT.PK_PRPSL_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 |
PRPSL_STAT.PK_PRPSL_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_STAT.PK_PRPSL_STAT Bound Attachments |
Name | Current Value |
PRPSL_SUBJ_AREA.PK_PRPSL_SUBJ_AREA |
TableName | PRPSL_SUBJ_AREA |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_SUBJ_AREA.PK_PRPSL_SUBJ_AREA Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBJ_AREA_ID | Ascending |
PRPSL_SUBJ_AREA.PK_PRPSL_SUBJ_AREA 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 |
PRPSL_SUBJ_AREA.PK_PRPSL_SUBJ_AREA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_SUBJ_AREA.PK_PRPSL_SUBJ_AREA Bound Attachments |
Name | Current Value |
PRPSL_SUBMISS.PK_PRPSL_SUBMISS |
TableName | PRPSL_SUBMISS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_SUBMISS.PK_PRPSL_SUBMISS Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
PRPSL_SUBMISS.PK_PRPSL_SUBMISS 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 |
PRPSL_SUBMISS.PK_PRPSL_SUBMISS Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_SUBMISS.PK_PRPSL_SUBMISS Bound Attachments |
Name | Current Value |
PRPSL_SUBMISS_STAT.PK_PRPSL_SUBMIS_STAT |
TableName | PRPSL_SUBMISS_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_SUBMISS_STAT.PK_PRPSL_SUBMIS_STAT Index Columns |
ColumnName | Sort Order |
STAT_ID | Ascending |
PRPSL_SUBMISS_STAT.PK_PRPSL_SUBMIS_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 |
PRPSL_SUBMISS_STAT.PK_PRPSL_SUBMIS_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_SUBMISS_STAT.PK_PRPSL_SUBMIS_STAT Bound Attachments |
Name | Current Value |
PRPSL_TM_ONSITE_ACC.PK_PRPSL_TM_ONSITE_ACC |
TableName | PRPSL_TM_ONSITE_ACC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_TM_ONSITE_ACC.PK_PRPSL_TM_ONSITE_ACC Index Columns |
ColumnName | Sort Order |
PERSON_ID | Ascending |
PRPSL_TM_ONSITE_ACC.PK_PRPSL_TM_ONSITE_ACC 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 |
PRPSL_TM_ONSITE_ACC.PK_PRPSL_TM_ONSITE_ACC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_TM_ONSITE_ACC.PK_PRPSL_TM_ONSITE_ACC Bound Attachments |
Name | Current Value |
PRPSL_TM_ONSITE_EXPT_SCH_ASSC.PK_PRPSL_TM_ON_EXPT_SCH_ASSC |
TableName | PRPSL_TM_ONSITE_EXPT_SCH_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_TM_ONSITE_EXPT_SCH_ASSC.PK_PRPSL_TM_ON_EXPT_SCH_ASSC Index Columns |
ColumnName | Sort Order |
PERSON_ID | Ascending |
START_DTE | Ascending |
PRPSL_TM_ONSITE_EXPT_SCH_ASSC.PK_PRPSL_TM_ON_EXPT_SCH_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 |
PRPSL_TM_ONSITE_EXPT_SCH_ASSC.PK_PRPSL_TM_ON_EXPT_SCH_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_TM_ONSITE_EXPT_SCH_ASSC.PK_PRPSL_TM_ON_EXPT_SCH_ASSC Bound Attachments |
Name | Current Value |
PRPSL_TYPE.PK_PRPSL_TYPE |
TableName | PRPSL_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_TYPE.PK_PRPSL_TYPE Index Columns |
ColumnName | Sort Order |
PRPSL_TYPE_ID | Ascending |
PRPSL_TYPE.PK_PRPSL_TYPE 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 |
PRPSL_TYPE.PK_PRPSL_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_TYPE.PK_PRPSL_TYPE Bound Attachments |
Name | Current Value |
PRPSL_TYPE_INSTR_ASSC.PK_PRPSL_TYPE_INSTR_ASSC |
TableName | PRPSL_TYPE_INSTR_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_TYPE_INSTR_ASSC.PK_PRPSL_TYPE_INSTR_ASSC Index Columns |
ColumnName | Sort Order |
PRPSL_TYPE_ID | Ascending |
INSTR_ID | Ascending |
PRPSL_TYPE_INSTR_ASSC.PK_PRPSL_TYPE_INSTR_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 |
PRPSL_TYPE_INSTR_ASSC.PK_PRPSL_TYPE_INSTR_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_TYPE_INSTR_ASSC.PK_PRPSL_TYPE_INSTR_ASSC Bound Attachments |
Name | Current Value |
PRPSL_TYPE_PRPSL_REV_ASSC.PK_PRPSL_TYPE_PRPSL_REV_ASSC |
TableName | PRPSL_TYPE_PRPSL_REV_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_TYPE_PRPSL_REV_ASSC.PK_PRPSL_TYPE_PRPSL_REV_ASSC Index Columns |
ColumnName | Sort Order |
PRPSL_TYPE_ID | Ascending |
REVIEW_ID | Ascending |
PRPSL_TYPE_PRPSL_REV_ASSC.PK_PRPSL_TYPE_PRPSL_REV_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 |
PRPSL_TYPE_PRPSL_REV_ASSC.PK_PRPSL_TYPE_PRPSL_REV_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_TYPE_PRPSL_REV_ASSC.PK_PRPSL_TYPE_PRPSL_REV_ASSC Bound Attachments |
Name | Current Value |
PUBL.PK_RECENT_PUB |
TableName | PUBL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PUBL.PK_RECENT_PUB Index Columns |
ColumnName | Sort Order |
PERSON_ID | Ascending |
PRPSL_ID | Ascending |
PUBL.PK_RECENT_PUB 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 |
PUBL.PK_RECENT_PUB Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PUBL.PK_RECENT_PUB Bound Attachments |
Name | Current Value |
REL_PRPSL.PK_REL_PRPSL |
TableName | REL_PRPSL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
REL_PRPSL.PK_REL_PRPSL Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
REL_PRPSL_ID | Ascending |
REL_PRPSL.PK_REL_PRPSL 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 |
REL_PRPSL.PK_REL_PRPSL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REL_PRPSL.PK_REL_PRPSL Bound Attachments |
Name | Current Value |
REV_SUBCOMM.PK_REV_SUBCOMM |
TableName | REV_SUBCOMM |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
REV_SUBCOMM.PK_REV_SUBCOMM Index Columns |
ColumnName | Sort Order |
SUBCOMM_ID | Ascending |
REV_SUBCOMM.PK_REV_SUBCOMM 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 |
REV_SUBCOMM.PK_REV_SUBCOMM Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REV_SUBCOMM.PK_REV_SUBCOMM Bound Attachments |
Name | Current Value |
REV_SUBCOMM_PRPSL_ASSC.PK_REV_SUBCOMM_PRPSL_ASSC |
TableName | REV_SUBCOMM_PRPSL_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
REV_SUBCOMM_PRPSL_ASSC.PK_REV_SUBCOMM_PRPSL_ASSC Index Columns |
ColumnName | Sort Order |
SUBCOMM_ID | Ascending |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
INSTR_ID | Ascending |
REV_SUBCOMM_PRPSL_ASSC.PK_REV_SUBCOMM_PRPSL_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 |
REV_SUBCOMM_PRPSL_ASSC.PK_REV_SUBCOMM_PRPSL_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REV_SUBCOMM_PRPSL_ASSC.PK_REV_SUBCOMM_PRPSL_ASSC Bound Attachments |
Name | Current Value |
RSCH_AREA.PK_RSCH_AREA |
TableName | RSCH_AREA |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
RSCH_AREA.PK_RSCH_AREA Index Columns |
ColumnName | Sort Order |
RSCH_AREA_ID | Ascending |
RSCH_AREA.PK_RSCH_AREA 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 |
RSCH_AREA.PK_RSCH_AREA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RSCH_AREA.PK_RSCH_AREA Bound Attachments |
Name | Current Value |
RSCH_AREA_BES_RSCH_AREA_ASSC.PK_RSCH_AREA_BES_RSCH_AREA_ASSC |
TableName | RSCH_AREA_BES_RSCH_AREA_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
RSCH_AREA_BES_RSCH_AREA_ASSC.PK_RSCH_AREA_BES_RSCH_AREA_ASSC Index Columns |
ColumnName | Sort Order |
RSCH_AREA_ID | Ascending |
BES_RSCH_AREA_ID | Ascending |
RSCH_AREA_BES_RSCH_AREA_ASSC.PK_RSCH_AREA_BES_RSCH_AREA_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 |
RSCH_AREA_BES_RSCH_AREA_ASSC.PK_RSCH_AREA_BES_RSCH_AREA_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RSCH_AREA_BES_RSCH_AREA_ASSC.PK_RSCH_AREA_BES_RSCH_AREA_ASSC Bound Attachments |
Name | Current Value |
RSCH_AREA_INSTR_ASSC.PK_RSCH_AREA_INSTR_ASSC |
TableName | RSCH_AREA_INSTR_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
RSCH_AREA_INSTR_ASSC.PK_RSCH_AREA_INSTR_ASSC Index Columns |
ColumnName | Sort Order |
RSCH_AREA_ID | Ascending |
INSTR_ID | Ascending |
RSCH_AREA_INSTR_ASSC.PK_RSCH_AREA_INSTR_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 |
RSCH_AREA_INSTR_ASSC.PK_RSCH_AREA_INSTR_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RSCH_AREA_INSTR_ASSC.PK_RSCH_AREA_INSTR_ASSC Bound Attachments |
Name | Current Value |
RUN_CYCLE.PK_RUN_CYCLE |
TableName | RUN_CYCLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
RUN_CYCLE.PK_RUN_CYCLE Index Columns |
ColumnName | Sort Order |
FACIL_ID | Ascending |
RUN_CYCLE_ID | Ascending |
RUN_CYCLE.PK_RUN_CYCLE 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_CYCLE.PK_RUN_CYCLE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RUN_CYCLE.PK_RUN_CYCLE Bound Attachments |
Name | Current Value |
RUN_CYCLE_INSTR_REQ.PK_RUN_CYCLE_INSTR_REQ |
TableName | RUN_CYCLE_INSTR_REQ |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
RUN_CYCLE_INSTR_REQ.PK_RUN_CYCLE_INSTR_REQ Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
FACIL_ID | Ascending |
RUN_CYCLE_ID | Ascending |
INSTR_ID | Ascending |
RUN_CYCLE_INSTR_REQ.PK_RUN_CYCLE_INSTR_REQ 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_CYCLE_INSTR_REQ.PK_RUN_CYCLE_INSTR_REQ Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RUN_CYCLE_INSTR_REQ.PK_RUN_CYCLE_INSTR_REQ Bound Attachments |
Name | Current Value |
SCI_REVIEW_MERIT.PK_SCI_REVIEW_MERIT |
TableName | SCI_REVIEW_MERIT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SCI_REVIEW_MERIT.PK_SCI_REVIEW_MERIT Index Columns |
ColumnName | Sort Order |
RATING_ID | Ascending |
SCI_REVIEW_MERIT.PK_SCI_REVIEW_MERIT 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 |
SCI_REVIEW_MERIT.PK_SCI_REVIEW_MERIT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SCI_REVIEW_MERIT.PK_SCI_REVIEW_MERIT Bound Attachments |
Name | Current Value |
SCI_REVIEW_STAT.PK_SCI_REVIEW_STAT |
TableName | SCI_REVIEW_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SCI_REVIEW_STAT.PK_SCI_REVIEW_STAT Index Columns |
ColumnName | Sort Order |
SCI_REVIEW_STAT_ID | Ascending |
SCI_REVIEW_STAT.PK_SCI_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 |
SCI_REVIEW_STAT.PK_SCI_REVIEW_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SCI_REVIEW_STAT.PK_SCI_REVIEW_STAT Bound Attachments |
Name | Current Value |
SFTY_REVIEW_STAT.PK_SFTY_REVIEW_STAT |
TableName | SFTY_REVIEW_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SFTY_REVIEW_STAT.PK_SFTY_REVIEW_STAT Index Columns |
ColumnName | Sort Order |
SFTY_REVIEW_STAT_ID | Ascending |
SFTY_REVIEW_STAT.PK_SFTY_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 |
SFTY_REVIEW_STAT.PK_SFTY_REVIEW_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SFTY_REVIEW_STAT.PK_SFTY_REVIEW_STAT Bound Attachments |
Name | Current Value |
SRCM_FINDING.PK_SRCM_FINDING |
TableName | SRCM_FINDING |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SRCM_FINDING.PK_SRCM_FINDING Index Columns |
ColumnName | Sort Order |
FINDING_ID | Ascending |
SRCM_FINDING.PK_SRCM_FINDING 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 |
SRCM_FINDING.PK_SRCM_FINDING Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SRCM_FINDING.PK_SRCM_FINDING Bound Attachments |
Name | Current Value |
SUBJ_AREA.PK_SUBJ_AREA |
TableName | SUBJ_AREA |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SUBJ_AREA.PK_SUBJ_AREA Index Columns |
ColumnName | Sort Order |
SUBJ_AREA_ID | Ascending |
SUBJ_AREA.PK_SUBJ_AREA 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 |
SUBJ_AREA.PK_SUBJ_AREA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SUBJ_AREA.PK_SUBJ_AREA Bound Attachments |
Name | Current Value |
UNAVAIL_DTE.PK_UNAVAIL_DTE |
TableName | UNAVAIL_DTE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
UNAVAIL_DTE.PK_UNAVAIL_DTE Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
BEGIN_DTE | Ascending |
UNAVAIL_DTE.PK_UNAVAIL_DTE 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 |
UNAVAIL_DTE.PK_UNAVAIL_DTE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
UNAVAIL_DTE.PK_UNAVAIL_DTE Bound Attachments |
Name | Current Value |
UNIT_LEN.PK_UNIT_LEN |
TableName | UNIT_LEN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
UNIT_LEN.PK_UNIT_LEN Index Columns |
ColumnName | Sort Order |
LEN_UNIT_ID | Ascending |
UNIT_LEN.PK_UNIT_LEN 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 |
UNIT_LEN.PK_UNIT_LEN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
UNIT_LEN.PK_UNIT_LEN Bound Attachments |
Name | Current Value |
UNIT_MASS.PK_UNIT_MASS |
TableName | UNIT_MASS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
UNIT_MASS.PK_UNIT_MASS Index Columns |
ColumnName | Sort Order |
MASS_UNIT_ID | Ascending |
UNIT_MASS.PK_UNIT_MASS 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 |
UNIT_MASS.PK_UNIT_MASS Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
UNIT_MASS.PK_UNIT_MASS Bound Attachments |
Name | Current Value |
UNIT_TEMP.PK_UNIT_TEMP |
TableName | UNIT_TEMP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
UNIT_TEMP.PK_UNIT_TEMP Index Columns |
ColumnName | Sort Order |
TEMP_UNIT_ID | Ascending |
UNIT_TEMP.PK_UNIT_TEMP 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 |
UNIT_TEMP.PK_UNIT_TEMP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
UNIT_TEMP.PK_UNIT_TEMP Bound Attachments |
Name | Current Value |
USER_PROFILE.PK_USER_PROFILE |
TableName | USER_PROFILE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
USER_PROFILE.PK_USER_PROFILE Index Columns |
ColumnName | Sort Order |
PERSON_ID | Ascending |
USER_PROFILE.PK_USER_PROFILE 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 |
USER_PROFILE.PK_USER_PROFILE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
USER_PROFILE.PK_USER_PROFILE Bound Attachments |
Name | Current Value |
VAL_EXPT_TEAM_MBR.PK_VAL_EXPT_TEAM_MBR |
TableName | VAL_EXPT_TEAM_MBR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
VAL_EXPT_TEAM_MBR.PK_VAL_EXPT_TEAM_MBR Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
PERSON_ID | Ascending |
VAL_EXPT_TEAM_MBR.PK_VAL_EXPT_TEAM_MBR 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 |
VAL_EXPT_TEAM_MBR.PK_VAL_EXPT_TEAM_MBR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
VAL_EXPT_TEAM_MBR.PK_VAL_EXPT_TEAM_MBR Bound Attachments |
Name | Current Value |
VAL_EXPT_TEAM_MBR.FK_VAL_EXPT_TM_INST |
TableName | VAL_EXPT_TEAM_MBR |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_VAL_EXPT_TM_INST ON PRPSL.VAL_EXPT_TEAM_MBR(INST_ID)      LOGGING ; |
VAL_EXPT_TEAM_MBR.FK_VAL_EXPT_TM_INST Index Columns |
ColumnName | Sort Order |
INST_ID | Ascending |
VAL_EXPT_TEAM_MBR.FK_VAL_EXPT_TM_INST 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 |
VAL_EXPT_TEAM_MBR.FK_VAL_EXPT_TM_INST Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
VAL_EXPT_TEAM_MBR.FK_VAL_EXPT_TM_INST Bound Attachments |
Name | Current Value |
VAL_EXPT_TEAM_MBR.FK_VAL_EXPT_TM_PERSON |
TableName | VAL_EXPT_TEAM_MBR |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX PRPSL.FK_VAL_EXPT_TM_PERSON ON PRPSL.VAL_EXPT_TEAM_MBR(PERSON_ID)      LOGGING ; |
VAL_EXPT_TEAM_MBR.FK_VAL_EXPT_TM_PERSON Index Columns |
ColumnName | Sort Order |
PERSON_ID | Ascending |
VAL_EXPT_TEAM_MBR.FK_VAL_EXPT_TM_PERSON 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 |
VAL_EXPT_TEAM_MBR.FK_VAL_EXPT_TM_PERSON Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
VAL_EXPT_TEAM_MBR.FK_VAL_EXPT_TM_PERSON Bound Attachments |
Name | Current Value |
VAL_EXPT_TEAM_MBR.VAL_EXPT_TEAM_MBR_IND1 |
TableName | VAL_EXPT_TEAM_MBR |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX PRPSL.VAL_EXPT_TEAM_MBR_IND1 ON PRPSL.VAL_EXPT_TEAM_MBR(PERSON_ID, MBR_ROLE_ID)      LOGGING ; |
VAL_EXPT_TEAM_MBR.VAL_EXPT_TEAM_MBR_IND1 Index Columns |
ColumnName | Sort Order |
PERSON_ID | Ascending |
MBR_ROLE_ID | Ascending |
VAL_EXPT_TEAM_MBR.VAL_EXPT_TEAM_MBR_IND1 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 |
VAL_EXPT_TEAM_MBR.VAL_EXPT_TEAM_MBR_IND1 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
VAL_EXPT_TEAM_MBR.VAL_EXPT_TEAM_MBR_IND1 Bound Attachments |
Name | Current Value |
WORKFLOW.PK_WORKFLOW |
TableName | WORKFLOW |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
WORKFLOW.PK_WORKFLOW Index Columns |
ColumnName | Sort Order |
WORKFLOW_ID | Ascending |
WORKFLOW.PK_WORKFLOW 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 |
WORKFLOW.PK_WORKFLOW Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
WORKFLOW.PK_WORKFLOW Bound Attachments |
Name | Current Value |