| DDL Code |
CREATE TABLE MULTIPOLES(
TEST_DATE DATE DEFAULT sysdate NOT NULL,
UPDOWN NUMBER(2, 0),
MULTIPOLES_CUR NUMBER(12, 6),
POLE NUMBER(2, 0),
X_REF NUMBER(12, 6) NOT NULL,
Y_REF NUMBER(12, 6) NOT NULL,
R_REF NUMBER(12, 6),
NORM_SKEW_CDE NUMBER(1, 0),
SHIM_THICK NUMBER(12, 6),
A1 NUMBER(12, 6),
A2 NUMBER(12, 6),
A3 NUMBER(12, 6),
A4 NUMBER(12, 6),
A5 NUMBER(12, 6),
A6 NUMBER(12, 6),
A7 NUMBER(12, 6),
A8 NUMBER(12, 6),
A9 NUMBER(12, 6),
A10 NUMBER(12, 6),
A11 NUMBER(12, 6),
A12 NUMBER(12, 6),
A13 NUMBER(12, 6),
A14 NUMBER(12, 6),
A15 NUMBER(12, 6),
B1 NUMBER(16, 10),
B2 NUMBER(16, 10),
B3 NUMBER(16, 10),
B4 NUMBER(16, 10),
B5 NUMBER(14, 10),
B6 NUMBER(14, 10),
B7 NUMBER(14, 10),
B8 NUMBER(14, 10),
B9 NUMBER(14, 10),
B10 NUMBER(14, 10),
B11 NUMBER(14, 10),
B12 NUMBER(14, 10),
B13 NUMBER(14, 10),
B14 NUMBER(14, 10),
B15 NUMBER(14, 10),
MEAS_DESC VARCHAR2(255),
SCENARIO_ID VARCHAR2(50) NOT NULL,
EQUIP_ID VARCHAR2(30) NOT NULL,
CONSTRAINT MULTIPOLES_PK PRIMARY KEY (TEST_DATE, EQUIP_ID)
USING INDEX
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE MAGNET_INDEX_TS
LOGGING
STORAGE(INITIAL 10K
NEXT 10K
MINEXTENTS 1
MAXEXTENTS 121
PCTINCREASE 50
),
CONSTRAINT MAG_MULTIPOLES_RF FOREIGN KEY (EQUIP_ID)
REFERENCES MAG(EQUIP_ID)
)
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
TABLESPACE MAGNET_TS
LOGGING
NOPARALLEL
STORAGE(INITIAL 10K
NEXT 10K
MINEXTENTS 1
MAXEXTENTS 121
PCTINCREASE 50
)
NOCACHE
NOCOMPRESS
;
|
