SCI_HIGH.PK_SCI_HIGH |
TableName | SCI_HIGH |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SCI_HIGH.PK_SCI_HIGH Index Columns |
ColumnName | Sort Order |
SCI_HIGH_ID | Ascending |
SCI_HIGH.PK_SCI_HIGH Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
SCI_HIGH.PK_SCI_HIGH Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SCI_HIGH.PK_SCI_HIGH Bound Attachments |
Name | Current Value |
SCI_HIGH.fk_sci_high_to_sci_high_cat |
TableName | SCI_HIGH |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX XF_ADMIN.fk_sci_high_to_sci_high_cat ON XF_ADMIN.SCI_HIGH(SCI_HIGH_CAT_ID)      LOGGING ; |
SCI_HIGH.fk_sci_high_to_sci_high_cat Index Columns |
ColumnName | Sort Order |
SCI_HIGH_CAT_ID | Ascending |
SCI_HIGH.fk_sci_high_to_sci_high_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 |
SCI_HIGH.fk_sci_high_to_sci_high_cat Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SCI_HIGH.fk_sci_high_to_sci_high_cat Bound Attachments |
Name | Current Value |
SCI_HIGH_CAT.PK_SCI_HIGH_CAT |
TableName | SCI_HIGH_CAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SCI_HIGH_CAT.PK_SCI_HIGH_CAT Index Columns |
ColumnName | Sort Order |
SCI_HIGH_CAT_ID | Ascending |
SCI_HIGH_CAT.PK_SCI_HIGH_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 |
SCI_HIGH_CAT.PK_SCI_HIGH_CAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SCI_HIGH_CAT.PK_SCI_HIGH_CAT Bound Attachments |
Name | Current Value |
SCI_HIGH_FACIL_ASSC.PK_SCI_HIGH_FACIL_ASSC |
TableName | SCI_HIGH_FACIL_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SCI_HIGH_FACIL_ASSC.PK_SCI_HIGH_FACIL_ASSC Index Columns |
ColumnName | Sort Order |
SCI_HIGH_ID | Ascending |
SCI_HIGH_FACIL_ASSC.PK_SCI_HIGH_FACIL_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 |
SCI_HIGH_FACIL_ASSC.PK_SCI_HIGH_FACIL_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SCI_HIGH_FACIL_ASSC.PK_SCI_HIGH_FACIL_ASSC Bound Attachments |
Name | Current Value |
SCI_HIGH_FACIL_ASSC.fk_shfa_to_sci_high |
TableName | SCI_HIGH_FACIL_ASSC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX XF_ADMIN.fk_shfa_to_sci_high ON XF_ADMIN.SCI_HIGH_FACIL_ASSC(SCI_HIGH_ID)      LOGGING ; |
SCI_HIGH_FACIL_ASSC.fk_shfa_to_sci_high Index Columns |
ColumnName | Sort Order |
SCI_HIGH_ID | Ascending |
SCI_HIGH_FACIL_ASSC.fk_shfa_to_sci_high Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
SCI_HIGH_FACIL_ASSC.fk_shfa_to_sci_high Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SCI_HIGH_FACIL_ASSC.fk_shfa_to_sci_high Bound Attachments |
Name | Current Value |
SCI_HIGH_INSTR_ASSC.PK_SCI_HIGH_INSTR_ASSC |
TableName | SCI_HIGH_INSTR_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SCI_HIGH_INSTR_ASSC.PK_SCI_HIGH_INSTR_ASSC Index Columns |
ColumnName | Sort Order |
SCI_HIGH_ID | Ascending |
SCI_HIGH_INSTR_ASSC.PK_SCI_HIGH_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 |
SCI_HIGH_INSTR_ASSC.PK_SCI_HIGH_INSTR_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SCI_HIGH_INSTR_ASSC.PK_SCI_HIGH_INSTR_ASSC Bound Attachments |
Name | Current Value |
SCI_HIGH_INSTR_ASSC.fk_shia_to_sci_high |
TableName | SCI_HIGH_INSTR_ASSC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX XF_ADMIN.fk_shia_to_sci_high ON XF_ADMIN.SCI_HIGH_INSTR_ASSC(SCI_HIGH_ID)      LOGGING ; |
SCI_HIGH_INSTR_ASSC.fk_shia_to_sci_high Index Columns |
ColumnName | Sort Order |
SCI_HIGH_ID | Ascending |
SCI_HIGH_INSTR_ASSC.fk_shia_to_sci_high Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
SCI_HIGH_INSTR_ASSC.fk_shia_to_sci_high Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SCI_HIGH_INSTR_ASSC.fk_shia_to_sci_high Bound Attachments |
Name | Current Value |
SCI_HIGH_PI_ASSC.PK_SCI_HIGH_PI_ASSC |
TableName | SCI_HIGH_PI_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SCI_HIGH_PI_ASSC.PK_SCI_HIGH_PI_ASSC Index Columns |
ColumnName | Sort Order |
SCI_HIGH_ID | Ascending |
SCI_HIGH_PI_ASSC.PK_SCI_HIGH_PI_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 |
SCI_HIGH_PI_ASSC.PK_SCI_HIGH_PI_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SCI_HIGH_PI_ASSC.PK_SCI_HIGH_PI_ASSC Bound Attachments |
Name | Current Value |
SCI_HIGH_PI_ASSC.fk_shpi_to_person |
TableName | SCI_HIGH_PI_ASSC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX XF_ADMIN.fk_shpi_to_person ON XF_ADMIN.SCI_HIGH_PI_ASSC(SCI_HIGH_ID)      LOGGING ; |
SCI_HIGH_PI_ASSC.fk_shpi_to_person Index Columns |
ColumnName | Sort Order |
SCI_HIGH_ID | Ascending |
SCI_HIGH_PI_ASSC.fk_shpi_to_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 |
SCI_HIGH_PI_ASSC.fk_shpi_to_person Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SCI_HIGH_PI_ASSC.fk_shpi_to_person Bound Attachments |
Name | Current Value |
SCI_JOUR.PK_SCI_JOUR |
TableName | SCI_JOUR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SCI_JOUR.PK_SCI_JOUR Index Columns |
ColumnName | Sort Order |
JOUR_ID | Ascending |
SCI_JOUR.PK_SCI_JOUR Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
SCI_JOUR.PK_SCI_JOUR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SCI_JOUR.PK_SCI_JOUR Bound Attachments |
Name | Current Value |
SCI_JOUR_HIGH_ASSC.PK_SCI_JOUR_HIGH_ASSC |
TableName | SCI_JOUR_HIGH_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SCI_JOUR_HIGH_ASSC.PK_SCI_JOUR_HIGH_ASSC Index Columns |
ColumnName | Sort Order |
JOUR_ID | Ascending |
SCI_HIGH_ID | Ascending |
SCI_JOUR_HIGH_ASSC.PK_SCI_JOUR_HIGH_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 |
SCI_JOUR_HIGH_ASSC.PK_SCI_JOUR_HIGH_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SCI_JOUR_HIGH_ASSC.PK_SCI_JOUR_HIGH_ASSC Bound Attachments |
Name | Current Value |
SCI_JOUR_HIGH_ASSC.fk_sjha_to_sci_jour |
TableName | SCI_JOUR_HIGH_ASSC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX XF_ADMIN.fk_sjha_to_sci_jour ON XF_ADMIN.SCI_JOUR_HIGH_ASSC(JOUR_ID)      LOGGING ; |
SCI_JOUR_HIGH_ASSC.fk_sjha_to_sci_jour Index Columns |
ColumnName | Sort Order |
JOUR_ID | Ascending |
SCI_JOUR_HIGH_ASSC.fk_sjha_to_sci_jour Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
SCI_JOUR_HIGH_ASSC.fk_sjha_to_sci_jour Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SCI_JOUR_HIGH_ASSC.fk_sjha_to_sci_jour Bound Attachments |
Name | Current Value |
SCI_JOUR_HIGH_ASSC.fk_sjha_to_sci_high |
TableName | SCI_JOUR_HIGH_ASSC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX XF_ADMIN.fk_sjha_to_sci_high ON XF_ADMIN.SCI_JOUR_HIGH_ASSC(SCI_HIGH_ID)      LOGGING ; |
SCI_JOUR_HIGH_ASSC.fk_sjha_to_sci_high Index Columns |
ColumnName | Sort Order |
SCI_HIGH_ID | Ascending |
SCI_JOUR_HIGH_ASSC.fk_sjha_to_sci_high Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
SCI_JOUR_HIGH_ASSC.fk_sjha_to_sci_high Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SCI_JOUR_HIGH_ASSC.fk_sjha_to_sci_high Bound Attachments |
Name | Current Value |