| DDL Code |
CREATE TABLE EPICS.MAG_DVC(
DVC_ID VARCHAR2(40) NOT NULL,
PATH_LNGTH NUMBER(12, 6),
POLARITY CHAR(1),
DIPOLE_EXIT_POLE_CURV NUMBER(12, 6),
DIPOLE_ENTR_ROTATION_ANGLE NUMBER(12, 6),
DIPOLE_EXIT_ROTATION_ANGLE NUMBER(12, 6),
DIPOLE_ENTR_POLE_CURV NUMBER(12, 6),
DIPOLE_BEND_ANGLE NUMBER(12, 6),
PM_QUAD_STRENGTH NUMBER(12, 6),
BEAM_ORIENT_IND NUMBER(1, 0),
POS_TERM_IND NUMBER(1, 0),
TERM_LEAD_PLUS VARCHAR2(12),
TERM_LEAD_MINUS VARCHAR2(12),
TRIM_TERM_LEAD_PLUS VARCHAR2(12),
TRIM_TERM_LEAD_MINUS VARCHAR2(12),
MOD_BY_UID VARCHAR2(64),
MOD_DTE DATE,
V_REG NUMBER(12, 6),
I_REG NUMBER(12, 6),
ACCUR NUMBER(12, 6),
MAX_V NUMBER(12, 6),
MIN_V NUMBER(12, 6),
MAX_I NUMBER(12, 6),
MIN_I NUMBER(12, 6),
PS_DVC_ID VARCHAR2(40),
DIPOLE_QUAD_TERM NUMBER(12, 7),
CONSTRAINT BEAM_ORIENT_IND_CK CHECK (BEAM_ORIENT_IND = -1 or BEAM_ORIENT_IND = 1),
CONSTRAINT POS_TERM_IND_CK CHECK (POS_TERM_IND = 1 or POS_TERM_IND = 2),
CONSTRAINT MAG_DVC_PK PRIMARY KEY (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 MAG_DVC_DVC_RF FOREIGN KEY (DVC_ID)
REFERENCES EPICS.DVC(DVC_ID),
CONSTRAINT PS_DVC_ID_DVC_RF FOREIGN KEY (PS_DVC_ID)
REFERENCES EPICS.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 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
NOCACHE
NOCOMPRESS
;
|
