ALARM_LOG.PK_ALARM_LOG

TableName	ALARM_LOG
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

ALARM_LOG.PK_ALARM_LOG Index Columns

ColumnName Sort Order

SGNL_ID Ascending

MOD_DTE Ascending

ALARM_LOG.PK_ALARM_LOG Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

ALARM_LOG.PK_ALARM_LOG Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

ALARM_LOG.PK_ALARM_LOG Bound Attachments

Name Current Value

ARCH_GRP.ARCH_GRP_PK

TableName	ARCH_GRP
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

ARCH_GRP.ARCH_GRP_PK Index Columns

ColumnName Sort Order

ARCH_GRP_FILE_NM Ascending

ARCH_GRP.ARCH_GRP_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

ARCH_GRP.ARCH_GRP_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

ARCH_GRP.ARCH_GRP_PK Bound Attachments

Name Current Value

ARCH_REQ.ARCH_REQ_PK

TableName	ARCH_REQ
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

ARCH_REQ.ARCH_REQ_PK Index Columns

ColumnName Sort Order

ARCH_REQ_FILE_NM Ascending

ARCH_REQ.ARCH_REQ_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

ARCH_REQ.ARCH_REQ_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

ARCH_REQ.ARCH_REQ_PK Bound Attachments

Name Current Value

ARCH_REQ_GRP.ARCH_REQ_GRP_PK

TableName	ARCH_REQ_GRP
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

ARCH_REQ_GRP.ARCH_REQ_GRP_PK Index Columns

ColumnName Sort Order

ARCH_REQ_FILE_NM Ascending

ARCH_GRP_FILE_NM Ascending

ARCH_REQ_GRP.ARCH_REQ_GRP_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

ARCH_REQ_GRP.ARCH_REQ_GRP_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

ARCH_REQ_GRP.ARCH_REQ_GRP_PK Bound Attachments

Name Current Value

ARCH_SGNL_FLD_DISP.PK_ARCH_SGNL_FLD_DISP

TableName	ARCH_SGNL_FLD_DISP
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

ARCH_SGNL_FLD_DISP.PK_ARCH_SGNL_FLD_DISP Index Columns

ColumnName Sort Order

FLD_ID Ascending

ARCH_SGNL_FLD_DISP.PK_ARCH_SGNL_FLD_DISP Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

ARCH_SGNL_FLD_DISP.PK_ARCH_SGNL_FLD_DISP Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

ARCH_SGNL_FLD_DISP.PK_ARCH_SGNL_FLD_DISP Bound Attachments

Name Current Value

BEAM_LINE_DVC_ENERGY.BEAM_LINE_DVC_ENERGY_PK

TableName	BEAM_LINE_DVC_ENERGY
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

BEAM_LINE_DVC_ENERGY.BEAM_LINE_DVC_ENERGY_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

SCENARIO_ID Ascending

BEAM_LINE_DVC_ENERGY.BEAM_LINE_DVC_ENERGY_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

BEAM_LINE_DVC_ENERGY.BEAM_LINE_DVC_ENERGY_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

BEAM_LINE_DVC_ENERGY.BEAM_LINE_DVC_ENERGY_PK Bound Attachments

Name Current Value

BEAM_LINE_DVC_LOC.BEAM_LINE_DVC_LOC_PK

TableName	BEAM_LINE_DVC_LOC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

BEAM_LINE_DVC_LOC.BEAM_LINE_DVC_LOC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

SEQ_NM Ascending

BEAM_LINE_DVC_LOC.BEAM_LINE_DVC_LOC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging NotLogged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

BEAM_LINE_DVC_LOC.BEAM_LINE_DVC_LOC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

BEAM_LINE_DVC_LOC.BEAM_LINE_DVC_LOC_PK Bound Attachments

Name Current Value

BPM_DVC.BPM_DVC_PK

TableName	BPM_DVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

BPM_DVC.BPM_DVC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

BPM_DVC.BPM_DVC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

BPM_DVC.BPM_DVC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

BPM_DVC.BPM_DVC_PK Bound Attachments

Name Current Value

BYPASS_AFF_SGNL.BYPASS_AFF_SGNL_PK

TableName	BYPASS_AFF_SGNL
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

BYPASS_AFF_SGNL.BYPASS_AFF_SGNL_PK Index Columns

ColumnName Sort Order

BYPASS_NBR Ascending

SGNL_ID Ascending

BYPASS_AFF_SGNL.BYPASS_AFF_SGNL_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

BYPASS_AFF_SGNL.BYPASS_AFF_SGNL_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

BYPASS_AFF_SGNL.BYPASS_AFF_SGNL_PK Bound Attachments

Name Current Value

BYPASS_DVC_AFF.BYPASS_AFF_DVC_PK

TableName	BYPASS_DVC_AFF
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

BYPASS_DVC_AFF.BYPASS_AFF_DVC_PK Index Columns

ColumnName Sort Order

BYPASS_NBR Ascending

DVC_ID Ascending

BYPASS_DVC_AFF.BYPASS_AFF_DVC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

BYPASS_DVC_AFF.BYPASS_AFF_DVC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

BYPASS_DVC_AFF.BYPASS_AFF_DVC_PK Bound Attachments

Name Current Value

BYPASS_ELOG_NOTIF.BYPASS_ELOG_NOTIF_PK

TableName	BYPASS_ELOG_NOTIF
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

BYPASS_ELOG_NOTIF.BYPASS_ELOG_NOTIF_PK Index Columns

ColumnName Sort Order

BYPASS_NBR Ascending

LOGBOOK_ID Ascending

BYPASS_ELOG_NOTIF.BYPASS_ELOG_NOTIF_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

BYPASS_ELOG_NOTIF.BYPASS_ELOG_NOTIF_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

BYPASS_ELOG_NOTIF.BYPASS_ELOG_NOTIF_PK Bound Attachments

Name Current Value

BYPASS_EMAIL_NOTIF.BYPASS_EMAIL_NOTIF_PK

TableName	BYPASS_EMAIL_NOTIF
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

BYPASS_EMAIL_NOTIF.BYPASS_EMAIL_NOTIF_PK Index Columns

ColumnName Sort Order

BYPASS_NBR Ascending

EMAIL_ADDR Ascending

BYPASS_EMAIL_NOTIF.BYPASS_EMAIL_NOTIF_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

BYPASS_EMAIL_NOTIF.BYPASS_EMAIL_NOTIF_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

BYPASS_EMAIL_NOTIF.BYPASS_EMAIL_NOTIF_PK Bound Attachments

Name Current Value

BYPASS_MECH.BYPASS_MECH_PK

TableName	BYPASS_MECH
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

BYPASS_MECH.BYPASS_MECH_PK Index Columns

ColumnName Sort Order

BYPASS_MECH_NM Ascending

BYPASS_MECH.BYPASS_MECH_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

BYPASS_MECH.BYPASS_MECH_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

BYPASS_MECH.BYPASS_MECH_PK Bound Attachments

Name Current Value

BYPASS_REQ.BYPASS_REQ_PK

TableName	BYPASS_REQ
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

BYPASS_REQ.BYPASS_REQ_PK Index Columns

ColumnName Sort Order

BYPASS_NBR Ascending

BYPASS_REQ.BYPASS_REQ_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

BYPASS_REQ.BYPASS_REQ_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

BYPASS_REQ.BYPASS_REQ_PK Bound Attachments

Name Current Value

CAB_NOID_DVC.CAB_NOID_DVC_PK

