ACCESS_REQ.PK_ACCESS_REQ |
TableName | ACCESS_REQ |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ACCESS_REQ.PK_ACCESS_REQ Index Columns |
ColumnName | Sort Order |
FACIL_ID | Ascending |
BN | Ascending |
ROLE_ID | Ascending |
ACCESS_REQ.PK_ACCESS_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 |
ACCESS_REQ.PK_ACCESS_REQ Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ACCESS_REQ.PK_ACCESS_REQ Bound Attachments |
Name | Current Value |
ADDL_COLOR_CODE.PK_ADDL_COLOR_CODE |
TableName | ADDL_COLOR_CODE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ADDL_COLOR_CODE.PK_ADDL_COLOR_CODE Index Columns |
ColumnName | Sort Order |
ID | Ascending |
ADDL_COLOR_CODE.PK_ADDL_COLOR_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 |
ADDL_COLOR_CODE.PK_ADDL_COLOR_CODE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ADDL_COLOR_CODE.PK_ADDL_COLOR_CODE Bound Attachments |
Name | Current Value |
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 |
CASC.PK_CASC |
TableName | CASC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CASC.PK_CASC Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_TYPE_ID | Ascending |
FACIL_ID | Ascending |
CASC.PK_CASC 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 |
CASC.PK_CASC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CASC.PK_CASC Bound Attachments |
Name | Current Value |
CASC_ATTACH_ASSC.PK_CASC_ATTACH_ASSC |
TableName | CASC_ATTACH_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CASC_ATTACH_ASSC.PK_CASC_ATTACH_ASSC Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_TYPE_ID | Ascending |
FACIL_ID | Ascending |
ATTACH_ID | Ascending |
CASC_ATTACH_ASSC.PK_CASC_ATTACH_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 |
CASC_ATTACH_ASSC.PK_CASC_ATTACH_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CASC_ATTACH_ASSC.PK_CASC_ATTACH_ASSC Bound Attachments |
Name | Current Value |
CASC_EXPT_RSRC_TYPE_ASSC.PK_CASC_EXPT_RSRC_TYPE_ASSC |
TableName | CASC_EXPT_RSRC_TYPE_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CASC_EXPT_RSRC_TYPE_ASSC.PK_CASC_EXPT_RSRC_TYPE_ASSC Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_TYPE_ID | Ascending |
EXPT_RSRC_TYPE2_ID | Ascending |
FACIL_ID | Ascending |
CASC_EXPT_RSRC_TYPE_ASSC.PK_CASC_EXPT_RSRC_TYPE_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 |
CASC_EXPT_RSRC_TYPE_ASSC.PK_CASC_EXPT_RSRC_TYPE_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CASC_EXPT_RSRC_TYPE_ASSC.PK_CASC_EXPT_RSRC_TYPE_ASSC Bound Attachments |
Name | Current Value |
CASC_EXPT_SCHED_ASSC.PK_CASC_EXPT_SCHED_ASSC |
TableName | CASC_EXPT_SCHED_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CASC_EXPT_SCHED_ASSC.PK_CASC_EXPT_SCHED_ASSC Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_TYPE_ID | Ascending |
FACIL_ID | Ascending |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
INSTR_ID | Ascending |
RUN_NBR | Ascending |
CASC_EXPT_SCHED_ASSC.PK_CASC_EXPT_SCHED_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 |
CASC_EXPT_SCHED_ASSC.PK_CASC_EXPT_SCHED_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CASC_EXPT_SCHED_ASSC.PK_CASC_EXPT_SCHED_ASSC Bound Attachments |
Name | Current Value |
CASC_INSTR_ASSC.PK_CASC_INSTR_ASSC |
TableName | CASC_INSTR_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CASC_INSTR_ASSC.PK_CASC_INSTR_ASSC Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_TYPE_ID | Ascending |
FACIL_ID | Ascending |
INSTR_ID | Ascending |
CASC_INSTR_ASSC.PK_CASC_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 |
CASC_INSTR_ASSC.PK_CASC_INSTR_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CASC_INSTR_ASSC.PK_CASC_INSTR_ASSC Bound Attachments |
Name | Current Value |
CASC_USAGE.PK_CASC_USAGE |
TableName | CASC_USAGE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CASC_USAGE.PK_CASC_USAGE Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_TYPE_ID | Ascending |
FACIL_ID | Ascending |
PERSON_ID | Ascending |
CUR_DTE | Ascending |
CASC_USAGE.PK_CASC_USAGE 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 |
CASC_USAGE.PK_CASC_USAGE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CASC_USAGE.PK_CASC_USAGE Bound Attachments |
Name | Current Value |
CLASS.PK_CLASS |
TableName | CLASS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CLASS.PK_CLASS Index Columns |
ColumnName | Sort Order |
CLASS_ID | Ascending |
CLASS.PK_CLASS 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 |
CLASS.PK_CLASS Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CLASS.PK_CLASS Bound Attachments |
Name | Current Value |
ELEC_CERT.PK_ELEC_CERT |
TableName | ELEC_CERT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ELEC_CERT.PK_ELEC_CERT Index Columns |
ColumnName | Sort Order |
ELEC_CERT_ID | Ascending |
ELEC_CERT.PK_ELEC_CERT 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 |
ELEC_CERT.PK_ELEC_CERT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ELEC_CERT.PK_ELEC_CERT Bound Attachments |
Name | Current Value |
EMAIL_SIGN.PK_EMAIL_SIGN |
TableName | EMAIL_SIGN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EMAIL_SIGN.PK_EMAIL_SIGN Index Columns |
ColumnName | Sort Order |
BN | Ascending |
INSTR_ID | Ascending |
EMAIL_SIGN.PK_EMAIL_SIGN 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 |
EMAIL_SIGN.PK_EMAIL_SIGN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EMAIL_SIGN.PK_EMAIL_SIGN Bound Attachments |
Name | Current Value |
EMAIL_TEMPLATE.PK_EMAIL_TEMPLATE |
TableName | EMAIL_TEMPLATE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EMAIL_TEMPLATE.PK_EMAIL_TEMPLATE Index Columns |
ColumnName | Sort Order |
TEMPLATE_ID | Ascending |
EMAIL_TEMPLATE.PK_EMAIL_TEMPLATE 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 |
EMAIL_TEMPLATE.PK_EMAIL_TEMPLATE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EMAIL_TEMPLATE.PK_EMAIL_TEMPLATE 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 | DIAG_TS |
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 |
EXP_ROLE_PERS_ASSC.PK_EXP_ROLE_PERS_ASSC |
TableName | EXP_ROLE_PERS_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXP_ROLE_PERS_ASSC.PK_EXP_ROLE_PERS_ASSC Index Columns |
ColumnName | Sort Order |
ROLE_ID | Ascending |
PERSON_ID | Ascending |
FACIL_ID | Ascending |
EXP_ROLE_PERS_ASSC.PK_EXP_ROLE_PERS_ASSC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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 |
EXP_ROLE_PERS_ASSC.PK_EXP_ROLE_PERS_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXP_ROLE_PERS_ASSC.PK_EXP_ROLE_PERS_ASSC Bound Attachments |
Name | Current Value |
EXP_USER_ROLE.PK_EXP_USER_ROLE |
TableName | EXP_USER_ROLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXP_USER_ROLE.PK_EXP_USER_ROLE Index Columns |
ColumnName | Sort Order |
ROLE_ID | Ascending |
EXP_USER_ROLE.PK_EXP_USER_ROLE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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 |
EXP_USER_ROLE.PK_EXP_USER_ROLE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXP_USER_ROLE.PK_EXP_USER_ROLE Bound Attachments |
Name | Current Value |
EXPRESS_ACT.PK_EXPRESS_ACT |
TableName | EXPRESS_ACT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPRESS_ACT.PK_EXPRESS_ACT Index Columns |
ColumnName | Sort Order |
ACT_ID | Ascending |
EXPRESS_ACT.PK_EXPRESS_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 |
EXPRESS_ACT.PK_EXPRESS_ACT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPRESS_ACT.PK_EXPRESS_ACT Bound Attachments |
Name | Current Value |
EXPRESS_LOG.PK_EXPRESS_LOG |
TableName | EXPRESS_LOG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPRESS_LOG.PK_EXPRESS_LOG Index Columns |
ColumnName | Sort Order |
ACT_ID | Ascending |
CUR_TIMESTAMP | Ascending |
EXPRESS_LOG.PK_EXPRESS_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 |
EXPRESS_LOG.PK_EXPRESS_LOG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPRESS_LOG.PK_EXPRESS_LOG 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_LAB_SCHED.PK_EXPT_LAB_SCHED |
TableName | EXPT_LAB_SCHED |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_LAB_SCHED.PK_EXPT_LAB_SCHED Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
INSTR_ID | Ascending |
RUN_NBR | Ascending |
LAB_ID | Ascending |
EXPT_LAB_SCHED.PK_EXPT_LAB_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_LAB_SCHED.PK_EXPT_LAB_SCHED Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_LAB_SCHED.PK_EXPT_LAB_SCHED Bound Attachments |
Name | Current Value |
EXPT_LAB_SCHED_LOG.PK_EXPT_LAB_SCHED_LOG |
TableName | EXPT_LAB_SCHED_LOG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_LAB_SCHED_LOG.PK_EXPT_LAB_SCHED_LOG Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
INSTR_ID | Ascending |
RUN_NBR | Ascending |
LAB_ID | Ascending |
ACT_ID | Ascending |
CUR_TIMESTAMP | Ascending |
EXPT_LAB_SCHED_LOG.PK_EXPT_LAB_SCHED_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 |
EXPT_LAB_SCHED_LOG.PK_EXPT_LAB_SCHED_LOG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_LAB_SCHED_LOG.PK_EXPT_LAB_SCHED_LOG Bound Attachments |
Name | Current Value |
EXPT_LAB_SCHED_WRKFLW.PK_EXPT_LAB_WRKFLW |
TableName | EXPT_LAB_SCHED_WRKFLW |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_LAB_SCHED_WRKFLW.PK_EXPT_LAB_WRKFLW Index Columns |
ColumnName | Sort Order |
FACIL_ID | Ascending |
WORKFLOW_ID | Ascending |
ORDER_NBR | Ascending |
EXPT_LAB_SCHED_WRKFLW.PK_EXPT_LAB_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 |
EXPT_LAB_SCHED_WRKFLW.PK_EXPT_LAB_WRKFLW Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_LAB_SCHED_WRKFLW.PK_EXPT_LAB_WRKFLW Bound Attachments |
Name | Current Value |
EXPT_LAB_STAT.PK_EXPT_LAB_STAT |
TableName | EXPT_LAB_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_LAB_STAT.PK_EXPT_LAB_STAT Index Columns |
ColumnName | Sort Order |
STAT_ID | Ascending |
EXPT_LAB_STAT.PK_EXPT_LAB_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 |
EXPT_LAB_STAT.PK_EXPT_LAB_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_LAB_STAT.PK_EXPT_LAB_STAT Bound Attachments |
Name | Current Value |
EXPT_RSRC.PK_EXPT_RSRC |
TableName | EXPT_RSRC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC.PK_EXPT_RSRC Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_ID | Ascending |
EXPT_RSRC.PK_EXPT_RSRC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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.PK_EXPT_RSRC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC.PK_EXPT_RSRC Bound Attachments |
Name | Current Value |
EXPT_RSRC_ASSC.PK_EXPT_RSRC_ASSC |
TableName | EXPT_RSRC_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_ASSC.PK_EXPT_RSRC_ASSC Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_ID_1 | Ascending |
EXPT_RSRC_ID_2 | Ascending |
EXPT_RSRC_ASSC.PK_EXPT_RSRC_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_RSRC_ASSC.PK_EXPT_RSRC_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_ASSC.PK_EXPT_RSRC_ASSC Bound Attachments |
Name | Current Value |
EXPT_RSRC_ATTACH.PK_EXPT_RSRC_ATTACH |
TableName | EXPT_RSRC_ATTACH |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_ATTACH.PK_EXPT_RSRC_ATTACH Index Columns |
ColumnName | Sort Order |
ATTACH_ID | Ascending |
EXPT_RSRC_ATTACH.PK_EXPT_RSRC_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 |
EXPT_RSRC_ATTACH.PK_EXPT_RSRC_ATTACH Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_ATTACH.PK_EXPT_RSRC_ATTACH Bound Attachments |
Name | Current Value |
EXPT_RSRC_ATTACH_ASSC.PK_EXPT_RSRC_ATTACH_ASSC |
TableName | EXPT_RSRC_ATTACH_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_ATTACH_ASSC.PK_EXPT_RSRC_ATTACH_ASSC Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_ID | Ascending |
ATTACH_ID | Ascending |
EXPT_RSRC_ATTACH_ASSC.PK_EXPT_RSRC_ATTACH_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_RSRC_ATTACH_ASSC.PK_EXPT_RSRC_ATTACH_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_ATTACH_ASSC.PK_EXPT_RSRC_ATTACH_ASSC Bound Attachments |
Name | Current Value |
EXPT_RSRC_ATTACH_TYPE.PK_EXPT_RSRC_ATTACH_TYPE |
TableName | EXPT_RSRC_ATTACH_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_ATTACH_TYPE.PK_EXPT_RSRC_ATTACH_TYPE Index Columns |
ColumnName | Sort Order |
ATTACH_TYPE_ID | Ascending |
EXPT_RSRC_ATTACH_TYPE.PK_EXPT_RSRC_ATTACH_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 |
EXPT_RSRC_ATTACH_TYPE.PK_EXPT_RSRC_ATTACH_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_ATTACH_TYPE.PK_EXPT_RSRC_ATTACH_TYPE Bound Attachments |
Name | Current Value |
EXPT_RSRC_COMM_TYPE.PK_EXPT_RSRC_COMM_TYPE |
TableName | EXPT_RSRC_COMM_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_COMM_TYPE.PK_EXPT_RSRC_COMM_TYPE Index Columns |
ColumnName | Sort Order |
COMM_REQ_ID | Ascending |
EXPT_RSRC_COMM_TYPE.PK_EXPT_RSRC_COMM_TYPE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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_COMM_TYPE.PK_EXPT_RSRC_COMM_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_COMM_TYPE.PK_EXPT_RSRC_COMM_TYPE Bound Attachments |
Name | Current Value |
EXPT_RSRC_FACIL.PK_EXPT_RSRC_FACIL_1 |
TableName | EXPT_RSRC_FACIL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_FACIL.PK_EXPT_RSRC_FACIL_1 Index Columns |
ColumnName | Sort Order |
FACIL_ID | Ascending |
EXPT_RSRC_FACIL.PK_EXPT_RSRC_FACIL_1 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_FACIL.PK_EXPT_RSRC_FACIL_1 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_FACIL.PK_EXPT_RSRC_FACIL_1 Bound Attachments |
Name | Current Value |
EXPT_RSRC_GRP.PK_EXPT_RSRC_GRP |
TableName | EXPT_RSRC_GRP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_GRP.PK_EXPT_RSRC_GRP Index Columns |
ColumnName | Sort Order |
EXPT_RESC_GRP_NM | Ascending |
EXPT_RSRC_GRP.PK_EXPT_RSRC_GRP Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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_GRP.PK_EXPT_RSRC_GRP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_GRP.PK_EXPT_RSRC_GRP Bound Attachments |
Name | Current Value |
EXPT_RSRC_GRP_ASSC.PK_EXPT_RSRC_GRP_ASSC |
TableName | EXPT_RSRC_GRP_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_GRP_ASSC.PK_EXPT_RSRC_GRP_ASSC Index Columns |
ColumnName | Sort Order |
EXPT_RESC_GRP_NM | Ascending |
EXPT_RSRC_ID | Ascending |
EXPT_RSRC_GRP_ASSC.PK_EXPT_RSRC_GRP_ASSC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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_GRP_ASSC.PK_EXPT_RSRC_GRP_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_GRP_ASSC.PK_EXPT_RSRC_GRP_ASSC Bound Attachments |
Name | Current Value |
EXPT_RSRC_INSTR_ASSC.PK_EXPT_RSRC_INSTR_ASSC |
TableName | EXPT_RSRC_INSTR_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_INSTR_ASSC.PK_EXPT_RSRC_INSTR_ASSC Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_ID | Ascending |
INSTR_ID | Ascending |
EXPT_RSRC_INSTR_ASSC.PK_EXPT_RSRC_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 |
EXPT_RSRC_INSTR_ASSC.PK_EXPT_RSRC_INSTR_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_INSTR_ASSC.PK_EXPT_RSRC_INSTR_ASSC Bound Attachments |
Name | Current Value |
EXPT_RSRC_LOC.PK_EXPT_RSRC_LOC |
TableName | EXPT_RSRC_LOC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_LOC.PK_EXPT_RSRC_LOC Index Columns |
ColumnName | Sort Order |
FACIL_ID | Ascending |
LOC_ID | Ascending |
EXPT_RSRC_LOC.PK_EXPT_RSRC_LOC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
EXPT_RSRC_LOC.PK_EXPT_RSRC_LOC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_LOC.PK_EXPT_RSRC_LOC Bound Attachments |
Name | Current Value |
EXPT_RSRC_LOG.PK_EXPT_RSRC_LOG |
TableName | EXPT_RSRC_LOG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_LOG.PK_EXPT_RSRC_LOG Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_ID | Ascending |
ACT_ID | Ascending |
CUR_TIMESTAMP | Ascending |
EXPT_RSRC_LOG.PK_EXPT_RSRC_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 |
EXPT_RSRC_LOG.PK_EXPT_RSRC_LOG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_LOG.PK_EXPT_RSRC_LOG Bound Attachments |
Name | Current Value |
EXPT_RSRC_MAINT.PK_EXPT_RSRC_MAINT |
TableName | EXPT_RSRC_MAINT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_MAINT.PK_EXPT_RSRC_MAINT Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_ID | Ascending |
ACT_ID | Ascending |
EXPT_RSRC_MAINT.PK_EXPT_RSRC_MAINT 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_MAINT.PK_EXPT_RSRC_MAINT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_MAINT.PK_EXPT_RSRC_MAINT Bound Attachments |
Name | Current Value |
EXPT_RSRC_MAINT_SCHED.PK_EXPT_RSRC_MAINT_SCHED |
TableName | EXPT_RSRC_MAINT_SCHED |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_MAINT_SCHED.PK_EXPT_RSRC_MAINT_SCHED Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_ID | Ascending |
EXPT_RSRC_MAINT_SCHED.PK_EXPT_RSRC_MAINT_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_MAINT_SCHED.PK_EXPT_RSRC_MAINT_SCHED Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_MAINT_SCHED.PK_EXPT_RSRC_MAINT_SCHED Bound Attachments |
Name | Current Value |
EXPT_RSRC_MANUF.PK_EXPT_RSRC_MANUF |
TableName | EXPT_RSRC_MANUF |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_MANUF.PK_EXPT_RSRC_MANUF Index Columns |
ColumnName | Sort Order |
MANUF_ID | Ascending |
EXPT_RSRC_MANUF.PK_EXPT_RSRC_MANUF 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_MANUF.PK_EXPT_RSRC_MANUF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_MANUF.PK_EXPT_RSRC_MANUF Bound Attachments |
Name | Current Value |
EXPT_RSRC_PERS_ABS.PK_EXPT_RSRC_PERS_ABS |
TableName | EXPT_RSRC_PERS_ABS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_PERS_ABS.PK_EXPT_RSRC_PERS_ABS Index Columns |
ColumnName | Sort Order |
BN | Ascending |
ABS_TYPE_CD | Ascending |
ABS_START_DTE | Ascending |
EXPT_RSRC_PERS_ABS.PK_EXPT_RSRC_PERS_ABS Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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_PERS_ABS.PK_EXPT_RSRC_PERS_ABS Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_PERS_ABS.PK_EXPT_RSRC_PERS_ABS Bound Attachments |
Name | Current Value |
EXPT_RSRC_PERS_ASSC.PK_EXPT_RSRC_PERS_ASSC |
TableName | EXPT_RSRC_PERS_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_PERS_ASSC.PK_EXPT_RSRC_PERS_ASSC Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_ID | Ascending |
BN | Ascending |
EXPT_RSRC_PERS_ASSC.PK_EXPT_RSRC_PERS_ASSC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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_PERS_ASSC.PK_EXPT_RSRC_PERS_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_PERS_ASSC.PK_EXPT_RSRC_PERS_ASSC Bound Attachments |
Name | Current Value |
EXPT_RSRC_PERS_RSRC.PK_EXPT_RSRC_PERS_RSRC |
TableName | EXPT_RSRC_PERS_RSRC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_PERS_RSRC.PK_EXPT_RSRC_PERS_RSRC Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_ID | Ascending |
BN | Ascending |
EXPT_RSRC_PERS_RSRC.PK_EXPT_RSRC_PERS_RSRC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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_PERS_RSRC.PK_EXPT_RSRC_PERS_RSRC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_PERS_RSRC.PK_EXPT_RSRC_PERS_RSRC Bound Attachments |
Name | Current Value |
EXPT_RSRC_PERS_TRAIN.PK_EXPT_RSRC_PERS_TRAIN |
TableName | EXPT_RSRC_PERS_TRAIN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_PERS_TRAIN.PK_EXPT_RSRC_PERS_TRAIN Index Columns |
ColumnName | Sort Order |
TRAIN_MOD_ID | Ascending |
BN | Ascending |
EXPT_RSRC_PERS_TRAIN.PK_EXPT_RSRC_PERS_TRAIN Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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_PERS_TRAIN.PK_EXPT_RSRC_PERS_TRAIN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_PERS_TRAIN.PK_EXPT_RSRC_PERS_TRAIN Bound Attachments |
Name | Current Value |
EXPT_RSRC_QUES.PK_SCHED_QUES |
TableName | EXPT_RSRC_QUES |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_QUES.PK_SCHED_QUES Index Columns |
ColumnName | Sort Order |
QUES_ID | Ascending |
EXPT_RSRC_QUES.PK_SCHED_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 |
EXPT_RSRC_QUES.PK_SCHED_QUES Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_QUES.PK_SCHED_QUES Bound Attachments |
Name | Current Value |
EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC.PK_EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC |
TableName | EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC.PK_EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_ID | Ascending |
QUES_ID | Ascending |
EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC.PK_EXPT_RSRC_QUES_EXPT_RSRC_SCHED_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_RSRC_QUES_EXPT_RSRC_SCHED_ASSC.PK_EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC.PK_EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC Bound Attachments |
Name | Current Value |
EXPT_RSRC_REQ_TYPE.PK_EXPT_RSRC_REQ_TYPE |
TableName | EXPT_RSRC_REQ_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_REQ_TYPE.PK_EXPT_RSRC_REQ_TYPE Index Columns |
ColumnName | Sort Order |
REQ_TYPE_ID | Ascending |
EXPT_RSRC_REQ_TYPE.PK_EXPT_RSRC_REQ_TYPE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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_REQ_TYPE.PK_EXPT_RSRC_REQ_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_REQ_TYPE.PK_EXPT_RSRC_REQ_TYPE 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 | DIAG_TS |
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_RSRC_SCHED_LOG.PK_EXPT_RSRC_SCHED_LOG |
TableName | EXPT_RSRC_SCHED_LOG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_SCHED_LOG.PK_EXPT_RSRC_SCHED_LOG Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_ID | Ascending |
ACT_ID | Ascending |
CUR_TIMESTAMP | Ascending |
EXPT_RSRC_SCHED_LOG.PK_EXPT_RSRC_SCHED_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 |
EXPT_RSRC_SCHED_LOG.PK_EXPT_RSRC_SCHED_LOG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_SCHED_LOG.PK_EXPT_RSRC_SCHED_LOG Bound Attachments |
Name | Current Value |
EXPT_RSRC_SCHED_STAT.PK_EXPT_RSRC_SCHED_STAT |
TableName | EXPT_RSRC_SCHED_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_SCHED_STAT.PK_EXPT_RSRC_SCHED_STAT Index Columns |
ColumnName | Sort Order |
STAT_ID | Ascending |
EXPT_RSRC_SCHED_STAT.PK_EXPT_RSRC_SCHED_STAT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
EXPT_RSRC_SCHED_STAT.PK_EXPT_RSRC_SCHED_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_SCHED_STAT.PK_EXPT_RSRC_SCHED_STAT Bound Attachments |
Name | Current Value |
EXPT_RSRC_SCHED_WRKFLW.PK_EXPT_RSRC_SCHED_WRKFLW |
TableName | EXPT_RSRC_SCHED_WRKFLW |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_SCHED_WRKFLW.PK_EXPT_RSRC_SCHED_WRKFLW Index Columns |
ColumnName | Sort Order |
FACIL_ID | Ascending |
WORKFLOW_ID | Ascending |
ORDER_NBR | Ascending |
EXPT_RSRC_SCHED_WRKFLW.PK_EXPT_RSRC_SCHED_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 |
EXPT_RSRC_SCHED_WRKFLW.PK_EXPT_RSRC_SCHED_WRKFLW Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_SCHED_WRKFLW.PK_EXPT_RSRC_SCHED_WRKFLW Bound Attachments |
Name | Current Value |
EXPT_RSRC_STAT.PK_EXPT_RSRC_STAT |
TableName | EXPT_RSRC_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_STAT.PK_EXPT_RSRC_STAT Index Columns |
ColumnName | Sort Order |
STAT_ID | Ascending |
EXPT_RSRC_STAT.PK_EXPT_RSRC_STAT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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_STAT.PK_EXPT_RSRC_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_STAT.PK_EXPT_RSRC_STAT Bound Attachments |
Name | Current Value |
EXPT_RSRC_STAT_HIST.PK_EXPT_RSRC_STAT_HIST |
TableName | EXPT_RSRC_STAT_HIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_STAT_HIST.PK_EXPT_RSRC_STAT_HIST Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_ID | Ascending |
EXPT_RSRC_STAT_HIST.PK_EXPT_RSRC_STAT_HIST Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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_STAT_HIST.PK_EXPT_RSRC_STAT_HIST Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_STAT_HIST.PK_EXPT_RSRC_STAT_HIST Bound Attachments |
Name | Current Value |
EXPT_RSRC_SUBTYPE.PK_EXPT_RSRC_SUBTYPE |
TableName | EXPT_RSRC_SUBTYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_SUBTYPE.PK_EXPT_RSRC_SUBTYPE Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_TYPE_ID | Ascending |
EXPT_RSRC_SUBTYPE_ID | Ascending |
FACIL_ID | Ascending |
EXPT_RSRC_SUBTYPE.PK_EXPT_RSRC_SUBTYPE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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_SUBTYPE.PK_EXPT_RSRC_SUBTYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_SUBTYPE.PK_EXPT_RSRC_SUBTYPE Bound Attachments |
Name | Current Value |
EXPT_RSRC_TRAIN.PK_EXPT_RSRC_TRAIN |
TableName | EXPT_RSRC_TRAIN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_TRAIN.PK_EXPT_RSRC_TRAIN Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_ID | Ascending |
TRAIN_MOD_ID | Ascending |
EXPT_RSRC_TRAIN.PK_EXPT_RSRC_TRAIN Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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_TRAIN.PK_EXPT_RSRC_TRAIN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_TRAIN.PK_EXPT_RSRC_TRAIN Bound Attachments |
Name | Current Value |
EXPT_RSRC_TRAIN_MOD.PK_EXPT_RSRC_TRAIN_MOD |
TableName | EXPT_RSRC_TRAIN_MOD |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_TRAIN_MOD.PK_EXPT_RSRC_TRAIN_MOD Index Columns |
ColumnName | Sort Order |
TRAIN_MOD_ID | Ascending |
EXPT_RSRC_TRAIN_MOD.PK_EXPT_RSRC_TRAIN_MOD Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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_TRAIN_MOD.PK_EXPT_RSRC_TRAIN_MOD Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_TRAIN_MOD.PK_EXPT_RSRC_TRAIN_MOD Bound Attachments |
Name | Current Value |
EXPT_RSRC_TYPE.PK_EXPT_RSRC_TYPE |
TableName | EXPT_RSRC_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_TYPE.PK_EXPT_RSRC_TYPE Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_TYPE_ID | Ascending |
FACIL_ID | Ascending |
EXPT_RSRC_TYPE.PK_EXPT_RSRC_TYPE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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_TYPE.PK_EXPT_RSRC_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_TYPE.PK_EXPT_RSRC_TYPE Bound Attachments |
Name | Current Value |
EXPT_RSRC_UNAVAIL.PK_EXPT_RSRC_UNAVAIL |
TableName | EXPT_RSRC_UNAVAIL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_RSRC_UNAVAIL.PK_EXPT_RSRC_UNAVAIL Index Columns |
ColumnName | Sort Order |
EXPT_RSRC_ID | Ascending |
BEG_DTE | Ascending |
EXPT_RSRC_UNAVAIL.PK_EXPT_RSRC_UNAVAIL 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_UNAVAIL.PK_EXPT_RSRC_UNAVAIL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_RSRC_UNAVAIL.PK_EXPT_RSRC_UNAVAIL 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_SCHED_EMAIL_LOG.PK_EXPT_SCHED_EMAIL_LOG |
TableName | EXPT_SCHED_EMAIL_LOG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_SCHED_EMAIL_LOG.PK_EXPT_SCHED_EMAIL_LOG Index Columns |
ColumnName | Sort Order |
TEMPLATE_ID | Ascending |
CUR_DTE | Ascending |
EXPT_SCHED_EMAIL_LOG.PK_EXPT_SCHED_EMAIL_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 |
EXPT_SCHED_EMAIL_LOG.PK_EXPT_SCHED_EMAIL_LOG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SCHED_EMAIL_LOG.PK_EXPT_SCHED_EMAIL_LOG Bound Attachments |
Name | Current Value |
EXPT_SCHED_LOC_CONT_ASSC.PK_EXPT_SCH_LOC_CONT_ASSC |
TableName | EXPT_SCHED_LOC_CONT_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_SCHED_LOC_CONT_ASSC.PK_EXPT_SCH_LOC_CONT_ASSC Index Columns |
ColumnName | Sort Order |
BN | Ascending |
EXPT_SCHED_LOC_CONT_ASSC.PK_EXPT_SCH_LOC_CONT_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_SCHED_LOC_CONT_ASSC.PK_EXPT_SCH_LOC_CONT_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SCHED_LOC_CONT_ASSC.PK_EXPT_SCH_LOC_CONT_ASSC Bound Attachments |
Name | Current Value |
EXPT_SCHED_LOG.PK_EXPT_SCHED_LOG |
TableName | EXPT_SCHED_LOG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_SCHED_LOG.PK_EXPT_SCHED_LOG Index Columns |
ColumnName | Sort Order |
ACT_ID | Ascending |
CUR_TIMESTAMP | Ascending |
EXPT_SCHED_LOG.PK_EXPT_SCHED_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 |
EXPT_SCHED_LOG.PK_EXPT_SCHED_LOG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SCHED_LOG.PK_EXPT_SCHED_LOG Bound Attachments |
Name | Current Value |
EXPT_SCHED_STAT.PK_EXPT_SCHED_STAT |
TableName | EXPT_SCHED_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_SCHED_STAT.PK_EXPT_SCHED_STAT Index Columns |
ColumnName | Sort Order |
STAT_ID | Ascending |
EXPT_SCHED_STAT.PK_EXPT_SCHED_STAT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
EXPT_SCHED_STAT.PK_EXPT_SCHED_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SCHED_STAT.PK_EXPT_SCHED_STAT Bound Attachments |
Name | Current Value |
EXPT_SCHED_WRKFLW.PK_EXPT_SCHED_WRKFLW |
TableName | EXPT_SCHED_WRKFLW |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_SCHED_WRKFLW.PK_EXPT_SCHED_WRKFLW Index Columns |
ColumnName | Sort Order |
FACIL_ID | Ascending |
WORKFLOW_ID | Ascending |
ORDER_NBR | Ascending |
EXPT_SCHED_WRKFLW.PK_EXPT_SCHED_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 |
EXPT_SCHED_WRKFLW.PK_EXPT_SCHED_WRKFLW Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_SCHED_WRKFLW.PK_EXPT_SCHED_WRKFLW Bound Attachments |
Name | Current Value |
EXPT_WORKFLOW.PK_EXPT_WORKFLOW |
TableName | EXPT_WORKFLOW |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EXPT_WORKFLOW.PK_EXPT_WORKFLOW Index Columns |
ColumnName | Sort Order |
WORKFLOW_ID | Ascending |
EXPT_WORKFLOW.PK_EXPT_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 |
EXPT_WORKFLOW.PK_EXPT_WORKFLOW Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EXPT_WORKFLOW.PK_EXPT_WORKFLOW 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 | DIAG_TS |
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 |
LAB.PK_LAB |
TableName | LAB |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LAB.PK_LAB Index Columns |
ColumnName | Sort Order |
LAB_ID | Ascending |
LAB.PK_LAB Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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 |
LAB.PK_LAB Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LAB.PK_LAB Bound Attachments |
Name | Current Value |
LAB_WORKFLOW.PK_LAB_WORKFLOW |
TableName | LAB_WORKFLOW |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LAB_WORKFLOW.PK_LAB_WORKFLOW Index Columns |
ColumnName | Sort Order |
WORKFLOW_ID | Ascending |
LAB_WORKFLOW.PK_LAB_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 |
LAB_WORKFLOW.PK_LAB_WORKFLOW Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LAB_WORKFLOW.PK_LAB_WORKFLOW Bound Attachments |
Name | Current Value |
MAINT_ACT.PK_MAINT_ACT |
TableName | MAINT_ACT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MAINT_ACT.PK_MAINT_ACT Index Columns |
ColumnName | Sort Order |
ACT_ID | Ascending |
MAINT_ACT.PK_MAINT_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 |
MAINT_ACT.PK_MAINT_ACT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MAINT_ACT.PK_MAINT_ACT 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 | DIAG_TS |
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.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) TABLESPACE DIAG_TS      LOGGING ; |
PERSON.idx_username Index Columns |
ColumnName | Sort Order |
USRNM | Ascending |
PERSON.idx_username Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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 |
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 | DIAG_TS |
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_GRP.PK_PRPSL_GRP |
TableName | PRPSL_GRP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_GRP.PK_PRPSL_GRP Index Columns |
ColumnName | Sort Order |
PRPSL_GRP_ID | Ascending |
PRPSL_GRP.PK_PRPSL_GRP Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
PRPSL_GRP.PK_PRPSL_GRP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_GRP.PK_PRPSL_GRP Bound Attachments |
Name | Current Value |
PRPSL_GRP_PRPSL_ASSC.PK_PRPSL_GRP_PRPSL_ASSC |
TableName | PRPSL_GRP_PRPSL_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_GRP_PRPSL_ASSC.PK_PRPSL_GRP_PRPSL_ASSC Index Columns |
ColumnName | Sort Order |
PRPSL_GRP_ID | Ascending |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
PRPSL_GRP_PRPSL_ASSC.PK_PRPSL_GRP_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 |
PRPSL_GRP_PRPSL_ASSC.PK_PRPSL_GRP_PRPSL_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_GRP_PRPSL_ASSC.PK_PRPSL_GRP_PRPSL_ASSC 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.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_LOG_ENTRY_ASSC.PK_PRPSL_LOG_ENTRY_ASSC |
TableName | PRPSL_LOG_ENTRY_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_LOG_ENTRY_ASSC.PK_PRPSL_LOG_ENTRY_ASSC Index Columns |
ColumnName | Sort Order |
PRPSL_ID | Ascending |
SUBMISS_NBR | Ascending |
LOG_ENTRY_ID | Ascending |
PRPSL_LOG_ENTRY_ASSC.PK_PRPSL_LOG_ENTRY_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_LOG_ENTRY_ASSC.PK_PRPSL_LOG_ENTRY_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_LOG_ENTRY_ASSC.PK_PRPSL_LOG_ENTRY_ASSC 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_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_SCHED.PK_PRPSL_TYPE_SCHED |
TableName | PRPSL_TYPE_SCHED |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRPSL_TYPE_SCHED.PK_PRPSL_TYPE_SCHED Index Columns |
ColumnName | Sort Order |
INSTR_ID | Ascending |
PRPSL_TYPE_ID | Ascending |
START_DTE | Ascending |
PRPSL_TYPE_SCHED.PK_PRPSL_TYPE_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 |
PRPSL_TYPE_SCHED.PK_PRPSL_TYPE_SCHED Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRPSL_TYPE_SCHED.PK_PRPSL_TYPE_SCHED Bound Attachments |
Name | Current Value |
RECENT_ACT.PK_RECENT_ACT |
TableName | RECENT_ACT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
RECENT_ACT.PK_RECENT_ACT Index Columns |
ColumnName | Sort Order |
ACT_ID | Ascending |
RECENT_ACT.PK_RECENT_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 |
RECENT_ACT.PK_RECENT_ACT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RECENT_ACT.PK_RECENT_ACT Bound Attachments |
Name | Current Value |
REGION_HIDE.PK_REGION_HIDE |
TableName | REGION_HIDE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
REGION_HIDE.PK_REGION_HIDE Index Columns |
ColumnName | Sort Order |
BN | Ascending |
REG_NM | Ascending |
REGION_HIDE.PK_REGION_HIDE 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 |
REGION_HIDE.PK_REGION_HIDE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REGION_HIDE.PK_REGION_HIDE Bound Attachments |
Name | Current Value |
RSRC_SET_TMP.PK2448 |
TableName | RSRC_SET_TMP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
RSRC_SET_TMP.PK2448 Index Columns |
ColumnName | Sort Order |
RSRC_SET_ID | Ascending |
EXPT_RSRC_ID | Ascending |
RSRC_SET_TMP.PK2448 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 |
RSRC_SET_TMP.PK2448 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RSRC_SET_TMP.PK2448 Bound Attachments |
Name | Current Value |
RSRC_WORKFLOW.PK_RSRC_WORKFLOW |
TableName | RSRC_WORKFLOW |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
RSRC_WORKFLOW.PK_RSRC_WORKFLOW Index Columns |
ColumnName | Sort Order |
WORKFLOW_ID | Ascending |
RSRC_WORKFLOW.PK_RSRC_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 |
RSRC_WORKFLOW.PK_RSRC_WORKFLOW Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
RSRC_WORKFLOW.PK_RSRC_WORKFLOW Bound Attachments |
Name | Current Value |
SAMPLE.PK_SAMPLE |
TableName | SAMPLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SAMPLE.PK_SAMPLE Index Columns |
ColumnName | Sort Order |
SMPL_ID | Ascending |
SAMPLE.PK_SAMPLE 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 |
SAMPLE.PK_SAMPLE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SAMPLE.PK_SAMPLE Bound Attachments |
Name | Current Value |
SMPL_COND.PK_SMPL_COND |
TableName | SMPL_COND |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SMPL_COND.PK_SMPL_COND Index Columns |
ColumnName | Sort Order |
SMPL_ENV_ID | Ascending |
SMPL_COND_ID | Ascending |
SMPL_COND.PK_SMPL_COND Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_TS |
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 |
SMPL_COND.PK_SMPL_COND Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SMPL_COND.PK_SMPL_COND Bound Attachments |
Name | Current Value |
UOM.PK_UOM |
TableName | UOM |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
UOM.PK_UOM Index Columns |
ColumnName | Sort Order |
UNIT_ID | Ascending |
UOM.PK_UOM Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
UOM.PK_UOM Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
UOM.PK_UOM Bound Attachments |
Name | Current Value |
UOM_COL.PK_UOM_TBL |
TableName | UOM_COL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
UOM_COL.PK_UOM_TBL Index Columns |
ColumnName | Sort Order |
COL_NM_ID | Ascending |
UOM_COL.PK_UOM_TBL Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
UOM_COL.PK_UOM_TBL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
UOM_COL.PK_UOM_TBL Bound Attachments |
Name | Current Value |
UOM_COL_ASSC.PK_UOM_TBL_ASSC |
TableName | UOM_COL_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
UOM_COL_ASSC.PK_UOM_TBL_ASSC Index Columns |
ColumnName | Sort Order |
UNIT_ID | Ascending |
COL_NM_ID | Ascending |
UOM_COL_ASSC.PK_UOM_TBL_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 |
UOM_COL_ASSC.PK_UOM_TBL_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
UOM_COL_ASSC.PK_UOM_TBL_ASSC Bound Attachments |
Name | Current Value |
USER_APPL_FILE_ASSC.PK_USER_APPL_FILE_ASSC |
TableName | USER_APPL_FILE_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
USER_APPL_FILE_ASSC.PK_USER_APPL_FILE_ASSC Index Columns |
ColumnName | Sort Order |
BN | Ascending |
APPL_FILE_ID | Ascending |
USER_APPL_FILE_ASSC.PK_USER_APPL_FILE_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 |
USER_APPL_FILE_ASSC.PK_USER_APPL_FILE_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
USER_APPL_FILE_ASSC.PK_USER_APPL_FILE_ASSC Bound Attachments |
Name | Current Value |
USER_EMAIL_TMPL_ASSC.PK_USER_EMAIL_TMPL_ASSC |
TableName | USER_EMAIL_TMPL_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
USER_EMAIL_TMPL_ASSC.PK_USER_EMAIL_TMPL_ASSC Index Columns |
ColumnName | Sort Order |
BN | Ascending |
TEMPLATE_ID | Ascending |
USER_EMAIL_TMPL_ASSC.PK_USER_EMAIL_TMPL_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 |
USER_EMAIL_TMPL_ASSC.PK_USER_EMAIL_TMPL_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
USER_EMAIL_TMPL_ASSC.PK_USER_EMAIL_TMPL_ASSC Bound Attachments |
Name | Current Value |
USER_PROF.PK_USER_PROF |
TableName | USER_PROF |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
USER_PROF.PK_USER_PROF Index Columns |
ColumnName | Sort Order |
BN | Ascending |
USER_PROF.PK_USER_PROF 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_PROF.PK_USER_PROF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
USER_PROF.PK_USER_PROF Bound Attachments |
Name | Current Value |