| DDL Code |
CREATE TABLE EPICS.MACHINE_MODE(
DVC_ID VARCHAR2(40) NOT NULL,
APPR_DTE DATE DEFAULT sysdate NOT NULL,
CHANNEL_NBR NUMBER(3, 0) NOT NULL,
LOCKED_IND CHAR(1) DEFAULT 'N' NOT NULL,
SW_JUMP CHAR(1) DEFAULT 'N' NOT NULL,
LIMIT NUMBER(3, 0) DEFAULT 60 NOT NULL,
RATE NUMBER(3, 0) DEFAULT 60 NOT NULL,
BEAM_OFF RAW(1),
STANDBY RAW(1),
MPS_TEST RAW(1),
MEBT_BS_10US RAW(1),
MEBT_BS_50US RAW(1),
MEBT_BS_100US RAW(1),
MEBT_BS_1MS RAW(1),
MEBT_BS_FULLPWR RAW(1),
CCL_BS_10US RAW(1),
CCL_BS_50US RAW(1),
CCL_BS_100US RAW(1),
CCL_BS_2KW RAW(1),
CCL_BS_FULLPWR RAW(1),
LDMP_10US RAW(1),
LDMP_50US RAW(1),
LDMP_100US RAW(1),
LDMP_7_5KW RAW(1),
LDMP_FULLPWR RAW(1),
IDMP_10US RAW(1),
IDMP_50US RAW(1),
IDMP_100US RAW(1),
IDMP_1MS RAW(1),
IDMP_FULLPWR RAW(1),
RING_10US RAW(1),
RING_50US RAW(1),
RING_100US RAW(1),
RING_7_5MW RAW(1),
RING_FULLPWR RAW(1),
EDMP_10US RAW(1),
EDMP_50US RAW(1),
EDMP_100US RAW(1),
EDMP_7_5MW RAW(1),
EDMP_FULLPWR RAW(1),
TARGET_10US RAW(1),
TARGET_50US RAW(1),
TARGET_100US RAW(1),
TARGET_1MS RAW(1),
TARGET_FULLPWR RAW(1),
CHASSIS_CONFIG_SW_JMP RAW(1),
MPS_DVC_ID VARCHAR2(40),
CHAN_IN_USE_IND CHAR(1) DEFAULT 'N' NOT NULL,
CONSTRAINT MACHINE_MODE_PK PRIMARY KEY (DVC_ID, APPR_DTE, CHANNEL_NBR)
USING INDEX
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
),
CONSTRAINT MPS_DVC_ID_UNQ UNIQUE (MPS_DVC_ID)
USING INDEX
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
),
CONSTRAINT MACHINE_MODE_DVC_FK FOREIGN KEY (MPS_DVC_ID)
REFERENCES EPICS.DVC(DVC_ID),
CONSTRAINT MPS_SGNL_PARAM_MACH_MODE_RF FOREIGN KEY (DVC_ID, APPR_DTE)
REFERENCES EPICS.MPS_SGNL_PARAM(DVC_ID, APPR_DTE)
)
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
TABLESPACE EPICS_TS
LOGGING
NOPARALLEL
STORAGE(INITIAL 64K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
NOCACHE
NOCOMPRESS
;
|
