| DDL Code |
CREATE TABLE MACHINE_MODE(
DVC_ID VARCHAR2(50) NOT NULL,
APPR_DTE TIMESTAMP(6) NOT NULL,
CHANNEL_NBR NUMBER(3, 0) NOT NULL,
MPS_DVC_ID VARCHAR2(50),
LOCKED_IND CHAR(1) DEFAULT 'N' NOT NULL,
MPS_IN RAW(1),
FAST_PROTECT_AUTO_RESET NUMBER(1, 0) DEFAULT 'N',
FAST_PROTECT_LATCH NUMBER(1, 0),
SW_JUMP CHAR(1) DEFAULT 'N' NOT NULL,
BEAM_OFF RAW(1),
STANDBY RAW(1),
MPS_TEST RAW(1),
LIMIT NUMBER(3, 0),
RATE NUMBER(3, 0),
CHASSIS_CONFIG_SW_JMP RAW(1) NOT NULL,
SRC_10US RAW(1),
SRC_50US RAW(1),
SRC_100US RAW(1),
SRC_1MS RAW(1),
SRC_FULLPWR RAW(1),
DTL_10US RAW(1),
DTL_50US RAW(1),
DTL_100US RAW(1),
DTL_2KW RAW(1),
DTL_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),
CONSTRAINT MACHINE_MODE_LIMIT_CK CHECK (<0 and <= 600),
CONSTRAINT MACHINE_MODE_RATE_CK CHECK (>0 and <=600),
CONSTRAINT MACHINE_MODE_PK PRIMARY KEY (DVC_ID, APPR_DTE, CHANNEL_NBR)
USING INDEX
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE OPER_INDEX_TS
LOGGING
STORAGE(INITIAL 64K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 50
),
CONSTRAINT MPS_SGNL_PARAM_MACH_MODE_RF FOREIGN KEY (DVC_ID, APPR_DTE)
REFERENCES MPS_SGNL_PARAM(DVC_ID, APPR_DTE),
CONSTRAINT RefDVC633 FOREIGN KEY (DVC_ID)
REFERENCES DVC(DVC_ID),
CONSTRAINT MPS_DVC_ID_DVC_FK FOREIGN KEY (MPS_DVC_ID)
REFERENCES DVC(DVC_ID)
)
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
TABLESPACE EPICS_TS
LOGGING
NOPARALLEL
STORAGE(INITIAL 64K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 50
)
NOCACHE
NOCOMPRESS
;
|