TableName	CAB_NOID_DVC
Physical Only	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE INDEX EPICS.CAB_NOID_DVC_PK ON EPICS.CAB_NOID_DVC(DVC_ID, PARENT_DVC_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

CAB_NOID_DVC.CAB_NOID_DVC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

PARENT_DVC_ID Ascending

CAB_NOID_DVC.CAB_NOID_DVC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

CAB_NOID_DVC.CAB_NOID_DVC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

CAB_NOID_DVC.CAB_NOID_DVC_PK Bound Attachments

Name Current Value

CCU_DVC.CCU_DVC_PK

TableName	CCU_DVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

CCU_DVC.CCU_DVC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

CCU_DVC.CCU_DVC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

CCU_DVC.CCU_DVC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

CCU_DVC.CCU_DVC_PK Bound Attachments

Name Current Value

CHMK_DAILY_STAT.PK_CHMK_DAILY_STAT

TableName	CHMK_DAILY_STAT
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

CHMK_DAILY_STAT.PK_CHMK_DAILY_STAT Index Columns

ColumnName Sort Order

SGNL_ID Ascending

CUR_DTE Ascending

CHMK_DAILY_STAT.PK_CHMK_DAILY_STAT Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

CHMK_DAILY_STAT.PK_CHMK_DAILY_STAT Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

CHMK_DAILY_STAT.PK_CHMK_DAILY_STAT Bound Attachments

Name Current Value

CHMK_DVC.CHMK_DVC_PK

TableName	CHMK_DVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name	PK_CHMK_DVC
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

CHMK_DVC.CHMK_DVC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

CHMK_DVC.CHMK_DVC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

CHMK_DVC.CHMK_DVC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

CHMK_DVC.CHMK_DVC_PK Bound Attachments

Name Current Value

DELAYED_REAL_TIME_SGNL_VAL.PK_DELAYED_REAL_TIME_SGNL_VAL

TableName	DELAYED_REAL_TIME_SGNL_VAL
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

DELAYED_REAL_TIME_SGNL_VAL.PK_DELAYED_REAL_TIME_SGNL_VAL Index Columns

ColumnName Sort Order

SGNL_ID Ascending

CAP_DTE Ascending

DELAYED_REAL_TIME_SGNL_VAL.PK_DELAYED_REAL_TIME_SGNL_VAL Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DELAYED_REAL_TIME_SGNL_VAL.PK_DELAYED_REAL_TIME_SGNL_VAL Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DELAYED_REAL_TIME_SGNL_VAL.PK_DELAYED_REAL_TIME_SGNL_VAL Bound Attachments

Name Current Value

DIAG_ELEX_DVC.DIAG_ELEX_DVC_PK

TableName	DIAG_ELEX_DVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

DIAG_ELEX_DVC.DIAG_ELEX_DVC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

DIAG_ELEX_DVC.DIAG_ELEX_DVC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging NotLogged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DIAG_ELEX_DVC.DIAG_ELEX_DVC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DIAG_ELEX_DVC.DIAG_ELEX_DVC_PK Bound Attachments

Name Current Value

DIAG_MOT_DR_DVC.DIAG_MOT_DR_DVC_PK

TableName	DIAG_MOT_DR_DVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

DIAG_MOT_DR_DVC.DIAG_MOT_DR_DVC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

DIAG_MOT_DR_DVC.DIAG_MOT_DR_DVC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DIAG_MOT_DR_DVC.DIAG_MOT_DR_DVC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DIAG_MOT_DR_DVC.DIAG_MOT_DR_DVC_PK Bound Attachments

Name Current Value

DSGN_DVC_MNFCTR_MDL_ASGN.DSGN_DVC_MNFCTR_MDL_ASGN_UNQ

TableName	DSGN_DVC_MNFCTR_MDL_ASGN
Physical Only	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE UNIQUE INDEX EPICS.DSGN_DVC_MNFCTR_MDL_ASGN_UNQ ON EPICS.DSGN_DVC_MNFCTR_MDL_ASGN(DVC_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

DSGN_DVC_MNFCTR_MDL_ASGN.DSGN_DVC_MNFCTR_MDL_ASGN_UNQ Index Columns

ColumnName Sort Order

DVC_ID Ascending

DSGN_DVC_MNFCTR_MDL_ASGN.DSGN_DVC_MNFCTR_MDL_ASGN_UNQ Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DSGN_DVC_MNFCTR_MDL_ASGN.DSGN_DVC_MNFCTR_MDL_ASGN_UNQ Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DSGN_DVC_MNFCTR_MDL_ASGN.DSGN_DVC_MNFCTR_MDL_ASGN_UNQ Bound Attachments

Name Current Value

DSGN_DVC_MNFCTR_MDL_ASGN.DSGN_DVC_MNFCTR_MDL_ASGN_PK

TableName	DSGN_DVC_MNFCTR_MDL_ASGN
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

DSGN_DVC_MNFCTR_MDL_ASGN.DSGN_DVC_MNFCTR_MDL_ASGN_PK Index Columns

ColumnName Sort Order

MNFCTR_ID Ascending

MDL_NBR Ascending

DVC_ID Ascending

DSGN_DVC_MNFCTR_MDL_ASGN.DSGN_DVC_MNFCTR_MDL_ASGN_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DSGN_DVC_MNFCTR_MDL_ASGN.DSGN_DVC_MNFCTR_MDL_ASGN_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DSGN_DVC_MNFCTR_MDL_ASGN.DSGN_DVC_MNFCTR_MDL_ASGN_PK Bound Attachments

Name Current Value

DUPL_SGNL.PK_DUPL_SGNL_X

TableName	DUPL_SGNL
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name	PK_DUPL_SGNL
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

DUPL_SGNL.PK_DUPL_SGNL_X Index Columns

ColumnName Sort Order

SGNL_ID Ascending

DVC_ID Ascending

EXT_SRC_FILE_NM Ascending

ACT_IND Ascending

DUPL_SGNL.PK_DUPL_SGNL_X Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DUPL_SGNL.PK_DUPL_SGNL_X Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DUPL_SGNL.PK_DUPL_SGNL_X Bound Attachments

Name Current Value

DVC.DVC_DVC_TYPE_ID_IDX

TableName	DVC
Physical Only	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE INDEX EPICS.DVC_DVC_TYPE_ID_IDX ON EPICS.DVC(DVC_TYPE_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

DVC.DVC_DVC_TYPE_ID_IDX Index Columns

ColumnName Sort Order

DVC_TYPE_ID Ascending

DVC.DVC_DVC_TYPE_ID_IDX Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DVC.DVC_DVC_TYPE_ID_IDX Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC.DVC_DVC_TYPE_ID_IDX Bound Attachments

Name Current Value

DVC.DVC_ID_ALIAS_IDX

TableName	DVC
Physical Only	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE UNIQUE INDEX EPICS.DVC_ID_ALIAS_IDX ON EPICS.DVC(DVC_ID_ALIAS) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_INDEX_TS NOLOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

DVC.DVC_ID_ALIAS_IDX Index Columns

ColumnName Sort Order

DVC_ID_ALIAS Ascending

DVC.DVC_ID_ALIAS_IDX Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging NotLogged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DVC.DVC_ID_ALIAS_IDX Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC.DVC_ID_ALIAS_IDX Bound Attachments

Name Current Value

DVC.DEVICE_PK

TableName	DVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

DVC.DEVICE_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

DVC.DEVICE_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging NotLogged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DVC.DEVICE_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC.DEVICE_PK Bound Attachments

Name Current Value

DVC.UPPER_DVC_ID_IDX

TableName	DVC
Physical Only	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE INDEX EPICS.UPPER_DVC_ID_IDX ON EPICS.DVC(UPPER("DVC_ID")) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

DVC.UPPER_DVC_ID_IDX Index Columns

ColumnName Sort Order

UPPER("DVC_ID")

DVC.UPPER_DVC_ID_IDX Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DVC.UPPER_DVC_ID_IDX Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC.UPPER_DVC_ID_IDX Bound Attachments

Name Current Value

DVC.PRNT_DVC_ID

TableName	DVC
Physical Only	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE INDEX EPICS.PRNT_DVC_ID ON EPICS.DVC(PARENT_DVC_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

DVC.PRNT_DVC_ID Index Columns

ColumnName Sort Order

PARENT_DVC_ID Ascending

DVC.PRNT_DVC_ID Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DVC.PRNT_DVC_ID Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC.PRNT_DVC_ID Bound Attachments

Name Current Value

DVC.DVC_SYS_ID_IDX

TableName	DVC
Physical Only	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE INDEX EPICS.DVC_SYS_ID_IDX ON EPICS.DVC(SYS_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

DVC.DVC_SYS_ID_IDX Index Columns

ColumnName Sort Order

SYS_ID Ascending

DVC.DVC_SYS_ID_IDX Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DVC.DVC_SYS_ID_IDX Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC.DVC_SYS_ID_IDX Bound Attachments

Name Current Value

DVC.DVC_SUBSYS_ID_IDX

TableName	DVC
Physical Only	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE INDEX EPICS.DVC_SUBSYS_ID_IDX ON EPICS.DVC(SUBSYS_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

DVC.DVC_SUBSYS_ID_IDX Index Columns

ColumnName Sort Order

SUBSYS_ID Ascending

DVC.DVC_SUBSYS_ID_IDX Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DVC.DVC_SUBSYS_ID_IDX Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC.DVC_SUBSYS_ID_IDX Bound Attachments

Name Current Value

DVC_CRIT.PK_DVC_CRIT

TableName	DVC_CRIT
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

DVC_CRIT.PK_DVC_CRIT Index Columns

ColumnName Sort Order

CRIT_ID Ascending

DVC_CRIT.PK_DVC_CRIT Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE

PctFree

MinExtents

MaxExtents

Initial

Next

PctIncrease

InitTrans

MaxTrans

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS

FREELIST GROUPS

Buffer Pool

Index Compression NO

DVC_CRIT.PK_DVC_CRIT Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC_CRIT.PK_DVC_CRIT Bound Attachments

Name Current Value

DVC_DVC_TYPE_SFTW_ASSC.PK_DVC_DVC_TYPE_SFTW_ASSC

TableName	DVC_DVC_TYPE_SFTW_ASSC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

DVC_DVC_TYPE_SFTW_ASSC.PK_DVC_DVC_TYPE_SFTW_ASSC Index Columns

ColumnName Sort Order

DVC_ID Ascending

DVC_TYPE_ID Ascending

SFTW_ID Ascending

DVC_DVC_TYPE_SFTW_ASSC.PK_DVC_DVC_TYPE_SFTW_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

DVC_DVC_TYPE_SFTW_ASSC.PK_DVC_DVC_TYPE_SFTW_ASSC Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC_DVC_TYPE_SFTW_ASSC.PK_DVC_DVC_TYPE_SFTW_ASSC Bound Attachments

Name Current Value

DVC_PHYS_LOC.DVC_PHYS_LOC_PK

TableName	DVC_PHYS_LOC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

DVC_PHYS_LOC.DVC_PHYS_LOC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

DVC_PHYS_LOC.DVC_PHYS_LOC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DVC_PHYS_LOC.DVC_PHYS_LOC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC_PHYS_LOC.DVC_PHYS_LOC_PK Bound Attachments

Name Current Value

DVC_PORT_ASGN.PK_DVC_PORT_ASGN

TableName	DVC_PORT_ASGN
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

DVC_PORT_ASGN.PK_DVC_PORT_ASGN Index Columns

ColumnName Sort Order

DVC_ID Ascending

PORT_DVC_ID Ascending

PORT_NBR Ascending

DVC_PORT_ASGN.PK_DVC_PORT_ASGN Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DVC_PORT_ASGN.PK_DVC_PORT_ASGN Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC_PORT_ASGN.PK_DVC_PORT_ASGN Bound Attachments

Name Current Value

DVC_SEQ_NM.DVC_SEQ_NM_PK

TableName	DVC_SEQ_NM
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

DVC_SEQ_NM.DVC_SEQ_NM_PK Index Columns

ColumnName Sort Order

SEQ_NM Ascending

DVC_SEQ_NM.DVC_SEQ_NM_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DVC_SEQ_NM.DVC_SEQ_NM_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC_SEQ_NM.DVC_SEQ_NM_PK Bound Attachments

Name Current Value

DVC_SETTING.DVC_SETTING_PK

TableName	DVC_SETTING
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

DVC_SETTING.DVC_SETTING_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

SCENARIO_ID Ascending

SETTING_ID Ascending

DVC_SETTING.DVC_SETTING_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DVC_SETTING.DVC_SETTING_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC_SETTING.DVC_SETTING_PK Bound Attachments

Name Current Value

DVC_TYPE.UPPER_DVC_TYPE_ID_IDX

TableName	DVC_TYPE
Physical Only	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE UNIQUE INDEX EPICS.UPPER_DVC_TYPE_ID_IDX ON EPICS.DVC_TYPE(UPPER("DVC_TYPE_ID")) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

DVC_TYPE.UPPER_DVC_TYPE_ID_IDX Index Columns

ColumnName Sort Order

UPPER("DVC_TYPE_ID")

DVC_TYPE.UPPER_DVC_TYPE_ID_IDX Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DVC_TYPE.UPPER_DVC_TYPE_ID_IDX Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC_TYPE.UPPER_DVC_TYPE_ID_IDX Bound Attachments

Name Current Value

DVC_TYPE.DVC_TYPE_PK

TableName	DVC_TYPE
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

DVC_TYPE.DVC_TYPE_PK Index Columns

ColumnName Sort Order

DVC_TYPE_ID Ascending

DVC_TYPE.DVC_TYPE_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 120

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DVC_TYPE.DVC_TYPE_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC_TYPE.DVC_TYPE_PK Bound Attachments

Name Current Value

DVC_TYPE_SFTW.PK_DVC_TYPE_SFTW

TableName	DVC_TYPE_SFTW
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

DVC_TYPE_SFTW.PK_DVC_TYPE_SFTW Index Columns

ColumnName Sort Order

DVC_TYPE_ID Ascending

SFTW_ID Ascending

DVC_TYPE_SFTW.PK_DVC_TYPE_SFTW 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

DVC_TYPE_SFTW.PK_DVC_TYPE_SFTW Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC_TYPE_SFTW.PK_DVC_TYPE_SFTW Bound Attachments

Name Current Value

DVC_TYPE_SGNL.DVC_TYPE_SGNL_PK

TableName	DVC_TYPE_SGNL
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

DVC_TYPE_SGNL.DVC_TYPE_SGNL_PK Index Columns

ColumnName Sort Order

DVC_TYPE_ID Ascending

DVC_TYPE_SGNL_NM Ascending

DVC_TYPE_SGNL.DVC_TYPE_SGNL_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging NotLogged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

DVC_TYPE_SGNL.DVC_TYPE_SGNL_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

DVC_TYPE_SGNL.DVC_TYPE_SGNL_PK Bound Attachments

Name Current Value

EPICS_GRP.EPICS_GRP_PK

TableName	EPICS_GRP
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

EPICS_GRP.EPICS_GRP_PK Index Columns

ColumnName Sort Order

EPICS_GRP_ID Ascending

EPICS_GRP.EPICS_GRP_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

EPICS_GRP.EPICS_GRP_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

EPICS_GRP.EPICS_GRP_PK Bound Attachments

Name Current Value

EPICS_VER.EPICS_VER_PK

TableName	EPICS_VER
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

EPICS_VER.EPICS_VER_PK Index Columns

ColumnName Sort Order

EPICS_VER Ascending

EPICS_VER.EPICS_VER_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

EPICS_VER.EPICS_VER_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

EPICS_VER.EPICS_VER_PK Bound Attachments

Name Current Value

FILE_LAST_IMPORT.FILE_LAST_IMPORT_PK

TableName	FILE_LAST_IMPORT
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

FILE_LAST_IMPORT.FILE_LAST_IMPORT_PK Index Columns

ColumnName Sort Order

FILE_NM Ascending

FILE_LAST_IMPORT.FILE_LAST_IMPORT_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

FILE_LAST_IMPORT.FILE_LAST_IMPORT_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

FILE_LAST_IMPORT.FILE_LAST_IMPORT_PK Bound Attachments

Name Current Value

FUNC_DVC_GRP.FUNC_DVC_GRP_PK

TableName	FUNC_DVC_GRP
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

FUNC_DVC_GRP.FUNC_DVC_GRP_PK Index Columns

ColumnName Sort Order

FUNC_DVC_GRP_ID Ascending

FUNC_DVC_GRP.FUNC_DVC_GRP_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

FUNC_DVC_GRP.FUNC_DVC_GRP_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

FUNC_DVC_GRP.FUNC_DVC_GRP_PK Bound Attachments

Name Current Value

FUNC_DVC_GRP_ITEM.FUNC_DVC_GRP_ITEM_PK

TableName	FUNC_DVC_GRP_ITEM
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

FUNC_DVC_GRP_ITEM.FUNC_DVC_GRP_ITEM_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

RELATED_DVC Ascending

FUNC_DVC_GRP_ID Ascending

FUNC_DVC_GRP_ITEM.FUNC_DVC_GRP_ITEM_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

FUNC_DVC_GRP_ITEM.FUNC_DVC_GRP_ITEM_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

FUNC_DVC_GRP_ITEM.FUNC_DVC_GRP_ITEM_PK Bound Attachments

Name Current Value

ICS_COMM_DVC.ICS_COMM_DVC_PK

TableName	ICS_COMM_DVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

ICS_COMM_DVC.ICS_COMM_DVC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

ICS_COMM_DVC.ICS_COMM_DVC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging NotLogged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

ICS_COMM_DVC.ICS_COMM_DVC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

ICS_COMM_DVC.ICS_COMM_DVC_PK Bound Attachments

Name Current Value

ICS_COMM_OPER_ENV.PK_ICS_COMM_OPER_ENV

TableName	ICS_COMM_OPER_ENV
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

ICS_COMM_OPER_ENV.PK_ICS_COMM_OPER_ENV Index Columns

ColumnName Sort Order

DVC_ID Ascending

ICS_COMM_OPER_ENV.PK_ICS_COMM_OPER_ENV Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

ICS_COMM_OPER_ENV.PK_ICS_COMM_OPER_ENV Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

ICS_COMM_OPER_ENV.PK_ICS_COMM_OPER_ENV Bound Attachments

Name Current Value

ICS_COMM_OPER_ENV.UNQ_COMP_ID

TableName	ICS_COMM_OPER_ENV
Physical Only	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	Unique Constraint
DDL Code

ICS_COMM_OPER_ENV.UNQ_COMP_ID Index Columns

ColumnName Sort Order

COMP_ID Ascending

ICS_COMM_OPER_ENV.UNQ_COMP_ID Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

ICS_COMM_OPER_ENV.UNQ_COMP_ID Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

ICS_COMM_OPER_ENV.UNQ_COMP_ID Bound Attachments

Name Current Value

ICS_COMM_SFTW.PK_ICS_COMM_SFTW

TableName	ICS_COMM_SFTW
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

ICS_COMM_SFTW.PK_ICS_COMM_SFTW Index Columns

ColumnName Sort Order

DVC_ID Ascending

BOOT_DTE Ascending

SFTW_NM Ascending

ICS_COMM_SFTW.PK_ICS_COMM_SFTW Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

ICS_COMM_SFTW.PK_ICS_COMM_SFTW Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

ICS_COMM_SFTW.PK_ICS_COMM_SFTW Bound Attachments

Name Current Value

ICS_COMM_SFTW_MOD.PK_ICS_COMM_SFTW_MOD

TableName	ICS_COMM_SFTW_MOD
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

ICS_COMM_SFTW_MOD.PK_ICS_COMM_SFTW_MOD Index Columns

ColumnName Sort Order

SFTW_NM Ascending

ICS_COMM_SFTW_MOD.PK_ICS_COMM_SFTW_MOD Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

ICS_COMM_SFTW_MOD.PK_ICS_COMM_SFTW_MOD Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

ICS_COMM_SFTW_MOD.PK_ICS_COMM_SFTW_MOD Bound Attachments

Name Current Value

ICS_MULTIPORT_COMM_DVC.ICS_MULTIPORT_COMM_DVC_PK

TableName	ICS_MULTIPORT_COMM_DVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

ICS_MULTIPORT_COMM_DVC.ICS_MULTIPORT_COMM_DVC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

PORT_NBR Ascending

ICS_MULTIPORT_COMM_DVC.ICS_MULTIPORT_COMM_DVC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

ICS_MULTIPORT_COMM_DVC.ICS_MULTIPORT_COMM_DVC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

ICS_MULTIPORT_COMM_DVC.ICS_MULTIPORT_COMM_DVC_PK Bound Attachments

Name Current Value

IEEE_COMPONENT_TYPE.IEE_CMPNT_TYPE_PK

TableName	IEEE_COMPONENT_TYPE
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

IEEE_COMPONENT_TYPE.IEE_CMPNT_TYPE_PK Index Columns

ColumnName Sort Order

CMPNT_ID Ascending

IEEE_COMPONENT_TYPE.IEE_CMPNT_TYPE_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 120

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IEEE_COMPONENT_TYPE.IEE_CMPNT_TYPE_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IEEE_COMPONENT_TYPE.IEE_CMPNT_TYPE_PK Bound Attachments

Name Current Value

INVALID_DVC.PK_INVALID_DVC

TableName	INVALID_DVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

INVALID_DVC.PK_INVALID_DVC Index Columns

ColumnName Sort Order

DVC_ID Ascending

INVALID_DVC.PK_INVALID_DVC Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

INVALID_DVC.PK_INVALID_DVC Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

INVALID_DVC.PK_INVALID_DVC Bound Attachments

Name Current Value

IOC_BOOT_HIST.PK_IOC_BOOT_HIST

TableName	IOC_BOOT_HIST
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

IOC_BOOT_HIST.PK_IOC_BOOT_HIST Index Columns

ColumnName Sort Order

DVC_ID Ascending

BOOT_DTE Ascending

IOC_BOOT_HIST.PK_IOC_BOOT_HIST Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IOC_BOOT_HIST.PK_IOC_BOOT_HIST Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IOC_BOOT_HIST.PK_IOC_BOOT_HIST Bound Attachments

Name Current Value

IOC_CONFIG_FILE.PK_IOC_CONFIG_FILE

TableName	IOC_CONFIG_FILE
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

IOC_CONFIG_FILE.PK_IOC_CONFIG_FILE Index Columns

ColumnName Sort Order

DVC_ID Ascending

CONFIG_FILE_NM Ascending

IOC_CONFIG_FILE.PK_IOC_CONFIG_FILE Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IOC_CONFIG_FILE.PK_IOC_CONFIG_FILE Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IOC_CONFIG_FILE.PK_IOC_CONFIG_FILE Bound Attachments

Name Current Value

IOC_CONFIG_FILE.UNQ_IOC_CONFIG_FILE

TableName	IOC_CONFIG_FILE
Physical Only	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	Unique Constraint
DDL Code

IOC_CONFIG_FILE.UNQ_IOC_CONFIG_FILE Index Columns

ColumnName Sort Order

CONFIG_FILE_NBR Ascending

IOC_CONFIG_FILE.UNQ_IOC_CONFIG_FILE Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IOC_CONFIG_FILE.UNQ_IOC_CONFIG_FILE Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IOC_CONFIG_FILE.UNQ_IOC_CONFIG_FILE Bound Attachments

Name Current Value

IOC_CONFIG_FILE_HIST.PK_IOC_CONFIG_FILE_HIST

TableName	IOC_CONFIG_FILE_HIST
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

IOC_CONFIG_FILE_HIST.PK_IOC_CONFIG_FILE_HIST Index Columns

ColumnName Sort Order

DVC_ID Ascending

CONFIG_FILE_NM Ascending

MOD_DTE Ascending

IOC_CONFIG_FILE_HIST.PK_IOC_CONFIG_FILE_HIST Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IOC_CONFIG_FILE_HIST.PK_IOC_CONFIG_FILE_HIST Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IOC_CONFIG_FILE_HIST.PK_IOC_CONFIG_FILE_HIST Bound Attachments

Name Current Value

IOC_CONFIG_TYPE.SYS_C0031346

TableName	IOC_CONFIG_TYPE
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

IOC_CONFIG_TYPE.SYS_C0031346 Index Columns

ColumnName Sort Order

IOC_CONFIG_TYPE_ID Ascending

IOC_CONFIG_TYPE.SYS_C0031346 Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IOC_CONFIG_TYPE.SYS_C0031346 Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IOC_CONFIG_TYPE.SYS_C0031346 Bound Attachments

Name Current Value

IOC_DB_FILE_ASGN.IOC_DB_FILE_ASGN_PK

TableName	IOC_DB_FILE_ASGN
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

IOC_DB_FILE_ASGN.IOC_DB_FILE_ASGN_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

EXT_SRC_FILE_NM Ascending

IOC_DB_FILE_ASGN.IOC_DB_FILE_ASGN_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IOC_DB_FILE_ASGN.IOC_DB_FILE_ASGN_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IOC_DB_FILE_ASGN.IOC_DB_FILE_ASGN_PK Bound Attachments

Name Current Value

IOC_DB_FILE_ASGN_SGNL.IOC_DB_FILE_ASGN_SGNL_PK

TableName	IOC_DB_FILE_ASGN_SGNL
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

IOC_DB_FILE_ASGN_SGNL.IOC_DB_FILE_ASGN_SGNL_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

EXT_SRC_FILE_NM Ascending

SGNL_ID Ascending

IOC_DB_FILE_ASGN_SGNL.IOC_DB_FILE_ASGN_SGNL_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IOC_DB_FILE_ASGN_SGNL.IOC_DB_FILE_ASGN_SGNL_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IOC_DB_FILE_ASGN_SGNL.IOC_DB_FILE_ASGN_SGNL_PK Bound Attachments

Name Current Value

IOC_DBD_FILE_ASGN.PK_IOC_DBD_FILE_ASGN

TableName	IOC_DBD_FILE_ASGN
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

IOC_DBD_FILE_ASGN.PK_IOC_DBD_FILE_ASGN Index Columns

ColumnName Sort Order

DVC_ID Ascending

EXT_SRC_FILE_NM Ascending

IOC_DBD_FILE_ASGN.PK_IOC_DBD_FILE_ASGN Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IOC_DBD_FILE_ASGN.PK_IOC_DBD_FILE_ASGN Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IOC_DBD_FILE_ASGN.PK_IOC_DBD_FILE_ASGN Bound Attachments

Name Current Value

IOC_DIAG_CONFIG_FILE_HIST.IOC_DIAG_CONFIG_FILE_HIST_PK

TableName	IOC_DIAG_CONFIG_FILE_HIST
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

IOC_DIAG_CONFIG_FILE_HIST.IOC_DIAG_CONFIG_FILE_HIST_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

DIAG_CONFIG_FILE_NM Ascending

MOD_DTE Ascending

IOC_DIAG_CONFIG_FILE_HIST.IOC_DIAG_CONFIG_FILE_HIST_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IOC_DIAG_CONFIG_FILE_HIST.IOC_DIAG_CONFIG_FILE_HIST_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IOC_DIAG_CONFIG_FILE_HIST.IOC_DIAG_CONFIG_FILE_HIST_PK Bound Attachments

Name Current Value

IOC_DVC.IDX_IOC_NET_NM

TableName	IOC_DVC
Physical Only	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE UNIQUE INDEX EPICS.IDX_IOC_NET_NM ON EPICS.IOC_DVC(IOC_NET_NM) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

IOC_DVC.IDX_IOC_NET_NM Index Columns

ColumnName Sort Order

IOC_NET_NM Ascending

IOC_DVC.IDX_IOC_NET_NM Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IOC_DVC.IDX_IOC_NET_NM Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IOC_DVC.IDX_IOC_NET_NM Bound Attachments

Name Current Value

IOC_DVC.IOC_DVC_PK

TableName	IOC_DVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

IOC_DVC.IOC_DVC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

IOC_DVC.IOC_DVC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging NotLogged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IOC_DVC.IOC_DVC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IOC_DVC.IOC_DVC_PK Bound Attachments

Name Current Value

IOC_DVC.UPPER_IOC_DVC_ID_IDX

TableName	IOC_DVC
Physical Only	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE INDEX EPICS.UPPER_IOC_DVC_ID_IDX ON EPICS.IOC_DVC(UPPER("DVC_ID")) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

IOC_DVC.UPPER_IOC_DVC_ID_IDX Index Columns

ColumnName Sort Order

UPPER("DVC_ID")

IOC_DVC.UPPER_IOC_DVC_ID_IDX Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IOC_DVC.UPPER_IOC_DVC_ID_IDX Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IOC_DVC.UPPER_IOC_DVC_ID_IDX Bound Attachments

Name Current Value

IOC_DVC_ASGN.IOC_DVC_ASGN_PK

TableName	IOC_DVC_ASGN
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

IOC_DVC_ASGN.IOC_DVC_ASGN_PK Index Columns

ColumnName Sort Order

IOC_DVC_ID Ascending

DVC_ID Ascending

IOC_DVC_ASGN.IOC_DVC_ASGN_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IOC_DVC_ASGN.IOC_DVC_ASGN_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IOC_DVC_ASGN.IOC_DVC_ASGN_PK Bound Attachments

Name Current Value

IOC_ERROR_LOG.NONUNQ_IOC_ERROR_LOG

TableName	IOC_ERROR_LOG
Physical Only	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE INDEX EPICS.NONUNQ_IOC_ERROR_LOG ON EPICS.IOC_ERROR_LOG(DVC_ID, ERROR_LOG_FILE_DTE) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

IOC_ERROR_LOG.NONUNQ_IOC_ERROR_LOG Index Columns

ColumnName Sort Order

DVC_ID Ascending

ERROR_LOG_FILE_DTE Ascending

IOC_ERROR_LOG.NONUNQ_IOC_ERROR_LOG Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IOC_ERROR_LOG.NONUNQ_IOC_ERROR_LOG Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IOC_ERROR_LOG.NONUNQ_IOC_ERROR_LOG Bound Attachments

Name Current Value

IOC_SFTW.PK_IOC_SFTW

TableName	IOC_SFTW
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

IOC_SFTW.PK_IOC_SFTW Index Columns

ColumnName Sort Order

DVC_ID Ascending

BOOT_DTE Ascending

SFTW_NM Ascending

EPICS_VER Ascending

IOC_SFTW.PK_IOC_SFTW Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IOC_SFTW.PK_IOC_SFTW Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IOC_SFTW.PK_IOC_SFTW Bound Attachments

Name Current Value

IOC_SFTW_MOD.PK_IOC_SFTW_MOD

TableName	IOC_SFTW_MOD
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

IOC_SFTW_MOD.PK_IOC_SFTW_MOD Index Columns

ColumnName Sort Order

SFTW_NM Ascending

EPICS_VER Ascending

IOC_SFTW_MOD.PK_IOC_SFTW_MOD Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

IOC_SFTW_MOD.PK_IOC_SFTW_MOD Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

IOC_SFTW_MOD.PK_IOC_SFTW_MOD Bound Attachments

Name Current Value

JERI_USR_PROP.JERI_USR_PROP_IDX

TableName	JERI_USR_PROP
Physical Only	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE INDEX EPICS.JERI_USR_PROP_IDX ON EPICS.JERI_USR_PROP(USERID, PROP_CD) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

JERI_USR_PROP.JERI_USR_PROP_IDX Index Columns

ColumnName Sort Order

USERID Ascending

PROP_CD Ascending

JERI_USR_PROP.JERI_USR_PROP_IDX Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

JERI_USR_PROP.JERI_USR_PROP_IDX Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

JERI_USR_PROP.JERI_USR_PROP_IDX Bound Attachments

Name Current Value

LTLCH_DVC.LTLCH_DVC_PK

TableName	LTLCH_DVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

LTLCH_DVC.LTLCH_DVC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

LTLCH_DVC.LTLCH_DVC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

LTLCH_DVC.LTLCH_DVC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

LTLCH_DVC.LTLCH_DVC_PK Bound Attachments

Name Current Value

MACH_SNAPSHOT.MACH_SNAPSHOT_PK

TableName	MACH_SNAPSHOT
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MACH_SNAPSHOT.MACH_SNAPSHOT_PK Index Columns

ColumnName Sort Order

SNAPSHOT_ID Ascending

MACH_SNAPSHOT.MACH_SNAPSHOT_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MACH_SNAPSHOT.MACH_SNAPSHOT_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MACH_SNAPSHOT.MACH_SNAPSHOT_PK Bound Attachments

Name Current Value

MACH_SNAPSHOT.MACH_SNAPSHOT_TYPE_NM_DATE_IDX

TableName	MACH_SNAPSHOT
Physical Only	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE INDEX EPICS.MACH_SNAPSHOT_TYPE_NM_DATE_IDX ON EPICS.MACH_SNAPSHOT(SNAPSHOT_TYPE_NM, SNAPSHOT_DTE) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 102400K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

MACH_SNAPSHOT.MACH_SNAPSHOT_TYPE_NM_DATE_IDX Index Columns

ColumnName Sort Order

SNAPSHOT_TYPE_NM Ascending

SNAPSHOT_DTE Ascending

MACH_SNAPSHOT.MACH_SNAPSHOT_TYPE_NM_DATE_IDX Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 102400

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MACH_SNAPSHOT.MACH_SNAPSHOT_TYPE_NM_DATE_IDX Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MACH_SNAPSHOT.MACH_SNAPSHOT_TYPE_NM_DATE_IDX Bound Attachments

Name Current Value

MACH_SNAPSHOT_PER.MACH_SNAPSHOT_PER_PK

TableName	MACH_SNAPSHOT_PER
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MACH_SNAPSHOT_PER.MACH_SNAPSHOT_PER_PK Index Columns

ColumnName Sort Order

SNAPSHOT_PER Ascending

MACH_SNAPSHOT_PER.MACH_SNAPSHOT_PER_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MACH_SNAPSHOT_PER.MACH_SNAPSHOT_PER_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MACH_SNAPSHOT_PER.MACH_SNAPSHOT_PER_PK Bound Attachments

Name Current Value

MACH_SNAPSHOT_RETENT.MACH_SNAPSHOT_RETENT_PK

TableName	MACH_SNAPSHOT_RETENT
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MACH_SNAPSHOT_RETENT.MACH_SNAPSHOT_RETENT_PK Index Columns

ColumnName Sort Order

SNAPSHOT_RETENT Ascending

MACH_SNAPSHOT_RETENT.MACH_SNAPSHOT_RETENT_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MACH_SNAPSHOT_RETENT.MACH_SNAPSHOT_RETENT_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MACH_SNAPSHOT_RETENT.MACH_SNAPSHOT_RETENT_PK Bound Attachments

Name Current Value

MACH_SNAPSHOT_SGNL.MACH_SNAPSHOT_SGNL_PK

TableName	MACH_SNAPSHOT_SGNL
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MACH_SNAPSHOT_SGNL.MACH_SNAPSHOT_SGNL_PK Index Columns

ColumnName Sort Order

SNAPSHOT_ID Ascending

SGNL_ID Ascending

MACH_SNAPSHOT_SGNL.MACH_SNAPSHOT_SGNL_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging NotLogged

Parallel YES

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MACH_SNAPSHOT_SGNL.MACH_SNAPSHOT_SGNL_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MACH_SNAPSHOT_SGNL.MACH_SNAPSHOT_SGNL_PK Bound Attachments

Name Current Value

MACH_SNAPSHOT_SGNL_PERM_RET.PK_MACH_SNAPSHOT_SGNL_PERM_RET

TableName	MACH_SNAPSHOT_SGNL_PERM_RET
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MACH_SNAPSHOT_SGNL_PERM_RET.PK_MACH_SNAPSHOT_SGNL_PERM_RET Index Columns

ColumnName Sort Order

SNAPSHOT_ID Ascending

SGNL_ID Ascending

MACH_SNAPSHOT_SGNL_PERM_RET.PK_MACH_SNAPSHOT_SGNL_PERM_RET Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MACH_SNAPSHOT_SGNL_PERM_RET.PK_MACH_SNAPSHOT_SGNL_PERM_RET Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MACH_SNAPSHOT_SGNL_PERM_RET.PK_MACH_SNAPSHOT_SGNL_PERM_RET Bound Attachments

Name Current Value

MACH_SNAPSHOT_SVC.PK_MACH_SNAPSHOT_SVC

TableName	MACH_SNAPSHOT_SVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MACH_SNAPSHOT_SVC.PK_MACH_SNAPSHOT_SVC Index Columns

ColumnName Sort Order

SVC_ID Ascending

MACH_SNAPSHOT_SVC.PK_MACH_SNAPSHOT_SVC Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MACH_SNAPSHOT_SVC.PK_MACH_SNAPSHOT_SVC Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MACH_SNAPSHOT_SVC.PK_MACH_SNAPSHOT_SVC Bound Attachments

Name Current Value

MACH_SNAPSHOT_TYPE.MACH_SNAPSHOT_TYPE_PK

TableName	MACH_SNAPSHOT_TYPE
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MACH_SNAPSHOT_TYPE.MACH_SNAPSHOT_TYPE_PK Index Columns

ColumnName Sort Order

SNAPSHOT_TYPE_NM Ascending

MACH_SNAPSHOT_TYPE.MACH_SNAPSHOT_TYPE_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MACH_SNAPSHOT_TYPE.MACH_SNAPSHOT_TYPE_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MACH_SNAPSHOT_TYPE.MACH_SNAPSHOT_TYPE_PK Bound Attachments

Name Current Value

MACH_SNAPSHOT_TYPE_SGNL.MACH_SNAPSHOT_TYPE_SGNL_PK

TableName	MACH_SNAPSHOT_TYPE_SGNL
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MACH_SNAPSHOT_TYPE_SGNL.MACH_SNAPSHOT_TYPE_SGNL_PK Index Columns

ColumnName Sort Order

SNAPSHOT_TYPE_NM Ascending

SGNL_ID Ascending

MACH_SNAPSHOT_TYPE_SGNL.MACH_SNAPSHOT_TYPE_SGNL_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MACH_SNAPSHOT_TYPE_SGNL.MACH_SNAPSHOT_TYPE_SGNL_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MACH_SNAPSHOT_TYPE_SGNL.MACH_SNAPSHOT_TYPE_SGNL_PK Bound Attachments

Name Current Value

MACHINE_MODE.MACHINE_MODE_PK

TableName	MACHINE_MODE
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MACHINE_MODE.MACHINE_MODE_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

APPR_DTE Ascending

CHANNEL_NBR Ascending

MACHINE_MODE.MACHINE_MODE_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MACHINE_MODE.MACHINE_MODE_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MACHINE_MODE.MACHINE_MODE_PK Bound Attachments

Name Current Value

MACHINE_MODE.MACHINE_MODE_MPS_DVC_ID_IDX

TableName	MACHINE_MODE
Physical Only	NO
PK/UK Constraint Name	MPS_DVC_ID_UNQ
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	Unique Constraint
DDL Code

MACHINE_MODE.MACHINE_MODE_MPS_DVC_ID_IDX Index Columns

ColumnName Sort Order

MPS_DVC_ID Ascending

MACHINE_MODE.MACHINE_MODE_MPS_DVC_ID_IDX Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MACHINE_MODE.MACHINE_MODE_MPS_DVC_ID_IDX Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MACHINE_MODE.MACHINE_MODE_MPS_DVC_ID_IDX Bound Attachments

Name Current Value

MACHINE_MODE.MACH_MODE_CHAN_IN_USE_IND_IDX

TableName	MACHINE_MODE
Physical Only	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE BITMAP INDEX EPICS.MACH_MODE_CHAN_IN_USE_IND_IDX ON EPICS.MACHINE_MODE(CHAN_IN_USE_IND) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

MACHINE_MODE.MACH_MODE_CHAN_IN_USE_IND_IDX Index Columns

ColumnName Sort Order

CHAN_IN_USE_IND Ascending

MACHINE_MODE.MACH_MODE_CHAN_IN_USE_IND_IDX Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type Bitmap

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MACHINE_MODE.MACH_MODE_CHAN_IN_USE_IND_IDX Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MACHINE_MODE.MACH_MODE_CHAN_IN_USE_IND_IDX Bound Attachments

Name Current Value

MACHINE_MODE_DEF_MASK.MACHINE_MODE_DEF_MASK_PK

TableName	MACHINE_MODE_DEF_MASK
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MACHINE_MODE_DEF_MASK.MACHINE_MODE_DEF_MASK_PK Index Columns

ColumnName Sort Order

DVC_TYPE_ID Ascending

MACHINE_MODE_DEF_MASK.MACHINE_MODE_DEF_MASK_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MACHINE_MODE_DEF_MASK.MACHINE_MODE_DEF_MASK_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MACHINE_MODE_DEF_MASK.MACHINE_MODE_DEF_MASK_PK Bound Attachments

Name Current Value

MAG_DVC.MAG_DVC_PK

TableName	MAG_DVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MAG_DVC.MAG_DVC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

MAG_DVC.MAG_DVC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MAG_DVC.MAG_DVC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MAG_DVC.MAG_DVC_PK Bound Attachments

Name Current Value

MESSAGE.PK_MESSAGE

TableName	MESSAGE
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MESSAGE.PK_MESSAGE Index Columns

ColumnName Sort Order

ID Ascending

MESSAGE.PK_MESSAGE Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE

PctFree

MinExtents

MaxExtents

Initial

Next

PctIncrease

InitTrans

MaxTrans

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS

FREELIST GROUPS

Buffer Pool

Index Compression NO

MESSAGE.PK_MESSAGE Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MESSAGE.PK_MESSAGE Bound Attachments

Name Current Value

MESSAGE_CONTENT.PK_MESSAGE_CONTENT

TableName	MESSAGE_CONTENT
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MESSAGE_CONTENT.PK_MESSAGE_CONTENT Index Columns

ColumnName Sort Order

ID Ascending

MESSAGE_CONTENT.PK_MESSAGE_CONTENT Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE

PctFree

MinExtents

MaxExtents

Initial

Next

PctIncrease

InitTrans

MaxTrans

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS

FREELIST GROUPS

Buffer Pool

Index Compression NO

MESSAGE_CONTENT.PK_MESSAGE_CONTENT Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MESSAGE_CONTENT.PK_MESSAGE_CONTENT Bound Attachments

Name Current Value

MPS_AUDIT_ERR_MSG.PK_MPS_AUDIT_ERR_MSG

TableName	MPS_AUDIT_ERR_MSG
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MPS_AUDIT_ERR_MSG.PK_MPS_AUDIT_ERR_MSG Index Columns

ColumnName Sort Order

ERR_NBR Ascending

MPS_AUDIT_ERR_MSG.PK_MPS_AUDIT_ERR_MSG Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MPS_AUDIT_ERR_MSG.PK_MPS_AUDIT_ERR_MSG Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MPS_AUDIT_ERR_MSG.PK_MPS_AUDIT_ERR_MSG Bound Attachments

Name Current Value

MPS_CHAIN.MPS_CHAIN_PK

TableName	MPS_CHAIN
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MPS_CHAIN.MPS_CHAIN_PK Index Columns

ColumnName Sort Order

MPS_CHAIN_ID Ascending

MPS_CHAIN.MPS_CHAIN_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MPS_CHAIN.MPS_CHAIN_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MPS_CHAIN.MPS_CHAIN_PK Bound Attachments

Name Current Value

MPS_CHAN_AUDIT.PK_MPS_CHAN_AUDIT

TableName	MPS_CHAN_AUDIT
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MPS_CHAN_AUDIT.PK_MPS_CHAN_AUDIT Index Columns

ColumnName Sort Order

DVC_ID Ascending

APPR_DTE Ascending

CHANNEL_NBR Ascending

AUDIT_DTE Ascending

MPS_CHAN_AUDIT.PK_MPS_CHAN_AUDIT Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MPS_CHAN_AUDIT.PK_MPS_CHAN_AUDIT Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MPS_CHAN_AUDIT.PK_MPS_CHAN_AUDIT Bound Attachments

Name Current Value

MPS_CHASSIS_SER_NBR.PK_MPS_CHASIS_SER_NBR

TableName	MPS_CHASSIS_SER_NBR
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MPS_CHASSIS_SER_NBR.PK_MPS_CHASIS_SER_NBR Index Columns

ColumnName Sort Order

SER_NBR Ascending

MPS_CHASSIS_SER_NBR.PK_MPS_CHASIS_SER_NBR Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MPS_CHASSIS_SER_NBR.PK_MPS_CHASIS_SER_NBR Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MPS_CHASSIS_SER_NBR.PK_MPS_CHASIS_SER_NBR Bound Attachments

Name Current Value

MPS_DAILY_STAT.MPS_DAILY_STAT_PK

TableName	MPS_DAILY_STAT
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MPS_DAILY_STAT.MPS_DAILY_STAT_PK Index Columns

ColumnName Sort Order

SGNL_ID Ascending

MPS_INP_SGNL_ID Ascending

CUR_DTE Ascending

MPS_DAILY_STAT.MPS_DAILY_STAT_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MPS_DAILY_STAT.MPS_DAILY_STAT_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MPS_DAILY_STAT.MPS_DAILY_STAT_PK Bound Attachments

Name Current Value

MPS_PROP.MPS_PROP_PK

TableName	MPS_PROP
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name	PK_MPS_PROP
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MPS_PROP.MPS_PROP_PK Index Columns

ColumnName Sort Order

EPICS_VER Ascending

OS_ID Ascending

MPS_PROP.MPS_PROP_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MPS_PROP.MPS_PROP_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MPS_PROP.MPS_PROP_PK Bound Attachments

Name Current Value

MPS_SGNL_PARAM.MPS_SGNL_PARAM_PK

TableName	MPS_SGNL_PARAM
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MPS_SGNL_PARAM.MPS_SGNL_PARAM_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

APPR_DTE Ascending

MPS_SGNL_PARAM.MPS_SGNL_PARAM_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

MPS_SGNL_PARAM.MPS_SGNL_PARAM_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MPS_SGNL_PARAM.MPS_SGNL_PARAM_PK Bound Attachments

Name Current Value

MSG_PROPERTY_TYPE.PK_MSG_PROPERTY_TYPE

TableName	MSG_PROPERTY_TYPE
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MSG_PROPERTY_TYPE.PK_MSG_PROPERTY_TYPE Index Columns

ColumnName Sort Order

ID Ascending

MSG_PROPERTY_TYPE.PK_MSG_PROPERTY_TYPE Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE

PctFree

MinExtents

MaxExtents

Initial

Next

PctIncrease

InitTrans

MaxTrans

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS

FREELIST GROUPS

Buffer Pool

Index Compression NO

MSG_PROPERTY_TYPE.PK_MSG_PROPERTY_TYPE Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MSG_PROPERTY_TYPE.PK_MSG_PROPERTY_TYPE Bound Attachments

Name Current Value

MSG_TYPE.PK_MSG_TYPE

TableName	MSG_TYPE
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MSG_TYPE.PK_MSG_TYPE Index Columns

ColumnName Sort Order

ID Ascending

MSG_TYPE.PK_MSG_TYPE Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE

PctFree

MinExtents

MaxExtents

Initial

Next

PctIncrease

InitTrans

MaxTrans

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS

FREELIST GROUPS

Buffer Pool

Index Compression NO

MSG_TYPE.PK_MSG_TYPE Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MSG_TYPE.PK_MSG_TYPE Bound Attachments

Name Current Value

MSG_TYPE_PROPERTY_TYPE.PK_MSG_TYPE_PROPERTY_TYPE

TableName	MSG_TYPE_PROPERTY_TYPE
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

MSG_TYPE_PROPERTY_TYPE.PK_MSG_TYPE_PROPERTY_TYPE Index Columns

ColumnName Sort Order

ID Ascending

MSG_TYPE_PROPERTY_TYPE.PK_MSG_TYPE_PROPERTY_TYPE Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE

PctFree

MinExtents

MaxExtents

Initial

Next

PctIncrease

InitTrans

MaxTrans

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS

FREELIST GROUPS

Buffer Pool

Index Compression NO

MSG_TYPE_PROPERTY_TYPE.PK_MSG_TYPE_PROPERTY_TYPE Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

MSG_TYPE_PROPERTY_TYPE.PK_MSG_TYPE_PROPERTY_TYPE Bound Attachments

Name Current Value

PS_DVC.PS_DVC_PK

TableName	PS_DVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

PS_DVC.PS_DVC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

PS_DVC.PS_DVC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging NotLogged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

PS_DVC.PS_DVC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

PS_DVC.PS_DVC_PK Bound Attachments

Name Current Value

PSC_DVC.PSC_DVC_PK

TableName	PSC_DVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

PSC_DVC.PSC_DVC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

PSC_DVC.PSC_DVC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

PSC_DVC.PSC_DVC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

PSC_DVC.PSC_DVC_PK Bound Attachments

Name Current Value

PSI_DVC.PSI_DVC_PK

TableName	PSI_DVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

PSI_DVC.PSI_DVC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

PSI_DVC.PSI_DVC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

PSI_DVC.PSI_DVC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

PSI_DVC.PSI_DVC_PK Bound Attachments

Name Current Value

PV_SNAPSHOT_GRP.PK_PV_SNAPSHOT_GRP

TableName	PV_SNAPSHOT_GRP
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

PV_SNAPSHOT_GRP.PK_PV_SNAPSHOT_GRP Index Columns

ColumnName Sort Order

MOD_DTE Ascending

PV_SNAPSHOT_GRP.PK_PV_SNAPSHOT_GRP Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

PV_SNAPSHOT_GRP.PK_PV_SNAPSHOT_GRP Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

PV_SNAPSHOT_GRP.PK_PV_SNAPSHOT_GRP Bound Attachments

Name Current Value

PV_SNAPSHOT_GRP_SGNL.PK_PV_SNAPSHOT_GRP_SGNL

TableName	PV_SNAPSHOT_GRP_SGNL
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

PV_SNAPSHOT_GRP_SGNL.PK_PV_SNAPSHOT_GRP_SGNL Index Columns

ColumnName Sort Order

MOD_DTE Ascending

SGNL_ID Ascending

PV_SNAPSHOT_GRP_SGNL.PK_PV_SNAPSHOT_GRP_SGNL Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE

PctFree

MinExtents

MaxExtents

Initial

Next

PctIncrease

InitTrans

MaxTrans

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS

FREELIST GROUPS

Buffer Pool

Index Compression NO

PV_SNAPSHOT_GRP_SGNL.PK_PV_SNAPSHOT_GRP_SGNL Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

PV_SNAPSHOT_GRP_SGNL.PK_PV_SNAPSHOT_GRP_SGNL Bound Attachments

Name Current Value

PV_SNAPSHOT_SGNL.PK_PV_SNAPSHOT_SGNL

TableName	PV_SNAPSHOT_SGNL
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

PV_SNAPSHOT_SGNL.PK_PV_SNAPSHOT_SGNL Index Columns

ColumnName Sort Order

MOD_DTE Ascending

SGNL_ID Ascending

ITEM_NBR Ascending

PV_SNAPSHOT_SGNL.PK_PV_SNAPSHOT_SGNL Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE

PctFree

MinExtents

MaxExtents

Initial

Next

PctIncrease

InitTrans

MaxTrans

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS

FREELIST GROUPS

Buffer Pool

Index Compression NO

PV_SNAPSHOT_SGNL.PK_PV_SNAPSHOT_SGNL Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

PV_SNAPSHOT_SGNL.PK_PV_SNAPSHOT_SGNL Bound Attachments

Name Current Value

RACK_PROFILE_COUNTS.RACK_PROFILE_COUNTS_IND1

TableName	RACK_PROFILE_COUNTS
Physical Only	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE INDEX OPS$ORACLE.RACK_PROFILE_COUNTS_IND1 ON OPS$ORACLE.RACK_PROFILE_COUNTS(EQUIP_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE OPS_ORACLE_TS LOGGING STORAGE(INITIAL 512K NEXT 512K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

RACK_PROFILE_COUNTS.RACK_PROFILE_COUNTS_IND1 Index Columns

ColumnName Sort Order

EQUIP_ID Ascending

RACK_PROFILE_COUNTS.RACK_PROFILE_COUNTS_IND1 Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE OPS_ORACLE_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 512

Next 512

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

RACK_PROFILE_COUNTS.RACK_PROFILE_COUNTS_IND1 Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

RACK_PROFILE_COUNTS.RACK_PROFILE_COUNTS_IND1 Bound Attachments

Name Current Value

RESP_ENGR.RESP_ENGR_PK

TableName	RESP_ENGR
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

RESP_ENGR.RESP_ENGR_PK Index Columns

ColumnName Sort Order

SUBSYS_ID Ascending

RESP_ENGR.RESP_ENGR_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

RESP_ENGR.RESP_ENGR_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

RESP_ENGR.RESP_ENGR_PK Bound Attachments

Name Current Value

RF_CAV_DVC.RF_CAVITY_DVC_PK

TableName	RF_CAV_DVC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

RF_CAV_DVC.RF_CAVITY_DVC_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

RF_CAV_DVC.RF_CAVITY_DVC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

RF_CAV_DVC.RF_CAVITY_DVC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

RF_CAV_DVC.RF_CAVITY_DVC_PK Bound Attachments

Name Current Value

RF_CAV_TRIP.PK_RF_CAV_TRIP

TableName	RF_CAV_TRIP
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

RF_CAV_TRIP.PK_RF_CAV_TRIP Index Columns

ColumnName Sort Order

SGNL_ID Ascending

CUR_DTE Ascending

RF_CAV_TRIP.PK_RF_CAV_TRIP Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE

PctFree

MinExtents

MaxExtents

Initial

Next

PctIncrease

InitTrans

MaxTrans

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS

FREELIST GROUPS

Buffer Pool

Index Compression NO

RF_CAV_TRIP.PK_RF_CAV_TRIP Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

RF_CAV_TRIP.PK_RF_CAV_TRIP Bound Attachments

Name Current Value

RF_GAP.RF_GAP_PK

TableName	RF_GAP
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

RF_GAP.RF_GAP_PK Index Columns

ColumnName Sort Order

DVC_ID Ascending

RF_GAP_ID Ascending

RF_GAP.RF_GAP_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

RF_GAP.RF_GAP_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

RF_GAP.RF_GAP_PK Bound Attachments

Name Current Value

SCENARIO_TYPE.SCENARIO_TYPE_PK

TableName	SCENARIO_TYPE
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

SCENARIO_TYPE.SCENARIO_TYPE_PK Index Columns

ColumnName Sort Order

SCENARIO_ID Ascending

SCENARIO_TYPE.SCENARIO_TYPE_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SCENARIO_TYPE.SCENARIO_TYPE_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SCENARIO_TYPE.SCENARIO_TYPE_PK Bound Attachments

Name Current Value

SCORE_SNAPSHOT_GRP.PK_SCORE_SNAPSHOT_GRP

TableName	SCORE_SNAPSHOT_GRP
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

SCORE_SNAPSHOT_GRP.PK_SCORE_SNAPSHOT_GRP Index Columns

ColumnName Sort Order

EQUIP_CAT_ID Ascending

MOD_DTE Ascending

SCORE_SNAPSHOT_GRP.PK_SCORE_SNAPSHOT_GRP Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SCORE_SNAPSHOT_GRP.PK_SCORE_SNAPSHOT_GRP Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SCORE_SNAPSHOT_GRP.PK_SCORE_SNAPSHOT_GRP Bound Attachments

Name Current Value

SCORE_SNAPSHOT_GRP_SGNL.PK_SCORE_SNAPSHOT_GRP_SGNL

TableName	SCORE_SNAPSHOT_GRP_SGNL
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

SCORE_SNAPSHOT_GRP_SGNL.PK_SCORE_SNAPSHOT_GRP_SGNL Index Columns

ColumnName Sort Order

EQUIP_CAT_ID Ascending

SET_PT_SGNL_ID Ascending

RB_SGNL_ID Ascending

SCORE_SNAPSHOT_GRP_SGNL.PK_SCORE_SNAPSHOT_GRP_SGNL Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SCORE_SNAPSHOT_GRP_SGNL.PK_SCORE_SNAPSHOT_GRP_SGNL Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SCORE_SNAPSHOT_GRP_SGNL.PK_SCORE_SNAPSHOT_GRP_SGNL Bound Attachments

Name Current Value

SCORE_SNAPSHOT_SGNL.PK_SCORE_SNAPSHOT_SGNL

TableName	SCORE_SNAPSHOT_SGNL
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

SCORE_SNAPSHOT_SGNL.PK_SCORE_SNAPSHOT_SGNL Index Columns

ColumnName Sort Order

EQUIP_CAT_ID Ascending

MOD_DTE Ascending

SET_PT_SGNL_ID Ascending

RB_SGNL_ID Ascending

SCORE_SNAPSHOT_SGNL.PK_SCORE_SNAPSHOT_SGNL Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SCORE_SNAPSHOT_SGNL.PK_SCORE_SNAPSHOT_SGNL Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SCORE_SNAPSHOT_SGNL.PK_SCORE_SNAPSHOT_SGNL Bound Attachments

Name Current Value

SETTING_TYPE.SETTING_TYPE_PK

TableName	SETTING_TYPE
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

SETTING_TYPE.SETTING_TYPE_PK Index Columns

ColumnName Sort Order

SETTING_ID Ascending

SETTING_TYPE.SETTING_TYPE_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SETTING_TYPE.SETTING_TYPE_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SETTING_TYPE.SETTING_TYPE_PK Bound Attachments

Name Current Value

SGNL.SGNL_PK

TableName	SGNL
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

SGNL.SGNL_PK Index Columns

ColumnName Sort Order

SGNL_ID Ascending

DVC_ID Ascending

SGNL.SGNL_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SGNL.SGNL_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SGNL.SGNL_PK Bound Attachments

Name Current Value

SGNL_FLD.PK_SGNL_FLD

TableName	SGNL_FLD
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

SGNL_FLD.PK_SGNL_FLD Index Columns

ColumnName Sort Order

SGNL_ID Ascending

REC_TYPE_ID Ascending

FLD_ID Ascending

IOC_DVC_ID Ascending

SGNL_FLD.PK_SGNL_FLD Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE

PctFree

MinExtents

MaxExtents

Initial

Next

PctIncrease

InitTrans

MaxTrans

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS

FREELIST GROUPS

Buffer Pool

Index Compression NO

SGNL_FLD.PK_SGNL_FLD Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SGNL_FLD.PK_SGNL_FLD Bound Attachments

Name Current Value

SGNL_FLD_DEF.SGNL_FLD_DEF_PK

TableName	SGNL_FLD_DEF
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

SGNL_FLD_DEF.SGNL_FLD_DEF_PK Index Columns

ColumnName Sort Order

REC_TYPE_ID Ascending

FLD_ID Ascending

SGNL_FLD_DEF.SGNL_FLD_DEF_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SGNL_FLD_DEF.SGNL_FLD_DEF_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SGNL_FLD_DEF.SGNL_FLD_DEF_PK Bound Attachments

Name Current Value

SGNL_FLD_ID.PK_SGNL_FLD_ID

TableName	SGNL_FLD_ID
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

SGNL_FLD_ID.PK_SGNL_FLD_ID Index Columns

ColumnName Sort Order

FLD_ID Ascending

SGNL_FLD_ID.PK_SGNL_FLD_ID Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SGNL_FLD_ID.PK_SGNL_FLD_ID Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SGNL_FLD_ID.PK_SGNL_FLD_ID Bound Attachments

Name Current Value

SGNL_FLD_MENU.SGNL_FLD_MENU_PK

TableName	SGNL_FLD_MENU
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

SGNL_FLD_MENU.SGNL_FLD_MENU_PK Index Columns

ColumnName Sort Order

SGNL_FLD_MENU_ID Ascending

FLD_MENU_VAL Ascending

SGNL_FLD_MENU.SGNL_FLD_MENU_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 120

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SGNL_FLD_MENU.SGNL_FLD_MENU_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SGNL_FLD_MENU.SGNL_FLD_MENU_PK Bound Attachments

Name Current Value

SGNL_GRP.SGNL_GRP_PK

TableName	SGNL_GRP
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

SGNL_GRP.SGNL_GRP_PK Index Columns

ColumnName Sort Order

SGNL_GRP_ID Ascending

SGNL_GRP.SGNL_GRP_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SGNL_GRP.SGNL_GRP_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SGNL_GRP.SGNL_GRP_PK Bound Attachments

Name Current Value

SGNL_GRP_ITEM.SGNL_GRP_ITEM_PK

TableName	SGNL_GRP_ITEM
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

SGNL_GRP_ITEM.SGNL_GRP_ITEM_PK Index Columns

ColumnName Sort Order

SGNL_GRP_ID Ascending

DVC_TYPE_ID Ascending

DVC_TYPE_SGNL_NM Ascending

SGNL_GRP_ITEM.SGNL_GRP_ITEM_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SGNL_GRP_ITEM.SGNL_GRP_ITEM_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SGNL_GRP_ITEM.SGNL_GRP_ITEM_PK 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 EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

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 EPICS.SGNL_ID_ALIAS_IDX ON EPICS.SGNL_REC(SGNL_ID_ALIAS) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

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 EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

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

SGNL_REC.SGNL_REC_DVC_ID_IDX

TableName	SGNL_REC
Physical Only	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE INDEX EPICS.SGNL_REC_DVC_ID_IDX ON EPICS.SGNL_REC(DVC_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

SGNL_REC.SGNL_REC_DVC_ID_IDX Index Columns

ColumnName Sort Order

DVC_ID Ascending

SGNL_REC.SGNL_REC_DVC_ID_IDX Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SGNL_REC.SGNL_REC_DVC_ID_IDX Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SGNL_REC.SGNL_REC_DVC_ID_IDX Bound Attachments

Name Current Value

SGNL_REC.SGNL_NM_IDX

TableName	SGNL_REC
Physical Only	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE INDEX EPICS.SGNL_NM_IDX ON EPICS.SGNL_REC(SGNL_NM) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_INDEX_TS LOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ;

SGNL_REC.SGNL_NM_IDX Index Columns

ColumnName Sort Order

SGNL_NM Ascending

SGNL_REC.SGNL_NM_IDX Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SGNL_REC.SGNL_NM_IDX Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SGNL_REC.SGNL_NM_IDX Bound Attachments

Name Current Value

SGNL_REC_ARCH.SGNL_REC_ARCH_PK

TableName	SGNL_REC_ARCH
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

SGNL_REC_ARCH.SGNL_REC_ARCH_PK Index Columns

ColumnName Sort Order

SGNL_ID Ascending

ARCH_REQ_FILE_NM Ascending

SGNL_REC_ARCH.SGNL_REC_ARCH_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SGNL_REC_ARCH.SGNL_REC_ARCH_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SGNL_REC_ARCH.SGNL_REC_ARCH_PK Bound Attachments

Name Current Value

SGNL_REC_MV.I_SNAP$_SGNL_REC_MV

TableName	SGNL_REC_MV
Physical Only	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	CREATE UNIQUE INDEX IRMISBASE.I_SNAP$_SGNL_REC_MV ON IRMISBASE.SGNL_REC_MV(SYS_OP_MAP_NONNULL("REC_NM"), SYS_OP_MAP_NONNULL("REC_TYPE")) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE IRMIS_TS LOGGING STORAGE(INITIAL 64K NEXT 256K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) ;

SGNL_REC_MV.I_SNAP$_SGNL_REC_MV Index Columns

ColumnName Sort Order

SYS_OP_MAP_NONNULL("REC_NM")

SYS_OP_MAP_NONNULL("REC_TYPE")

SGNL_REC_MV.I_SNAP$_SGNL_REC_MV Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE IRMIS_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 256

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS FreeLists

FREELIST GROUPS FreeList Groups

Buffer Pool DEFAULT

Index Compression NO

SGNL_REC_MV.I_SNAP$_SGNL_REC_MV Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SGNL_REC_MV.I_SNAP$_SGNL_REC_MV Bound Attachments

Name Current Value

SGNL_REC_MV.IDX_REC_NM

TableName	SGNL_REC_MV
Physical Only	NO
PK/UK Constraint Name
Unique	NO
Clustered Option	NON-CLUSTERED
IndexType	Index
DDL Code	`CREATE INDEX IRMISBASE.IDX_REC_NM ON IRMISBASE.SGNL_REC_MV(REC_NM) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE IRMIS_TS LOGGING STORAGE(INITIAL 64K NEXT 256K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) ;`

SGNL_REC_MV.IDX_REC_NM Index Columns

ColumnName Sort Order

REC_NM Ascending

SGNL_REC_MV.IDX_REC_NM Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE IRMIS_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 256

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS FreeLists

FREELIST GROUPS FreeList Groups

Buffer Pool DEFAULT

Index Compression NO

SGNL_REC_MV.IDX_REC_NM Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SGNL_REC_MV.IDX_REC_NM Bound Attachments

Name Current Value

SGNL_REC_TYPE.SGNL_REC_TYPE_PK

TableName	SGNL_REC_TYPE
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

SGNL_REC_TYPE.SGNL_REC_TYPE_PK Index Columns

ColumnName Sort Order

REC_TYPE_ID Ascending

SGNL_REC_TYPE.SGNL_REC_TYPE_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 120

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SGNL_REC_TYPE.SGNL_REC_TYPE_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SGNL_REC_TYPE.SGNL_REC_TYPE_PK Bound Attachments

Name Current Value

SUBSYS.SUBSYS_PK

TableName	SUBSYS
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

SUBSYS.SUBSYS_PK Index Columns

ColumnName Sort Order

SUBSYS_ID Ascending

SUBSYS.SUBSYS_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 120

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SUBSYS.SUBSYS_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SUBSYS.SUBSYS_PK Bound Attachments

Name Current Value

SYST.SYS_PK

TableName	SYST
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

SYST.SYS_PK Index Columns

ColumnName Sort Order

SYS_ID Ascending

SYST.SYS_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 16

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

SYST.SYS_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

SYST.SYS_PK Bound Attachments

Name Current Value

TEMPLATE.EXP_SRC_FILE_NM_UNQ

TableName	TEMPLATE
Physical Only	NO
PK/UK Constraint Name	EXT_SRC_FILE_NM_UNQ
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	Unique Constraint
DDL Code

TEMPLATE.EXP_SRC_FILE_NM_UNQ Index Columns

ColumnName Sort Order

EXT_SRC_FILE_NM Ascending

TEMPLATE.EXP_SRC_FILE_NM_UNQ Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

TEMPLATE.EXP_SRC_FILE_NM_UNQ Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

TEMPLATE.EXP_SRC_FILE_NM_UNQ Bound Attachments

Name Current Value

TEMPLATE.TEMPLATE_PK

TableName	TEMPLATE
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

TEMPLATE.TEMPLATE_PK Index Columns

ColumnName Sort Order

TMPL_ID Ascending

TEMPLATE.TEMPLATE_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

TEMPLATE.TEMPLATE_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

TEMPLATE.TEMPLATE_PK Bound Attachments

Name Current Value

TMPL_ARCH_REQ.TMPL_ARCH_REQ_PK

TableName	TMPL_ARCH_REQ
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

TMPL_ARCH_REQ.TMPL_ARCH_REQ_PK Index Columns

ColumnName Sort Order

TMPL_ID Ascending

ARCH_REQ_FILE_NM Ascending

TMPL_ARCH_REQ.TMPL_ARCH_REQ_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

TMPL_ARCH_REQ.TMPL_ARCH_REQ_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

TMPL_ARCH_REQ.TMPL_ARCH_REQ_PK Bound Attachments

Name Current Value

TMPL_ARCH_REQ_GRP.TMPL_ARCH_REQ_GRP_PK

TableName	TMPL_ARCH_REQ_GRP
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

TMPL_ARCH_REQ_GRP.TMPL_ARCH_REQ_GRP_PK Index Columns

ColumnName Sort Order

TMPL_ID Ascending

ARCH_REQ_GRP_FILE_NM Ascending

TMPL_ARCH_REQ_GRP.TMPL_ARCH_REQ_GRP_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

TMPL_ARCH_REQ_GRP.TMPL_ARCH_REQ_GRP_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

TMPL_ARCH_REQ_GRP.TMPL_ARCH_REQ_GRP_PK Bound Attachments

Name Current Value

TMPL_ARCH_REQ_GRP_ARCH_REQ.TMPL_ARCH_REQ_GRP_ARCH_REQ_PK

TableName	TMPL_ARCH_REQ_GRP_ARCH_REQ
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

TMPL_ARCH_REQ_GRP_ARCH_REQ.TMPL_ARCH_REQ_GRP_ARCH_REQ_PK Index Columns

ColumnName Sort Order

TMPL_ID Ascending

ARCH_REQ_GRP_FILE_NM Ascending

ARCH_REQ_FILE_NM Ascending

TMPL_ARCH_REQ_GRP_ARCH_REQ.TMPL_ARCH_REQ_GRP_ARCH_REQ_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

TMPL_ARCH_REQ_GRP_ARCH_REQ.TMPL_ARCH_REQ_GRP_ARCH_REQ_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

TMPL_ARCH_REQ_GRP_ARCH_REQ.TMPL_ARCH_REQ_GRP_ARCH_REQ_PK Bound Attachments

Name Current Value

TMPL_MACRO.TEMPLATE_MACRO_PK

TableName	TMPL_MACRO
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

TMPL_MACRO.TEMPLATE_MACRO_PK Index Columns

ColumnName Sort Order

TMPL_ID Ascending

MACRO_ID Ascending

TMPL_MACRO.TEMPLATE_MACRO_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

TMPL_MACRO.TEMPLATE_MACRO_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

TMPL_MACRO.TEMPLATE_MACRO_PK Bound Attachments

Name Current Value

TMPL_SGNL_FLD.TMPL_SGNL_FLD_PK

TableName	TMPL_SGNL_FLD
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

TMPL_SGNL_FLD.TMPL_SGNL_FLD_PK Index Columns

ColumnName Sort Order

TMPL_ID Ascending

TMPL_SGNL_ID Ascending

FLD_ID Ascending

REC_TYPE_ID Ascending

TMPL_SGNL_FLD.TMPL_SGNL_FLD_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

TMPL_SGNL_FLD.TMPL_SGNL_FLD_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

TMPL_SGNL_FLD.TMPL_SGNL_FLD_PK Bound Attachments

Name Current Value

TMPL_SGNL_REC.TMPL_SGNL_REC_PK

TableName	TMPL_SGNL_REC
Physical Only	NO
Disabled	NO
NoValidate	NO
PK/UK Constraint Name
Unique	YES
Clustered Option	NON-CLUSTERED
IndexType	PrimaryKey
DDL Code

TMPL_SGNL_REC.TMPL_SGNL_REC_PK Index Columns

ColumnName Sort Order

TMPL_ID Ascending

TMPL_SGNL_ID Ascending

REC_TYPE_ID Ascending

TMPL_SGNL_REC.TMPL_SGNL_REC_PK Properties

STORAGE OPTION STORAGE VALUE

TABLESPACE EPICS_INDEX_TS

PctFree 10

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 2

MaxTrans 255

NO SORT NO

Type B-Tree

Byte Order Forward

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Index Compression NO

TMPL_SGNL_REC.TMPL_SGNL_REC_PK Partitions

PARTITION PROPERTY PARTITION PROPERTY VALUE

TMPL_SGNL_REC.TMPL_SGNL_REC_PK Bound Attachments

Name Current Value

ColumnName	Sort Order
SGNL_ID	Ascending
MOD_DTE	Ascending

STORAGE OPTION	STORAGE VALUE
TABLESPACE	EPICS_INDEX_TS
PctFree	10
MinExtents	1
MaxExtents	2147483645
Initial	64
Next	64
PctIncrease	0
InitTrans	2
MaxTrans	255
NO SORT	NO
Type	B-Tree
Byte Order	Forward
Logging	Logged
Parallel	NO
Parallel Degrees
Parallel Instances
FREELISTS	1
FREELIST GROUPS	1
Buffer Pool	DEFAULT
Index Compression	NO

ColumnName	Sort Order
ARCH_REQ_FILE_NM	Ascending
ARCH_GRP_FILE_NM	Ascending

ColumnName	Sort Order
DVC_ID	Ascending
SCENARIO_ID	Ascending

ColumnName	Sort Order
BYPASS_NBR	Ascending
SGNL_ID	Ascending

ColumnName	Sort Order
MNFCTR_ID	Ascending
MDL_NBR	Ascending
DVC_ID	Ascending

ColumnName	Sort Order
DVC_TYPE_ID	Ascending
SFTW_ID	Ascending

ColumnName	Sort Order
IOC_DVC_ID	Ascending
DVC_ID	Ascending

ColumnName	Sort Order
SFTW_NM	Ascending
EPICS_VER	Ascending

ColumnName	Sort Order
SNAPSHOT_TYPE_NM	Ascending
SNAPSHOT_DTE	Ascending

ColumnName	Sort Order
SNAPSHOT_ID	Ascending
SGNL_ID	Ascending

ColumnName	Sort Order
EQUIP_CAT_ID	Ascending
MOD_DTE	Ascending

ColumnName	Sort Order
REC_TYPE_ID	Ascending
FLD_ID	Ascending

ColumnName	Sort Order
SGNL_FLD_MENU_ID	Ascending
FLD_MENU_VAL	Ascending

ColumnName	Sort Order
SGNL_GRP_ID	Ascending
DVC_TYPE_ID	Ascending
DVC_TYPE_SGNL_NM	Ascending

ColumnName	Sort Order
SYS_OP_MAP_NONNULL("REC_NM")
SYS_OP_MAP_NONNULL("REC_TYPE")

ColumnName	Sort Order
TMPL_ID	Ascending
ARCH_REQ_FILE_NM	Ascending