| DIALOG.PK_DIALOG |
| TableName | DIALOG |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DIALOG.PK_DIALOG Index Columns |
| ColumnName | Sort Order |
| DIALOG_ID | Ascending |
| DIALOG.PK_DIALOG Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| DIALOG.PK_DIALOG Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DIALOG.PK_DIALOG Bound Attachments |
| Name | Current Value |
| DIALOG_PART_ASSC.PK_DIALOG_PART_ASSC |
| TableName | DIALOG_PART_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DIALOG_PART_ASSC.PK_DIALOG_PART_ASSC Index Columns |
| ColumnName | Sort Order |
| DIALOG_ID | Ascending |
| PART_ID | Ascending |
| DIALOG_PART_ASSC.PK_DIALOG_PART_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 |
| DIALOG_PART_ASSC.PK_DIALOG_PART_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DIALOG_PART_ASSC.PK_DIALOG_PART_ASSC Bound Attachments |
| Name | Current Value |
| DIALOG_TYPE.PK_DIALOG_TYPE |
| TableName | DIALOG_TYPE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| DIALOG_TYPE.PK_DIALOG_TYPE Index Columns |
| ColumnName | Sort Order |
| DIALOG_TYPE_ID | Ascending |
| DIALOG_TYPE.PK_DIALOG_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 |
| DIALOG_TYPE.PK_DIALOG_TYPE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| DIALOG_TYPE.PK_DIALOG_TYPE Bound Attachments |
| Name | Current Value |
| EMPLOYEE.PK_EMPLOYEE |
| TableName | EMPLOYEE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EMPLOYEE.PK_EMPLOYEE Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| EMPLOYEE.PK_EMPLOYEE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EMPLOYEE.PK_EMPLOYEE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMPLOYEE.PK_EMPLOYEE Bound Attachments |
| Name | Current Value |
| ET_ACT.PK_ET_ACT |
| TableName | ET_ACT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ET_ACT.PK_ET_ACT Index Columns |
| ColumnName | Sort Order |
| ACT_ID | Ascending |
| ET_ACT.PK_ET_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 |
| ET_ACT.PK_ET_ACT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ET_ACT.PK_ET_ACT Bound Attachments |
| Name | Current Value |
| ET_LOG.PK_ET_LOG |
| TableName | ET_LOG |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ET_LOG.PK_ET_LOG Index Columns |
| ColumnName | Sort Order |
| ACT_ID | Ascending |
| ET_LOG.PK_ET_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 |
| ET_LOG.PK_ET_LOG Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ET_LOG.PK_ET_LOG Bound Attachments |
| Name | Current Value |
| EVENT.PK_EVENT |
| TableName | EVENT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EVENT.PK_EVENT Index Columns |
| ColumnName | Sort Order |
| EVENT_ID | Ascending |
| EVENT.PK_EVENT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EVENT.PK_EVENT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EVENT.PK_EVENT Bound Attachments |
| Name | Current Value |
| EVENT_PART_ASSC.PK_EVENT_PART_ASSC |
| TableName | EVENT_PART_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EVENT_PART_ASSC.PK_EVENT_PART_ASSC Index Columns |
| ColumnName | Sort Order |
| EVENT_ID | Ascending |
| PART_ID | Ascending |
| EVENT_PART_ASSC.PK_EVENT_PART_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 |
| EVENT_PART_ASSC.PK_EVENT_PART_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EVENT_PART_ASSC.PK_EVENT_PART_ASSC Bound Attachments |
| Name | Current Value |
| EVENT_TYPE.PK_EVENT_TYPE |
| TableName | EVENT_TYPE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EVENT_TYPE.PK_EVENT_TYPE Index Columns |
| ColumnName | Sort Order |
| EVENT_TYPE_ID | Ascending |
| EVENT_TYPE.PK_EVENT_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 |
| EVENT_TYPE.PK_EVENT_TYPE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EVENT_TYPE.PK_EVENT_TYPE 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 |
| INST_NM_ALIAS.PK_INST_NM_ALIAS |
| TableName | INST_NM_ALIAS |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INST_NM_ALIAS.PK_INST_NM_ALIAS Index Columns |
| ColumnName | Sort Order |
| INST_ID | Ascending |
| INST_NM_ALIAS.PK_INST_NM_ALIAS Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| 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_NM_ALIAS.PK_INST_NM_ALIAS Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INST_NM_ALIAS.PK_INST_NM_ALIAS Bound Attachments |
| Name | Current Value |
| INST_ROLE.PK_ROLE |
| TableName | INST_ROLE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INST_ROLE.PK_ROLE Index Columns |
| ColumnName | Sort Order |
| ROLE_ID | Ascending |
| INST_ROLE.PK_ROLE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| INST_ROLE.PK_ROLE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INST_ROLE.PK_ROLE Bound Attachments |
| Name | Current Value |
| PART_INST_ASSC.PK_PART_INST_ASSC |
| TableName | PART_INST_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PART_INST_ASSC.PK_PART_INST_ASSC Index Columns |
| ColumnName | Sort Order |
| PART_ID | Ascending |
| INST_ID | Ascending |
| START_DTE | Ascending |
| PART_INST_ASSC.PK_PART_INST_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 |
| PART_INST_ASSC.PK_PART_INST_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PART_INST_ASSC.PK_PART_INST_ASSC Bound Attachments |
| Name | Current Value |
| PART_TYPE.PK_PART_TYPE |
| TableName | PART_TYPE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PART_TYPE.PK_PART_TYPE Index Columns |
| ColumnName | Sort Order |
| PART_TYPE_ID | Ascending |
| PART_TYPE.PK_PART_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 |
| PART_TYPE.PK_PART_TYPE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PART_TYPE.PK_PART_TYPE Bound Attachments |
| Name | Current Value |
| PARTICIPANT.PK_PARTICIPANT |
| TableName | PARTICIPANT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PARTICIPANT.PK_PARTICIPANT Index Columns |
| ColumnName | Sort Order |
| PART_ID | Ascending |
| PARTICIPANT.PK_PARTICIPANT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PARTICIPANT.PK_PARTICIPANT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PARTICIPANT.PK_PARTICIPANT 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 |