EMP_STOR_LOC_ASSC.PK_EMP_STOR_LOC_ASSC |
TableName | EMP_STOR_LOC_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
EMP_STOR_LOC_ASSC.PK_EMP_STOR_LOC_ASSC Index Columns |
ColumnName | Sort Order |
STOR_ID | Ascending |
BN | Ascending |
EMP_STOR_LOC_ASSC.PK_EMP_STOR_LOC_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 |
EMP_STOR_LOC_ASSC.PK_EMP_STOR_LOC_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EMP_STOR_LOC_ASSC.PK_EMP_STOR_LOC_ASSC Bound Attachments |
Name | Current Value |
INVT_CTRL_ACT.PK_INVT_CTRL_ACT |
TableName | INVT_CTRL_ACT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVT_CTRL_ACT.PK_INVT_CTRL_ACT Index Columns |
ColumnName | Sort Order |
ACT_ID | Ascending |
INVT_CTRL_ACT.PK_INVT_CTRL_ACT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_ACT.PK_INVT_CTRL_ACT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_ACT.PK_INVT_CTRL_ACT Bound Attachments |
Name | Current Value |
INVT_CTRL_AREA.PK_INVT_CTRL_AREA |
TableName | INVT_CTRL_AREA |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVT_CTRL_AREA.PK_INVT_CTRL_AREA Index Columns |
ColumnName | Sort Order |
CTRL_AREA_ID | Ascending |
INVT_CTRL_AREA.PK_INVT_CTRL_AREA Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_AREA.PK_INVT_CTRL_AREA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_AREA.PK_INVT_CTRL_AREA Bound Attachments |
Name | Current Value |
INVT_CTRL_AREA.fk_invt_ctrl_area_to_stor_loc |
TableName | INVT_CTRL_AREA |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX INVT.fk_invt_ctrl_area_to_stor_loc ON INVT.INVT_CTRL_AREA(STOR_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE INVT_TS      LOGGING      STORAGE(INITIAL 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
INVT_CTRL_AREA.fk_invt_ctrl_area_to_stor_loc Index Columns |
ColumnName | Sort Order |
STOR_ID | Ascending |
INVT_CTRL_AREA.fk_invt_ctrl_area_to_stor_loc Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_AREA.fk_invt_ctrl_area_to_stor_loc Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_AREA.fk_invt_ctrl_area_to_stor_loc Bound Attachments |
Name | Current Value |
INVT_CTRL_AREA.fk_invt_ctrl_area_to_nssd_room |
TableName | INVT_CTRL_AREA |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX INVT.fk_invt_ctrl_area_to_nssd_room ON INVT.INVT_CTRL_AREA(BUILDING, ROOM)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE INVT_TS      LOGGING      STORAGE(INITIAL 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
INVT_CTRL_AREA.fk_invt_ctrl_area_to_nssd_room Index Columns |
ColumnName | Sort Order |
BUILDING | Ascending |
ROOM | Ascending |
INVT_CTRL_AREA.fk_invt_ctrl_area_to_nssd_room Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_AREA.fk_invt_ctrl_area_to_nssd_room Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_AREA.fk_invt_ctrl_area_to_nssd_room Bound Attachments |
Name | Current Value |
INVT_CTRL_AREA_SUBAREA.PK_CTRL_AREA_SUBAREA |
TableName | INVT_CTRL_AREA_SUBAREA |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVT_CTRL_AREA_SUBAREA.PK_CTRL_AREA_SUBAREA Index Columns |
ColumnName | Sort Order |
CTRL_AREA_ID | Ascending |
SUBAREA_ID | Ascending |
INVT_CTRL_AREA_SUBAREA.PK_CTRL_AREA_SUBAREA Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_AREA_SUBAREA.PK_CTRL_AREA_SUBAREA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_AREA_SUBAREA.PK_CTRL_AREA_SUBAREA Bound Attachments |
Name | Current Value |
INVT_CTRL_AREA_SUBAREA.fk_icas_to_ctrl_area |
TableName | INVT_CTRL_AREA_SUBAREA |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX INVT.fk_icas_to_ctrl_area ON INVT.INVT_CTRL_AREA_SUBAREA(CTRL_AREA_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE INVT_TS      LOGGING      STORAGE(INITIAL 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
INVT_CTRL_AREA_SUBAREA.fk_icas_to_ctrl_area Index Columns |
ColumnName | Sort Order |
CTRL_AREA_ID | Ascending |
INVT_CTRL_AREA_SUBAREA.fk_icas_to_ctrl_area Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_AREA_SUBAREA.fk_icas_to_ctrl_area Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_AREA_SUBAREA.fk_icas_to_ctrl_area Bound Attachments |
Name | Current Value |
INVT_CTRL_GRP.PK_INVT_CTRL_GRP |
TableName | INVT_CTRL_GRP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVT_CTRL_GRP.PK_INVT_CTRL_GRP Index Columns |
ColumnName | Sort Order |
GRP_ID | Ascending |
INVT_CTRL_GRP.PK_INVT_CTRL_GRP Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_GRP.PK_INVT_CTRL_GRP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_GRP.PK_INVT_CTRL_GRP Bound Attachments |
Name | Current Value |
INVT_CTRL_INFOR_ITEM.PK_INVT_CTRL_INFOR_ITEM |
TableName | INVT_CTRL_INFOR_ITEM |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVT_CTRL_INFOR_ITEM.PK_INVT_CTRL_INFOR_ITEM Index Columns |
ColumnName | Sort Order |
ITEM_ID | Ascending |
INVT_CTRL_INFOR_ITEM.PK_INVT_CTRL_INFOR_ITEM Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_INFOR_ITEM.PK_INVT_CTRL_INFOR_ITEM Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_INFOR_ITEM.PK_INVT_CTRL_INFOR_ITEM Bound Attachments |
Name | Current Value |
INVT_CTRL_ITEM.PK_INVT_CTRL_ITEM |
TableName | INVT_CTRL_ITEM |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVT_CTRL_ITEM.PK_INVT_CTRL_ITEM Index Columns |
ColumnName | Sort Order |
ITEM_ID | Ascending |
INVT_CTRL_ITEM.PK_INVT_CTRL_ITEM Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_ITEM.PK_INVT_CTRL_ITEM Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_ITEM.PK_INVT_CTRL_ITEM Bound Attachments |
Name | Current Value |
INVT_CTRL_ITEM.fk_ici_to_invt_ctrl_item |
TableName | INVT_CTRL_ITEM |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX INVT.fk_ici_to_invt_ctrl_item ON INVT.INVT_CTRL_ITEM(PARENT_ITEM_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE INVT_TS      LOGGING      STORAGE(INITIAL 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
INVT_CTRL_ITEM.fk_ici_to_invt_ctrl_item Index Columns |
ColumnName | Sort Order |
PARENT_ITEM_ID | Ascending |
INVT_CTRL_ITEM.fk_ici_to_invt_ctrl_item Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_ITEM.fk_ici_to_invt_ctrl_item Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_ITEM.fk_ici_to_invt_ctrl_item Bound Attachments |
Name | Current Value |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_type |
TableName | INVT_CTRL_ITEM |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX INVT.fk_invt_ctrl_item_to_type ON INVT.INVT_CTRL_ITEM(INVT_TYPE_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE INVT_TS      LOGGING      STORAGE(INITIAL 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_type Index Columns |
ColumnName | Sort Order |
INVT_TYPE_ID | Ascending |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_type Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_type Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_type Bound Attachments |
Name | Current Value |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_status |
TableName | INVT_CTRL_ITEM |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX INVT.fk_invt_ctrl_item_to_status ON INVT.INVT_CTRL_ITEM(STAT_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE INVT_TS      LOGGING      STORAGE(INITIAL 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_status Index Columns |
ColumnName | Sort Order |
STAT_ID | Ascending |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_status Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_status Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_status Bound Attachments |
Name | Current Value |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_icas |
TableName | INVT_CTRL_ITEM |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX INVT.fk_invt_ctrl_item_to_icas ON INVT.INVT_CTRL_ITEM(CTRL_AREA_ID, SUBAREA_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE INVT_TS      LOGGING      STORAGE(INITIAL 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_icas Index Columns |
ColumnName | Sort Order |
CTRL_AREA_ID | Ascending |
SUBAREA_ID | Ascending |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_icas Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_icas Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_icas Bound Attachments |
Name | Current Value |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_ica |
TableName | INVT_CTRL_ITEM |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX INVT.fk_invt_ctrl_item_to_ica ON INVT.INVT_CTRL_ITEM(CTRL_AREA_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE INVT_TS      LOGGING      STORAGE(INITIAL 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_ica Index Columns |
ColumnName | Sort Order |
CTRL_AREA_ID | Ascending |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_ica Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_ica Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_ica Bound Attachments |
Name | Current Value |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_icg |
TableName | INVT_CTRL_ITEM |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX INVT.fk_invt_ctrl_item_to_icg ON INVT.INVT_CTRL_ITEM(GRP_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE INVT_TS      LOGGING      STORAGE(INITIAL 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_icg Index Columns |
ColumnName | Sort Order |
GRP_ID | Ascending |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_icg Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_icg Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_ITEM.fk_invt_ctrl_item_to_icg Bound Attachments |
Name | Current Value |
INVT_CTRL_ITEM_VERIF.PK_INVT_CTRL_ITEM_VERIF |
TableName | INVT_CTRL_ITEM_VERIF |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVT_CTRL_ITEM_VERIF.PK_INVT_CTRL_ITEM_VERIF Index Columns |
ColumnName | Sort Order |
ITEM_ID | Ascending |
CREAT_DTE | Ascending |
INVT_CTRL_ITEM_VERIF.PK_INVT_CTRL_ITEM_VERIF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_ITEM_VERIF.PK_INVT_CTRL_ITEM_VERIF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_ITEM_VERIF.PK_INVT_CTRL_ITEM_VERIF Bound Attachments |
Name | Current Value |
INVT_CTRL_ITEM_VERIF.fk_invt_ctrl_item_verf_to_ici |
TableName | INVT_CTRL_ITEM_VERIF |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX INVT.fk_invt_ctrl_item_verf_to_ici ON INVT.INVT_CTRL_ITEM_VERIF(ITEM_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE INVT_TS      LOGGING      STORAGE(INITIAL 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
INVT_CTRL_ITEM_VERIF.fk_invt_ctrl_item_verf_to_ici Index Columns |
ColumnName | Sort Order |
ITEM_ID | Ascending |
INVT_CTRL_ITEM_VERIF.fk_invt_ctrl_item_verf_to_ici Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_ITEM_VERIF.fk_invt_ctrl_item_verf_to_ici Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_ITEM_VERIF.fk_invt_ctrl_item_verf_to_ici Bound Attachments |
Name | Current Value |
INVT_CTRL_ITEM_VERIF.fk_invt_ctrl_item_verf_to_emp |
TableName | INVT_CTRL_ITEM_VERIF |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX INVT.fk_invt_ctrl_item_verf_to_emp ON INVT.INVT_CTRL_ITEM_VERIF(BN)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE INVT_TS      LOGGING      STORAGE(INITIAL 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
INVT_CTRL_ITEM_VERIF.fk_invt_ctrl_item_verf_to_emp Index Columns |
ColumnName | Sort Order |
BN | Ascending |
INVT_CTRL_ITEM_VERIF.fk_invt_ctrl_item_verf_to_emp Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_ITEM_VERIF.fk_invt_ctrl_item_verf_to_emp Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_ITEM_VERIF.fk_invt_ctrl_item_verf_to_emp Bound Attachments |
Name | Current Value |
INVT_CTRL_LOG.PK_INVT_CTRL_LOG |
TableName | INVT_CTRL_LOG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVT_CTRL_LOG.PK_INVT_CTRL_LOG Index Columns |
ColumnName | Sort Order |
ITEM_ID | Ascending |
ACT_ID | Ascending |
CUR_DTE | Ascending |
INVT_CTRL_LOG.PK_INVT_CTRL_LOG Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_LOG.PK_INVT_CTRL_LOG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_LOG.PK_INVT_CTRL_LOG Bound Attachments |
Name | Current Value |
INVT_CTRL_LOG.FK_SMPL_LOG_TO_INCT_CTRL_ACT |
TableName | INVT_CTRL_LOG |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX INVT.FK_SMPL_LOG_TO_INCT_CTRL_ACT ON INVT.INVT_CTRL_LOG(ACT_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE INVT_TS      LOGGING      STORAGE(INITIAL 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
INVT_CTRL_LOG.FK_SMPL_LOG_TO_INCT_CTRL_ACT Index Columns |
ColumnName | Sort Order |
ACT_ID | Ascending |
INVT_CTRL_LOG.FK_SMPL_LOG_TO_INCT_CTRL_ACT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | DEFAULT |
Index Compression | NO |
INVT_CTRL_LOG.FK_SMPL_LOG_TO_INCT_CTRL_ACT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_LOG.FK_SMPL_LOG_TO_INCT_CTRL_ACT Bound Attachments |
Name | Current Value |
INVT_CTRL_LOG.FK_SMPL_LOG_TO_INVT_CTRL_ITEM |
TableName | INVT_CTRL_LOG |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX INVT.FK_SMPL_LOG_TO_INVT_CTRL_ITEM ON INVT.INVT_CTRL_LOG(ITEM_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE INVT_TS      LOGGING      STORAGE(INITIAL 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
INVT_CTRL_LOG.FK_SMPL_LOG_TO_INVT_CTRL_ITEM Index Columns |
ColumnName | Sort Order |
ITEM_ID | Ascending |
INVT_CTRL_LOG.FK_SMPL_LOG_TO_INVT_CTRL_ITEM Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | DEFAULT |
Index Compression | NO |
INVT_CTRL_LOG.FK_SMPL_LOG_TO_INVT_CTRL_ITEM Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_LOG.FK_SMPL_LOG_TO_INVT_CTRL_ITEM Bound Attachments |
Name | Current Value |
INVT_CTRL_ROLE.PK_INVT_CTRL_ROLE |
TableName | INVT_CTRL_ROLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVT_CTRL_ROLE.PK_INVT_CTRL_ROLE Index Columns |
ColumnName | Sort Order |
ROLE_ID | Ascending |
INVT_CTRL_ROLE.PK_INVT_CTRL_ROLE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_ROLE.PK_INVT_CTRL_ROLE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_ROLE.PK_INVT_CTRL_ROLE Bound Attachments |
Name | Current Value |
INVT_CTRL_ROLE_ASSC.PK_INVT_CTRL_ROLE_ASSC |
TableName | INVT_CTRL_ROLE_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVT_CTRL_ROLE_ASSC.PK_INVT_CTRL_ROLE_ASSC Index Columns |
ColumnName | Sort Order |
ROLE_ID | Ascending |
Bn | Ascending |
INVT_CTRL_ROLE_ASSC.PK_INVT_CTRL_ROLE_ASSC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_ROLE_ASSC.PK_INVT_CTRL_ROLE_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_ROLE_ASSC.PK_INVT_CTRL_ROLE_ASSC Bound Attachments |
Name | Current Value |
INVT_CTRL_ROLE_ASSC.fk_invt_ctrl_role_assc_to_icr |
TableName | INVT_CTRL_ROLE_ASSC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX INVT.fk_invt_ctrl_role_assc_to_icr ON INVT.INVT_CTRL_ROLE_ASSC(ROLE_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE INVT_TS      LOGGING      STORAGE(INITIAL 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
INVT_CTRL_ROLE_ASSC.fk_invt_ctrl_role_assc_to_icr Index Columns |
ColumnName | Sort Order |
ROLE_ID | Ascending |
INVT_CTRL_ROLE_ASSC.fk_invt_ctrl_role_assc_to_icr Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_ROLE_ASSC.fk_invt_ctrl_role_assc_to_icr Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_ROLE_ASSC.fk_invt_ctrl_role_assc_to_icr Bound Attachments |
Name | Current Value |
INVT_CTRL_STAT.PK_INVT_CTRL_STAT |
TableName | INVT_CTRL_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVT_CTRL_STAT.PK_INVT_CTRL_STAT Index Columns |
ColumnName | Sort Order |
STAT_ID | Ascending |
INVT_CTRL_STAT.PK_INVT_CTRL_STAT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_STAT.PK_INVT_CTRL_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_STAT.PK_INVT_CTRL_STAT Bound Attachments |
Name | Current Value |
INVT_CTRL_TRANS.PK_INVT_CTRL_TRANS |
TableName | INVT_CTRL_TRANS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVT_CTRL_TRANS.PK_INVT_CTRL_TRANS Index Columns |
ColumnName | Sort Order |
ITEM_ID | Ascending |
CUR_DTE | Ascending |
TO_BN | Ascending |
INVT_CTRL_TRANS.PK_INVT_CTRL_TRANS 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 |
INVT_CTRL_TRANS.PK_INVT_CTRL_TRANS Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_TRANS.PK_INVT_CTRL_TRANS Bound Attachments |
Name | Current Value |
INVT_CTRL_TYPE.PK_INVT_CTRL_TYPE |
TableName | INVT_CTRL_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVT_CTRL_TYPE.PK_INVT_CTRL_TYPE Index Columns |
ColumnName | Sort Order |
INVT_TYPE_ID | Ascending |
INVT_CTRL_TYPE.PK_INVT_CTRL_TYPE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_CTRL_TYPE.PK_INVT_CTRL_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_CTRL_TYPE.PK_INVT_CTRL_TYPE Bound Attachments |
Name | Current Value |
INVT_ITEM_ATTACH.PK_INVT_ITEM_ATTACH |
TableName | INVT_ITEM_ATTACH |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVT_ITEM_ATTACH.PK_INVT_ITEM_ATTACH Index Columns |
ColumnName | Sort Order |
ATTACH_ID | Ascending |
INVT_ITEM_ATTACH.PK_INVT_ITEM_ATTACH Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_ITEM_ATTACH.PK_INVT_ITEM_ATTACH Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_ITEM_ATTACH.PK_INVT_ITEM_ATTACH Bound Attachments |
Name | Current Value |
INVT_ITEM_ATTACH_ASSC.PK_INVT_ITEM_ATTACH_ASSC |
TableName | INVT_ITEM_ATTACH_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INVT_ITEM_ATTACH_ASSC.PK_INVT_ITEM_ATTACH_ASSC Index Columns |
ColumnName | Sort Order |
ITEM_ID | Ascending |
ATTACH_ID | Ascending |
INVT_ITEM_ATTACH_ASSC.PK_INVT_ITEM_ATTACH_ASSC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_ITEM_ATTACH_ASSC.PK_INVT_ITEM_ATTACH_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_ITEM_ATTACH_ASSC.PK_INVT_ITEM_ATTACH_ASSC Bound Attachments |
Name | Current Value |
INVT_ITEM_ATTACH_ASSC.FK_IIA_ASSC_TO_ICI |
TableName | INVT_ITEM_ATTACH_ASSC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX INVT.FK_IIA_ASSC_TO_ICI ON INVT.INVT_ITEM_ATTACH_ASSC(ITEM_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE INVT_TS      LOGGING      STORAGE(INITIAL 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
INVT_ITEM_ATTACH_ASSC.FK_IIA_ASSC_TO_ICI Index Columns |
ColumnName | Sort Order |
ITEM_ID | Ascending |
INVT_ITEM_ATTACH_ASSC.FK_IIA_ASSC_TO_ICI Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_ITEM_ATTACH_ASSC.FK_IIA_ASSC_TO_ICI Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_ITEM_ATTACH_ASSC.FK_IIA_ASSC_TO_ICI Bound Attachments |
Name | Current Value |
INVT_ITEM_ATTACH_ASSC.fk_invt_item_attach_to_iiaa |
TableName | INVT_ITEM_ATTACH_ASSC |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX INVT.fk_invt_item_attach_to_iiaa ON INVT.INVT_ITEM_ATTACH_ASSC(ATTACH_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE INVT_TS      LOGGING      STORAGE(INITIAL 64K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
INVT_ITEM_ATTACH_ASSC.fk_invt_item_attach_to_iiaa Index Columns |
ColumnName | Sort Order |
ATTACH_ID | Ascending |
INVT_ITEM_ATTACH_ASSC.fk_invt_item_attach_to_iiaa Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
INVT_ITEM_ATTACH_ASSC.fk_invt_item_attach_to_iiaa Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INVT_ITEM_ATTACH_ASSC.fk_invt_item_attach_to_iiaa Bound Attachments |
Name | Current Value |
NSSD_ROOM.PK_NSSD_ROOM |
TableName | NSSD_ROOM |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
NSSD_ROOM.PK_NSSD_ROOM Index Columns |
ColumnName | Sort Order |
BUILDING | Ascending |
ROOM | Ascending |
NSSD_ROOM.PK_NSSD_ROOM 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 |
NSSD_ROOM.PK_NSSD_ROOM Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NSSD_ROOM.PK_NSSD_ROOM Bound Attachments |
Name | Current Value |
PO.PK_PO |
TableName | PO |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PO.PK_PO Index Columns |
ColumnName | Sort Order |
PO_NBR | Ascending |
PO_ITEM_NBR | Ascending |
PO.PK_PO 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 |
PO.PK_PO Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PO.PK_PO Bound Attachments |
Name | Current Value |
PO_HIST.PK_PO_1 |
TableName | PO_HIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PO_HIST.PK_PO_1 Index Columns |
ColumnName | Sort Order |
PO_ITEM_NBR | Ascending |
PO_NBR | Ascending |
CUR_DTE | Ascending |
PO_HIST.PK_PO_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 |
PO_HIST.PK_PO_1 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PO_HIST.PK_PO_1 Bound Attachments |
Name | Current Value |
STOR_LOC.PK_STOR_LOC |
TableName | STOR_LOC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
STOR_LOC.PK_STOR_LOC Index Columns |
ColumnName | Sort Order |
STOR_ID | Ascending |
STOR_LOC.PK_STOR_LOC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | INVT_TS |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 0 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
STOR_LOC.PK_STOR_LOC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
STOR_LOC.PK_STOR_LOC Bound Attachments |
Name | Current Value |