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 |
JOB_TITLE.PK_JOB_TITLE |
TableName | JOB_TITLE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
JOB_TITLE.PK_JOB_TITLE Index Columns |
ColumnName | Sort Order |
JOB_TITLE_ID | Ascending |
JOB_TITLE.PK_JOB_TITLE 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 |
JOB_TITLE.PK_JOB_TITLE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
JOB_TITLE.PK_JOB_TITLE Bound Attachments |
Name | Current Value |
OPER_GRP.PK_OPER_GRP |
TableName | OPER_GRP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
OPER_GRP.PK_OPER_GRP Index Columns |
ColumnName | Sort Order |
OPER_GRP_ID | Ascending |
OPER_GRP.PK_OPER_GRP Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 1024 |
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 |
OPER_GRP.PK_OPER_GRP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPER_GRP.PK_OPER_GRP Bound Attachments |
Name | Current Value |
OPER_PROC_MAN.PK_OPER_PROC_MAN |
TableName | OPER_PROC_MAN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
OPER_PROC_MAN.PK_OPER_PROC_MAN Index Columns |
ColumnName | Sort Order |
OPER_PROC_MAN_ID | Ascending |
OPER_PROC_MAN.PK_OPER_PROC_MAN 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 |
OPER_PROC_MAN.PK_OPER_PROC_MAN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPER_PROC_MAN.PK_OPER_PROC_MAN Bound Attachments |
Name | Current Value |
OPER_PROC_MAN_REV.PK_OPER_PROC_MAN_REV |
TableName | OPER_PROC_MAN_REV |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
OPER_PROC_MAN_REV.PK_OPER_PROC_MAN_REV Index Columns |
ColumnName | Sort Order |
OPER_PROC_MAN_ID | Ascending |
REV_NBR | Ascending |
OPER_PROC_MAN_REV.PK_OPER_PROC_MAN_REV 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 |
OPER_PROC_MAN_REV.PK_OPER_PROC_MAN_REV Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPER_PROC_MAN_REV.PK_OPER_PROC_MAN_REV Bound Attachments |
Name | Current Value |
OPER_SUBGRP1.pk_oper_subgrp1 |
TableName | OPER_SUBGRP1 |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
OPER_SUBGRP1.pk_oper_subgrp1 Index Columns |
ColumnName | Sort Order |
OPER_GRP_ID | Ascending |
OPER_SUBGRP1_ID | Ascending |
OPER_SUBGRP1.pk_oper_subgrp1 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 1024 |
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 |
OPER_SUBGRP1.pk_oper_subgrp1 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPER_SUBGRP1.pk_oper_subgrp1 Bound Attachments |
Name | Current Value |
OPM_AUTHOR_ASSC.PK_OPM_AUTHOR_ASSC |
TableName | OPM_AUTHOR_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
OPM_AUTHOR_ASSC.PK_OPM_AUTHOR_ASSC Index Columns |
ColumnName | Sort Order |
OPER_PROC_MAN_ID | Ascending |
REV_NBR | Ascending |
BN | Ascending |
OPM_AUTHOR_ASSC.PK_OPM_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 |
OPM_AUTHOR_ASSC.PK_OPM_AUTHOR_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPM_AUTHOR_ASSC.PK_OPM_AUTHOR_ASSC Bound Attachments |
Name | Current Value |
OPM_CHAP.PK_OPM_CHAP |
TableName | OPM_CHAP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
OPM_CHAP.PK_OPM_CHAP Index Columns |
ColumnName | Sort Order |
OPER_PROC_MAN_ID | Ascending |
REV_NBR | Ascending |
CHAP_NBR | Ascending |
OPM_CHAP.PK_OPM_CHAP 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 |
OPM_CHAP.PK_OPM_CHAP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPM_CHAP.PK_OPM_CHAP Bound Attachments |
Name | Current Value |
OPM_GRP.PK_OPM_GRP |
TableName | OPM_GRP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
OPM_GRP.PK_OPM_GRP Index Columns |
ColumnName | Sort Order |
GRP_ID | Ascending |
OPM_GRP.PK_OPM_GRP 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 |
OPM_GRP.PK_OPM_GRP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPM_GRP.PK_OPM_GRP Bound Attachments |
Name | Current Value |
OPM_REVIEW_STAT.PK_OPM_REVIEW_STAT |
TableName | OPM_REVIEW_STAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
OPM_REVIEW_STAT.PK_OPM_REVIEW_STAT Index Columns |
ColumnName | Sort Order |
REVIEW_STAT_ID | Ascending |
OPM_REVIEW_STAT.PK_OPM_REVIEW_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 |
OPM_REVIEW_STAT.PK_OPM_REVIEW_STAT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPM_REVIEW_STAT.PK_OPM_REVIEW_STAT Bound Attachments |
Name | Current Value |
OPM_REVIEWER_ASSC.PK_OPM_REVIEWER_ASSC |
TableName | OPM_REVIEWER_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
OPM_REVIEWER_ASSC.PK_OPM_REVIEWER_ASSC Index Columns |
ColumnName | Sort Order |
BN | Ascending |
OPER_PROC_MAN_ID | Ascending |
REV_NBR | Ascending |
OPM_REVIEWER_ASSC.PK_OPM_REVIEWER_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 |
OPM_REVIEWER_ASSC.PK_OPM_REVIEWER_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPM_REVIEWER_ASSC.PK_OPM_REVIEWER_ASSC Bound Attachments |
Name | Current Value |
PERS_ROLES.pers_roles_pk |
TableName | PERS_ROLES |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PERS_ROLES.pers_roles_pk Index Columns |
ColumnName | Sort Order |
BN | Ascending |
PERS_ROLES.pers_roles_pk Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | OPER |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
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 |
PERS_ROLES.pers_roles_pk Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PERS_ROLES.pers_roles_pk Bound Attachments |
Name | Current Value |