| AUTHOR.PK_AUTHOR |
| TableName | AUTHOR |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| AUTHOR.PK_AUTHOR Index Columns |
| ColumnName | Sort Order |
| AUTHOR_ID | Ascending |
| AUTHOR.PK_AUTHOR Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| AUTHOR.PK_AUTHOR Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| AUTHOR.PK_AUTHOR Bound Attachments |
| Name | Current Value |
| CONF.PK_CONF |
| TableName | CONF |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CONF.PK_CONF Index Columns |
| ColumnName | Sort Order |
| CONF_ID | Ascending |
| CONF.PK_CONF Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CONF.PK_CONF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CONF.PK_CONF Bound Attachments |
| Name | Current Value |
| CONF_PROCEED.PK_CONF_PROCEED |
| TableName | CONF_PROCEED |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CONF_PROCEED.PK_CONF_PROCEED Index Columns |
| ColumnName | Sort Order |
| CONF_ID | Ascending |
| PROCEED_ID | Ascending |
| CONF_PROCEED.PK_CONF_PROCEED Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| CONF_PROCEED.PK_CONF_PROCEED Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CONF_PROCEED.PK_CONF_PROCEED 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 |
| FACIL_NON_INSTR.PK_FACIL_NON_INSTR |
| TableName | FACIL_NON_INSTR |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| FACIL_NON_INSTR.PK_FACIL_NON_INSTR Index Columns |
| ColumnName | Sort Order |
| FACIL_ID | Ascending |
| NON_INSTR_ID | Ascending |
| FACIL_NON_INSTR.PK_FACIL_NON_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 |
| FACIL_NON_INSTR.PK_FACIL_NON_INSTR Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| FACIL_NON_INSTR.PK_FACIL_NON_INSTR 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 |
| EMAIL_ADDR | 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 |
| FEEDBACK_STAT.PK_FEEDBACK_STAT |
| TableName | FEEDBACK_STAT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| FEEDBACK_STAT.PK_FEEDBACK_STAT Index Columns |
| ColumnName | Sort Order |
| STAT_ID | Ascending |
| FEEDBACK_STAT.PK_FEEDBACK_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 |
| FEEDBACK_STAT.PK_FEEDBACK_STAT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| FEEDBACK_STAT.PK_FEEDBACK_STAT Bound Attachments |
| Name | Current Value |
| INST.PK_INST |
| TableName | INST |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INST.PK_INST Index Columns |
| ColumnName | Sort Order |
| INST_ID | Ascending |
| INST.PK_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 |
| INST.PK_INST Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INST.PK_INST 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_EXCL.PK_INSTR_EXCL |
| TableName | INSTR_EXCL |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_EXCL.PK_INSTR_EXCL Index Columns |
| ColumnName | Sort Order |
| INSTR_ID | Ascending |
| INSTR_EXCL.PK_INSTR_EXCL Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| 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_EXCL.PK_INSTR_EXCL Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_EXCL.PK_INSTR_EXCL Bound Attachments |
| Name | Current Value |
| JL_IMP_FACT.PK_JL_IMP_FACT |
| TableName | JL_IMP_FACT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| JL_IMP_FACT.PK_JL_IMP_FACT Index Columns |
| ColumnName | Sort Order |
| JOURNAL_ID | Ascending |
| YEAR | Ascending |
| JL_IMP_FACT.PK_JL_IMP_FACT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| JL_IMP_FACT.PK_JL_IMP_FACT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| JL_IMP_FACT.PK_JL_IMP_FACT Bound Attachments |
| Name | Current Value |
| JOURNAL.PK_JOURNAL |
| TableName | JOURNAL |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| JOURNAL.PK_JOURNAL Index Columns |
| ColumnName | Sort Order |
| JOURNAL_ID | Ascending |
| JOURNAL.PK_JOURNAL Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| JOURNAL.PK_JOURNAL Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| JOURNAL.PK_JOURNAL 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.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 |
| 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_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_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 |
| PUB_AUTHOR_ASSC.PK_PUB_AUTHOR_ASSC |
| TableName | PUB_AUTHOR_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PUB_AUTHOR_ASSC.PK_PUB_AUTHOR_ASSC Index Columns |
| ColumnName | Sort Order |
| PUBL_ID | Ascending |
| AUTHOR_ID | Ascending |
| RANK | Ascending |
| PUB_AUTHOR_ASSC.PK_PUB_AUTHOR_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PUB_AUTHOR_ASSC.PK_PUB_AUTHOR_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PUB_AUTHOR_ASSC.PK_PUB_AUTHOR_ASSC Bound Attachments |
| Name | Current Value |
| PUBL.PK_PUBL |
| 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_PUBL Index Columns |
| ColumnName | Sort Order |
| PUBL_ID | Ascending |
| PUBL.PK_PUBL Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| 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_PUBL Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PUBL.PK_PUBL Bound Attachments |
| Name | Current Value |
| PUBL_ACT.PK_PUBL_ACT |
| TableName | PUBL_ACT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PUBL_ACT.PK_PUBL_ACT Index Columns |
| ColumnName | Sort Order |
| ACT_ID | Ascending |
| PUBL_ACT.PK_PUBL_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 |
| PUBL_ACT.PK_PUBL_ACT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PUBL_ACT.PK_PUBL_ACT Bound Attachments |
| Name | Current Value |
| PUBL_FACIL_NON_INSTR_ASSC.PK_PUBL_FACIL_NON_INSTR_ASSC |
| TableName | PUBL_FACIL_NON_INSTR_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PUBL_FACIL_NON_INSTR_ASSC.PK_PUBL_FACIL_NON_INSTR_ASSC Index Columns |
| ColumnName | Sort Order |
| PUBL_ID | Ascending |
| FACIL_ID | Ascending |
| NON_INSTR_ID | Ascending |
| PUBL_FACIL_NON_INSTR_ASSC.PK_PUBL_FACIL_NON_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 |
| PUBL_FACIL_NON_INSTR_ASSC.PK_PUBL_FACIL_NON_INSTR_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PUBL_FACIL_NON_INSTR_ASSC.PK_PUBL_FACIL_NON_INSTR_ASSC Bound Attachments |
| Name | Current Value |
| PUBL_INSTR_ASSC.PK_PUBL_PRPSL_INSTR_ASSC |
| TableName | PUBL_INSTR_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PUBL_INSTR_ASSC.PK_PUBL_PRPSL_INSTR_ASSC Index Columns |
| ColumnName | Sort Order |
| PUBL_ID | Ascending |
| INSTR_ID | Ascending |
| PUBL_INSTR_ASSC.PK_PUBL_PRPSL_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 |
| PUBL_INSTR_ASSC.PK_PUBL_PRPSL_INSTR_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PUBL_INSTR_ASSC.PK_PUBL_PRPSL_INSTR_ASSC Bound Attachments |
| Name | Current Value |
| PUBL_LOG.PK_PUB_LOG |
| TableName | PUBL_LOG |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PUBL_LOG.PK_PUB_LOG Index Columns |
| ColumnName | Sort Order |
| PUBL_ID | Ascending |
| ACT_ID | Ascending |
| CUR_DTE | Ascending |
| PUBL_LOG.PK_PUB_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 |
| PUBL_LOG.PK_PUB_LOG Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PUBL_LOG.PK_PUB_LOG Bound Attachments |
| Name | Current Value |
| PUBL_PRPSL_INSTR_ASSC.PK_PUBL_PRPSL_ASSC |
| TableName | PUBL_PRPSL_INSTR_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PUBL_PRPSL_INSTR_ASSC.PK_PUBL_PRPSL_ASSC Index Columns |
| ColumnName | Sort Order |
| PUBL_ID | Ascending |
| PRPSL_ID | Ascending |
| SUBMISS_NBR | Ascending |
| INSTR_ID | Ascending |
| PUBL_PRPSL_INSTR_ASSC.PK_PUBL_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 |
| PUBL_PRPSL_INSTR_ASSC.PK_PUBL_PRPSL_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PUBL_PRPSL_INSTR_ASSC.PK_PUBL_PRPSL_ASSC Bound Attachments |
| Name | Current Value |
| PUBL_RSCH_AREA_ASSC.PK_PUBL_RSCH_AREA_ASSC |
| TableName | PUBL_RSCH_AREA_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PUBL_RSCH_AREA_ASSC.PK_PUBL_RSCH_AREA_ASSC Index Columns |
| ColumnName | Sort Order |
| PUBL_ID | Ascending |
| PRPSL_ID | Ascending |
| RSCH_AREA_ID | Ascending |
| PUBL_RSCH_AREA_ASSC.PK_PUBL_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 |
| PUBL_RSCH_AREA_ASSC.PK_PUBL_RSCH_AREA_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PUBL_RSCH_AREA_ASSC.PK_PUBL_RSCH_AREA_ASSC Bound Attachments |
| Name | Current Value |
| PUBL_SPEC_RECOG_ASSC.PK_PUBL_SPEC_RECOG_ASSC |
| TableName | PUBL_SPEC_RECOG_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PUBL_SPEC_RECOG_ASSC.PK_PUBL_SPEC_RECOG_ASSC Index Columns |
| ColumnName | Sort Order |
| PUBL_ID | Ascending |
| SPEC_RECOG_ID | Ascending |
| PUBL_SPEC_RECOG_ASSC.PK_PUBL_SPEC_RECOG_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 |
| PUBL_SPEC_RECOG_ASSC.PK_PUBL_SPEC_RECOG_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PUBL_SPEC_RECOG_ASSC.PK_PUBL_SPEC_RECOG_ASSC Bound Attachments |
| Name | Current Value |
| PUBL_STAGE.PK_PUBL_STAGE |
| TableName | PUBL_STAGE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PUBL_STAGE.PK_PUBL_STAGE Index Columns |
| ColumnName | Sort Order |
| PUBL_ID | Ascending |
| PUBL_STAGE.PK_PUBL_STAGE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| 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_STAGE.PK_PUBL_STAGE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PUBL_STAGE.PK_PUBL_STAGE Bound Attachments |
| Name | Current Value |
| PUBL_STAGE_INSTR_ASSC.PK_PUBL_STAGE_INSTR_ASSC |
| TableName | PUBL_STAGE_INSTR_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PUBL_STAGE_INSTR_ASSC.PK_PUBL_STAGE_INSTR_ASSC Index Columns |
| ColumnName | Sort Order |
| PUBL_ID | Ascending |
| INSTR_ID | Ascending |
| PUBL_STAGE_INSTR_ASSC.PK_PUBL_STAGE_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 |
| PUBL_STAGE_INSTR_ASSC.PK_PUBL_STAGE_INSTR_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PUBL_STAGE_INSTR_ASSC.PK_PUBL_STAGE_INSTR_ASSC Bound Attachments |
| Name | Current Value |
| PUBL_STAGE_NON_INSTR_ASSC.PK_PUBL_STAGE_NON_INSTR_ASSC |
| TableName | PUBL_STAGE_NON_INSTR_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PUBL_STAGE_NON_INSTR_ASSC.PK_PUBL_STAGE_NON_INSTR_ASSC Index Columns |
| ColumnName | Sort Order |
| PUBL_ID | Ascending |
| FACIL_ID | Ascending |
| NON_INSTR_ID | Ascending |
| PUBL_STAGE_NON_INSTR_ASSC.PK_PUBL_STAGE_NON_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 |
| PUBL_STAGE_NON_INSTR_ASSC.PK_PUBL_STAGE_NON_INSTR_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PUBL_STAGE_NON_INSTR_ASSC.PK_PUBL_STAGE_NON_INSTR_ASSC Bound Attachments |
| Name | Current Value |
| PUBL_STAGE_RSCH_AREA_ASSC.PK_PUBL_STAGE_RSCH_AREA_ASSC |
| TableName | PUBL_STAGE_RSCH_AREA_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PUBL_STAGE_RSCH_AREA_ASSC.PK_PUBL_STAGE_RSCH_AREA_ASSC Index Columns |
| ColumnName | Sort Order |
| PUBL_ID | Ascending |
| RSCH_AREA_ID | Ascending |
| PUBL_STAGE_RSCH_AREA_ASSC.PK_PUBL_STAGE_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 |
| PUBL_STAGE_RSCH_AREA_ASSC.PK_PUBL_STAGE_RSCH_AREA_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PUBL_STAGE_RSCH_AREA_ASSC.PK_PUBL_STAGE_RSCH_AREA_ASSC Bound Attachments |
| Name | Current Value |
| PUBL_TYPE.PK_PUBL_TYPE |
| TableName | PUBL_TYPE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PUBL_TYPE.PK_PUBL_TYPE Index Columns |
| ColumnName | Sort Order |
| PUBL_TYPE_ID | Ascending |
| PUBL_TYPE.PK_PUBL_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 |
| PUBL_TYPE.PK_PUBL_TYPE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PUBL_TYPE.PK_PUBL_TYPE 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 |
| SPEC_RECOG.PK_SPEC_RECOG |
| TableName | SPEC_RECOG |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SPEC_RECOG.PK_SPEC_RECOG Index Columns |
| ColumnName | Sort Order |
| SPEC_RECOG_ID | Ascending |
| SPEC_RECOG.PK_SPEC_RECOG Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SPEC_RECOG.PK_SPEC_RECOG Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SPEC_RECOG.PK_SPEC_RECOG Bound Attachments |
| Name | Current Value |
| STATUS.PK_STATUS |
| TableName | STATUS |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| STATUS.PK_STATUS Index Columns |
| ColumnName | Sort Order |
| STAT_ID | Ascending |
| STATUS.PK_STATUS Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| STATUS.PK_STATUS Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| STATUS.PK_STATUS Bound Attachments |
| Name | Current Value |