| BLM_ACCT.PK_BLM_ACCT |
| TableName | BLM_ACCT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BLM_ACCT.PK_BLM_ACCT Index Columns |
| ColumnName | Sort Order |
| BLM_ACCT_ID | Ascending |
| BLM_ACCT.PK_BLM_ACCT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | chan_arch_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 |
| BLM_ACCT.PK_BLM_ACCT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BLM_ACCT.PK_BLM_ACCT Bound Attachments |
| Name | Current Value |
| BLM_ACCT.FK_BLM_ACCT_PV_SGNL_ID_ASSC |
| TableName | BLM_ACCT |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX DIAG.FK_BLM_ACCT_PV_SGNL_ID_ASSC ON DIAG.BLM_ACCT(PV_ID) TABLESPACE chan_arch_ts LOGGING ; |
| BLM_ACCT.FK_BLM_ACCT_PV_SGNL_ID_ASSC Index Columns |
| ColumnName | Sort Order |
| PV_ID | Ascending |
| BLM_ACCT.FK_BLM_ACCT_PV_SGNL_ID_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | chan_arch_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 |
| BLM_ACCT.FK_BLM_ACCT_PV_SGNL_ID_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BLM_ACCT.FK_BLM_ACCT_PV_SGNL_ID_ASSC Bound Attachments |
| Name | Current Value |
| BLM_ACCT.FK_BLM_ACCT_INTEG_TYPE |
| TableName | BLM_ACCT |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX DIAG.FK_BLM_ACCT_INTEG_TYPE ON DIAG.BLM_ACCT(INTEG_TYPE_ID) TABLESPACE chan_arch_ts LOGGING ; |
| BLM_ACCT.FK_BLM_ACCT_INTEG_TYPE Index Columns |
| ColumnName | Sort Order |
| INTEG_TYPE_ID | Ascending |
| BLM_ACCT.FK_BLM_ACCT_INTEG_TYPE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | chan_arch_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 |
| BLM_ACCT.FK_BLM_ACCT_INTEG_TYPE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BLM_ACCT.FK_BLM_ACCT_INTEG_TYPE Bound Attachments |
| Name | Current Value |
| INTEG_TYPE.PK_INTEG_TYPE |
| TableName | INTEG_TYPE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INTEG_TYPE.PK_INTEG_TYPE Index Columns |
| ColumnName | Sort Order |
| INTEG_TYPE_ID | Ascending |
| INTEG_TYPE.PK_INTEG_TYPE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | chan_arch_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 |
| INTEG_TYPE.PK_INTEG_TYPE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INTEG_TYPE.PK_INTEG_TYPE Bound Attachments |
| Name | Current Value |
| PV_SGNL_ID_ASSC.PK_PV_SGNL_ID_ASSC |
| TableName | PV_SGNL_ID_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PV_SGNL_ID_ASSC.PK_PV_SGNL_ID_ASSC Index Columns |
| ColumnName | Sort Order |
| PV_ID | Ascending |
| PV_SGNL_ID_ASSC.PK_PV_SGNL_ID_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | chan_arch_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 |
| PV_SGNL_ID_ASSC.PK_PV_SGNL_ID_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PV_SGNL_ID_ASSC.PK_PV_SGNL_ID_ASSC Bound Attachments |
| Name | Current Value |
| PV_SGNL_ID_ASSC.FK_PV_SGN_ID_ASSC_SGNL_REC |
| TableName | PV_SGNL_ID_ASSC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX DIAG.FK_PV_SGN_ID_ASSC_SGNL_REC ON DIAG.PV_SGNL_ID_ASSC(SGNL_ID) TABLESPACE chan_arch_ts LOGGING ; |
| PV_SGNL_ID_ASSC.FK_PV_SGN_ID_ASSC_SGNL_REC Index Columns |
| ColumnName | Sort Order |
| SGNL_ID | Ascending |
| PV_SGNL_ID_ASSC.FK_PV_SGN_ID_ASSC_SGNL_REC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | chan_arch_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 |
| PV_SGNL_ID_ASSC.FK_PV_SGN_ID_ASSC_SGNL_REC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PV_SGNL_ID_ASSC.FK_PV_SGN_ID_ASSC_SGNL_REC Bound Attachments |
| Name | Current Value |
| SGNL_REC.SGNL_REC_PK |
| TableName | SGNL_REC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SGNL_REC.SGNL_REC_PK Index Columns |
| ColumnName | Sort Order |
| SGNL_ID | Ascending |
| SGNL_REC.SGNL_REC_PK Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | chan_arch_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 |
| SGNL_REC.SGNL_REC_PK Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SGNL_REC.SGNL_REC_PK Bound Attachments |
| Name | Current Value |
| SGNL_REC.SGNL_ID_ALIAS_IDX |
| TableName | SGNL_REC |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE UNIQUE INDEX SGNL_ID_ALIAS_IDX ON SGNL_REC(SGNL_ID_ALIAS) TABLESPACE chan_arch_ts LOGGING ; |
| SGNL_REC.SGNL_ID_ALIAS_IDX Index Columns |
| ColumnName | Sort Order |
| SGNL_ID_ALIAS | Ascending |
| SGNL_REC.SGNL_ID_ALIAS_IDX Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | chan_arch_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 |
| SGNL_REC.SGNL_ID_ALIAS_IDX Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SGNL_REC.SGNL_ID_ALIAS_IDX Bound Attachments |
| Name | Current Value |