| DDL Code |
CREATE TABLE RF_Cav_Dvc(
DVC_ID VARCHAR2(50) NOT NULL,
"RF Multi Gap Ind" CHAR(1) DEFAULT 'N' NOT NULL,
"Dsgn Freq" NUMBER(12, 6),
TTF NUMBER(12, 6),
"Angle Calib" NUMBER(12, 6),
"Ampl Calib" NUMBER(12, 6),
"Cav Lngth" NUMBER(12, 6),
"T0 Coef" NUMBER(12, 6),
"T1 Coef" NUMBER(12, 6),
"T2 Coef" NUMBER(12, 6),
"TP0 Coef" NUMBER(12, 6),
"TP1 Coef" NUMBER(12, 6),
"TP2 Coef" NUMBER(12, 6),
"S0 Coef" NUMBER(12, 6),
"S1 Coef" NUMBER(12, 6),
"S2 Coef" NUMBER(12, 6),
"SP0 Coef" NUMBER(12, 6),
"SP1 Coef" NUMBER(12, 6),
"SP2 Coef" NUMBER(12, 6),
"Struct Type Ind" CHAR(1),
"T0 End Coef" NUMBER(12, 6),
"T1 End Coef" NUMBER(12, 6),
"Q Ld" NUMBER(12, 6),
"Standard Medium Number" NUMBER(14, 3),
"T2 End Coef" NUMBER(12, 6),
"TP0 End Coef" NUMBER(12, 6),
"TP1 End Coef" NUMBER(12, 6),
"TP2 End Coef" NUMBER(12, 6),
"S0 End Coef" NUMBER(12, 6),
"S1 End Coef" NUMBER(12, 6),
"S2 End Coef" NUMBER(12, 6),
"SP0 End Coef" NUMBER(12, 6),
"SP1 End Coef" NUMBER(12, 6),
"SP2 End Coef" NUMBER(12, 6),
CONSTRAINT RF_CAVITY_DVC_PK PRIMARY KEY (DVC_ID)
USING INDEX
LOGGING,
CONSTRAINT RF_CAV_DVC_DVC_RF FOREIGN KEY (DVC_ID)
REFERENCES EPICS.DVC(DVC_ID)
)
LOGGING
NOPARALLEL
NOCACHE
NOCOMPRESS
;
|
