ATTACHMENT.ATTACHMENT_PK |
TableName | ATTACHMENT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ATTACHMENT.ATTACHMENT_PK Index Columns |
ColumnName | Sort Order |
ATTACHMENT_ID | Ascending |
ATTACHMENT.ATTACHMENT_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
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 |
ATTACHMENT.ATTACHMENT_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ATTACHMENT.ATTACHMENT_PK Bound Attachments |
Name | Current Value |
ATTACHMENT_TYPE.ATTACHMENT_TYPE_PK |
TableName | ATTACHMENT_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ATTACHMENT_TYPE.ATTACHMENT_TYPE_PK Index Columns |
ColumnName | Sort Order |
ATTACHMENT_TYPE_ID | Ascending |
ATTACHMENT_TYPE.ATTACHMENT_TYPE_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
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 |
ATTACHMENT_TYPE.ATTACHMENT_TYPE_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ATTACHMENT_TYPE.ATTACHMENT_TYPE_PK Bound Attachments |
Name | Current Value |
DAILY_ORDER_REQD_READ.DAILY_ORDER_PK |
TableName | DAILY_ORDER_REQD_READ |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DAILY_ORDER_REQD_READ.DAILY_ORDER_PK Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
DAILY_ORDER_REQD_READ.DAILY_ORDER_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
DAILY_ORDER_REQD_READ.DAILY_ORDER_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DAILY_ORDER_REQD_READ.DAILY_ORDER_PK Bound Attachments |
Name | Current Value |
DRAFT_LOG_ENTRY_WO_ASSC.PK_DRAFT_LOG_ENTRY_WO_ASSC |
TableName | DRAFT_LOG_ENTRY_WO_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DRAFT_LOG_ENTRY_WO_ASSC.PK_DRAFT_LOG_ENTRY_WO_ASSC Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
WORK_ORDER_NBR | Ascending |
DRAFT_LOG_ENTRY_WO_ASSC.PK_DRAFT_LOG_ENTRY_WO_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 |
DRAFT_LOG_ENTRY_WO_ASSC.PK_DRAFT_LOG_ENTRY_WO_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DRAFT_LOG_ENTRY_WO_ASSC.PK_DRAFT_LOG_ENTRY_WO_ASSC Bound Attachments |
Name | Current Value |
ENTRY_LOGBOOK.ENTRY_LOGBOOK_PK |
TableName | ENTRY_LOGBOOK |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ENTRY_LOGBOOK.ENTRY_LOGBOOK_PK Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
LOGBOOK_ID | Ascending |
LOG_ENTRY_ID | Ascending |
ENTRY_LOGBOOK.ENTRY_LOGBOOK_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 5056 |
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 |
ENTRY_LOGBOOK.ENTRY_LOGBOOK_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ENTRY_LOGBOOK.ENTRY_LOGBOOK_PK Bound Attachments |
Name | Current Value |
IMAGE.IMAGE_PK |
TableName | IMAGE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
IMAGE.IMAGE_PK Index Columns |
ColumnName | Sort Order |
IMAGE_ID | Ascending |
IMAGE.IMAGE_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
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 |
IMAGE.IMAGE_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IMAGE.IMAGE_PK Bound Attachments |
Name | Current Value |
IMAGE_TYPE.IMAGE_TYPE_PK |
TableName | IMAGE_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
IMAGE_TYPE.IMAGE_TYPE_PK Index Columns |
ColumnName | Sort Order |
IMAGE_TYPE_ID | Ascending |
IMAGE_TYPE.IMAGE_TYPE_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
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 |
IMAGE_TYPE.IMAGE_TYPE_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IMAGE_TYPE.IMAGE_TYPE_PK Bound Attachments |
Name | Current Value |
LOG_ENTRY.LOG_ENTRY_PK |
TableName | LOG_ENTRY |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY.LOG_ENTRY_PK Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
LOG_ENTRY.LOG_ENTRY_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 4224 |
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 |
LOG_ENTRY.LOG_ENTRY_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY.LOG_ENTRY_PK Bound Attachments |
Name | Current Value |
LOG_ENTRY_ATTACHMENT.PK_LOG_ENTRY_ATTACHMENT |
TableName | LOG_ENTRY_ATTACHMENT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_ATTACHMENT.PK_LOG_ENTRY_ATTACHMENT Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
ATTACHMENT_ID | Ascending |
ATTACHMENT_ID | Ascending |
LOG_ENTRY_ATTACHMENT.PK_LOG_ENTRY_ATTACHMENT Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
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 |
LOG_ENTRY_ATTACHMENT.PK_LOG_ENTRY_ATTACHMENT Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_ATTACHMENT.PK_LOG_ENTRY_ATTACHMENT Bound Attachments |
Name | Current Value |
LOG_ENTRY_BOOKMARK.LOG_ENTRY_BOOKMARK_PK |
TableName | LOG_ENTRY_BOOKMARK |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_BOOKMARK.LOG_ENTRY_BOOKMARK_PK Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
BN | Ascending |
LOG_ENTRY_BOOKMARK.LOG_ENTRY_BOOKMARK_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 192 |
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 |
LOG_ENTRY_BOOKMARK.LOG_ENTRY_BOOKMARK_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_BOOKMARK.LOG_ENTRY_BOOKMARK_PK Bound Attachments |
Name | Current Value |
LOG_ENTRY_CATEGORIES.CAT_ID_IDX |
TableName | LOG_ENTRY_CATEGORIES |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE BITMAP INDEX LOGBOOK.CAT_ID_IDX ON LOGBOOK.LOG_ENTRY_CATEGORIES(CAT_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE LOGBOOK      LOGGING      STORAGE(INITIAL 640K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
LOG_ENTRY_CATEGORIES.CAT_ID_IDX Index Columns |
ColumnName | Sort Order |
CAT_ID | Ascending |
LOG_ENTRY_CATEGORIES.CAT_ID_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 640 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | Bitmap |
Byte Order | |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
LOG_ENTRY_CATEGORIES.CAT_ID_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_CATEGORIES.CAT_ID_IDX Bound Attachments |
Name | Current Value |
LOG_ENTRY_CATEGORIES.LOG_ENTRY_ID_IDX |
TableName | LOG_ENTRY_CATEGORIES |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX LOGBOOK.LOG_ENTRY_ID_IDX ON LOGBOOK.LOG_ENTRY_CATEGORIES(LOG_ENTRY_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE LOGBOOK      LOGGING      STORAGE(INITIAL 2112K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              ) ; |
LOG_ENTRY_CATEGORIES.LOG_ENTRY_ID_IDX Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
LOG_ENTRY_CATEGORIES.LOG_ENTRY_ID_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 2112 |
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 |
LOG_ENTRY_CATEGORIES.LOG_ENTRY_ID_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_CATEGORIES.LOG_ENTRY_ID_IDX Bound Attachments |
Name | Current Value |
LOG_ENTRY_IMAGE.PK_LOG_ENTRY_IMAGE |
TableName | LOG_ENTRY_IMAGE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_IMAGE.PK_LOG_ENTRY_IMAGE Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
IMAGE_ID | Ascending |
LOG_ENTRY_IMAGE.PK_LOG_ENTRY_IMAGE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
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 |
LOG_ENTRY_IMAGE.PK_LOG_ENTRY_IMAGE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_IMAGE.PK_LOG_ENTRY_IMAGE Bound Attachments |
Name | Current Value |
LOG_ENTRY_KEYWORD.LOG_ENTRY_KEYWORD_PK |
TableName | LOG_ENTRY_KEYWORD |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_KEYWORD.LOG_ENTRY_KEYWORD_PK Index Columns |
ColumnName | Sort Order |
LOG_KEYWORD_ID | Ascending |
LOG_ENTRY_ID | Ascending |
LOG_ENTRY_KEYWORD.LOG_ENTRY_KEYWORD_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
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 |
LOG_ENTRY_KEYWORD.LOG_ENTRY_KEYWORD_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_KEYWORD.LOG_ENTRY_KEYWORD_PK Bound Attachments |
Name | Current Value |
LOG_ENTRY_LABEL.PK_LOG_ENTRY_LABEL |
TableName | LOG_ENTRY_LABEL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_LABEL.PK_LOG_ENTRY_LABEL Index Columns |
ColumnName | Sort Order |
LABEL_ID | Ascending |
LOG_ENTRY_LABEL.PK_LOG_ENTRY_LABEL Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
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 |
LOG_ENTRY_LABEL.PK_LOG_ENTRY_LABEL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_LABEL.PK_LOG_ENTRY_LABEL Bound Attachments |
Name | Current Value |
LOG_ENTRY_NOTIF.LOG_ENTRY_NOTIF_PK |
TableName | LOG_ENTRY_NOTIF |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_NOTIF.LOG_ENTRY_NOTIF_PK Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
BN | Ascending |
LOG_ENTRY_NOTIF.LOG_ENTRY_NOTIF_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 3520 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
LOG_ENTRY_NOTIF.LOG_ENTRY_NOTIF_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_NOTIF.LOG_ENTRY_NOTIF_PK Bound Attachments |
Name | Current Value |
LOG_ENTRY_PRIOR.LOG_ENTRY_PRIOR_PK |
TableName | LOG_ENTRY_PRIOR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_PRIOR.LOG_ENTRY_PRIOR_PK Index Columns |
ColumnName | Sort Order |
PRIOR_ID | Ascending |
LOG_ENTRY_PRIOR.LOG_ENTRY_PRIOR_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY_PRIOR.LOG_ENTRY_PRIOR_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_PRIOR.LOG_ENTRY_PRIOR_PK Bound Attachments |
Name | Current Value |
LOG_ENTRY_RAD_AREA.PK_LOG_ENTRY_RAD_AREA |
TableName | LOG_ENTRY_RAD_AREA |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_RAD_AREA.PK_LOG_ENTRY_RAD_AREA Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
AREA_ID | Ascending |
LOG_ENTRY_RAD_AREA.PK_LOG_ENTRY_RAD_AREA Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 896 |
Next | 1024 |
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 |
LOG_ENTRY_RAD_AREA.PK_LOG_ENTRY_RAD_AREA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_RAD_AREA.PK_LOG_ENTRY_RAD_AREA Bound Attachments |
Name | Current Value |
LOG_ENTRY_READ.LOG_ENTRY_READ_PK |
TableName | LOG_ENTRY_READ |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_READ.LOG_ENTRY_READ_PK Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
BN | Ascending |
LOG_ENTRY_READ.LOG_ENTRY_READ_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 384 |
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 |
LOG_ENTRY_READ.LOG_ENTRY_READ_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_READ.LOG_ENTRY_READ_PK Bound Attachments |
Name | Current Value |
LOG_ENTRY_READ.IDX_LOG_ENTRY_READ_DTE |
TableName | LOG_ENTRY_READ |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX LOGBOOK.IDX_LOG_ENTRY_READ_DTE ON LOGBOOK.LOG_ENTRY_READ(READ_DTE)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE LOGBOOK      LOGGING      STORAGE(INITIAL 192K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
LOG_ENTRY_READ.IDX_LOG_ENTRY_READ_DTE Index Columns |
ColumnName | Sort Order |
READ_DTE | Ascending |
LOG_ENTRY_READ.IDX_LOG_ENTRY_READ_DTE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 192 |
Next | 1024 |
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 |
LOG_ENTRY_READ.IDX_LOG_ENTRY_READ_DTE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_READ.IDX_LOG_ENTRY_READ_DTE Bound Attachments |
Name | Current Value |
LOG_ENTRY_TYPE.LOG_ENTRY_TYPE_PK |
TableName | LOG_ENTRY_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_TYPE.LOG_ENTRY_TYPE_PK Index Columns |
ColumnName | Sort Order |
TYPE_ID | Ascending |
LOG_ENTRY_TYPE.LOG_ENTRY_TYPE_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
LOG_ENTRY_TYPE.LOG_ENTRY_TYPE_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_TYPE.LOG_ENTRY_TYPE_PK Bound Attachments |
Name | Current Value |
LOG_KEYWORD.LOG_KEYWORD_PK |
TableName | LOG_KEYWORD |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_KEYWORD.LOG_KEYWORD_PK Index Columns |
ColumnName | Sort Order |
LOG_KEYWORD_ID | Ascending |
LOG_KEYWORD.LOG_KEYWORD_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
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 |
LOG_KEYWORD.LOG_KEYWORD_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_KEYWORD.LOG_KEYWORD_PK Bound Attachments |
Name | Current Value |
LOGBOOK_USER_CAT.LOGBOOK_USER_CAT_PK |
TableName | LOGBOOK_USER_CAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOGBOOK_USER_CAT.LOGBOOK_USER_CAT_PK Index Columns |
ColumnName | Sort Order |
USER_CAT_ID | Ascending |
LOGBOOK_USER_CAT.LOGBOOK_USER_CAT_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
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 |
LOGBOOK_USER_CAT.LOGBOOK_USER_CAT_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOGBOOK_USER_CAT.LOGBOOK_USER_CAT_PK Bound Attachments |
Name | Current Value |
REQD_READ_FREQ.REQ_READ_FREQ_PK |
TableName | REQD_READ_FREQ |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
REQD_READ_FREQ.REQ_READ_FREQ_PK Index Columns |
ColumnName | Sort Order |
REQD_READ_FREQ_ID | Ascending |
REQD_READ_FREQ.REQ_READ_FREQ_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
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 |
REQD_READ_FREQ.REQ_READ_FREQ_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REQD_READ_FREQ.REQ_READ_FREQ_PK Bound Attachments |
Name | Current Value |
USER_LOG_ENTRY_FLTR.PK_USR_LOG_ENTRY_FLTR |
TableName | USER_LOG_ENTRY_FLTR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | PK_USER_LOG_ENTRY_FLTR |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
USER_LOG_ENTRY_FLTR.PK_USR_LOG_ENTRY_FLTR Index Columns |
ColumnName | Sort Order |
BN | Ascending |
USER_LOG_ENTRY_FLTR.PK_USR_LOG_ENTRY_FLTR Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
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 |
USER_LOG_ENTRY_FLTR.PK_USR_LOG_ENTRY_FLTR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
USER_LOG_ENTRY_FLTR.PK_USR_LOG_ENTRY_FLTR Bound Attachments |
Name | Current Value |
USER_LOGIN.PK_USER_LOGIN |
TableName | USER_LOGIN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
USER_LOGIN.PK_USER_LOGIN Index Columns |
ColumnName | Sort Order |
BN | Ascending |
USER_LOGIN.PK_USER_LOGIN Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
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 |
USER_LOGIN.PK_USER_LOGIN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
USER_LOGIN.PK_USER_LOGIN Bound Attachments |
Name | Current Value |
USER_SUBSCR.USER_SUBSCR_PK |
TableName | USER_SUBSCR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | LOG_ENTRY_SUBSCR_PK |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
USER_SUBSCR.USER_SUBSCR_PK Index Columns |
ColumnName | Sort Order |
BN | Ascending |
EQUIP_CAT_ID | Ascending |
USER_SUBSCR.USER_SUBSCR_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | |
Byte Order | |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Index Compression | NO |
USER_SUBSCR.USER_SUBSCR_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
USER_SUBSCR.USER_SUBSCR_PK Bound Attachments |
Name | Current Value |