DROP TABLE IF the EXISTS ` monitor `;
The CREATE TABLE ` monitor ` (
` id ` bigint (20) NOT NULL AUTO_INCREMENT,
` iris_id ` varchar (10) DEFAULT NULL,
` measure_time ` datetime DEFAULT NULL,
` measure_type ` int (11) the DEFAULT NULL,
` measure_cycles ` int (11) the DEFAULT NULL,
` measure_sensitivity ` int (11) the DEFAULT NULL,
` cycle_shift ` int (11) the DEFAULT NULL,
` measure_status ` int (11) the DEFAULT NULL,
` measure_quality ` int (11) the DEFAULT NULL,
` phase_name ` varchar (45) DEFAULT NULL,
` phase_channel ` varchar (45) DEFAULT NULL,
` nqn_c1_plus ` float DEFAULT NULL,
` nqn_c1_minus ` float DEFAULT NULL,
` qm_cl_plus ` float DEFAULT NULL,
` qm_cl_minus ` float DEFAULT NULL,
` nqn_c2_plus ` float DEFAULT NULL,
` nqn_c2_minus ` float DEFAULT NULL,
` qm_c2_plus ` int (11) the DEFAULT NULL,
` qm_c2_minus ` float DEFAULT NULL,
` c1p1 ` float DEFAULT NULL,
` c1p2 ` float DEFAULT NULL,
` c1p3 ` float DEFAULT NULL,
` c1p4 ` float DEFAULT NULL,
` c1p5 ` float DEFAULT NULL,
` c1p6 ` float DEFAULT NULL,
` c1p7 ` float DEFAULT NULL,
` c1p8 ` float DEFAULT NULL,
` c1p9 ` float DEFAULT NULL,
` c1p10 ` float DEFAULT NULL,
` c1p11 ` float DEFAULT NULL,
` c1p12 ` float DEFAULT NULL,
` c1p13 ` float DEFAULT NULL,
` c1p14 ` float DEFAULT NULL,
` c1p15 ` float DEFAULT NULL,
` c1p16 ` float DEFAULT NULL,
` c1m1 ` float DEFAULT NULL,
` c1m2 ` float DEFAULT NULL,
` c1m3 ` float DEFAULT NULL,
` c1m4 ` float DEFAULT NULL,
` c1m5 ` float DEFAULT NULL,
` c1m6 ` float DEFAULT NULL,
` c1m7 ` float DEFAULT NULL,
` c1m8 ` float DEFAULT NULL,
` c1m9 ` float DEFAULT NULL,
` c1m10 ` float DEFAULT NULL,
` c1m11 ` float DEFAULT NULL,
` c1m12 ` float DEFAULT NULL,
` c1m13 ` float DEFAULT NULL,
` c1m14 ` float DEFAULT NULL,
` c1m15 ` float DEFAULT NULL,
` c1m16 ` float DEFAULT NULL,
` c2p1 ` float DEFAULT NULL,
` c2p2 ` float DEFAULT NULL,
` c2p3 ` float DEFAULT NULL,
` c2p4 ` float DEFAULT NULL,
` c2p5 ` float DEFAULT NULL,
` c2p6 ` float DEFAULT NULL,
` c2p7 ` float DEFAULT NULL,
` c2p8 ` float DEFAULT NULL,
` c2p9 ` float DEFAULT NULL,
` c2p10 ` float DEFAULT NULL,
` c2p11 ` float DEFAULT NULL,
` c2p12 ` float DEFAULT NULL,
` c2p13 ` float DEFAULT NULL,
` c2p14 ` float DEFAULT NULL,
` c2p15 ` float DEFAULT NULL,
` c2p16 ` float DEFAULT NULL,
` c2m1 ` float DEFAULT NULL,
` c2m2 ` float DEFAULT NULL,
` c2m3 ` float DEFAULT NULL,
` c2m4 ` float DEFAULT NULL,
` c2m5 ` float DEFAULT NULL,
` c2m6 ` float DEFAULT NULL,
` c2m7 ` float DEFAULT NULL,
` c2m8 ` float DEFAULT NULL,
` c2m9 ` float DEFAULT NULL,
` c2m10 ` float DEFAULT NULL,
` c2m11 ` float DEFAULT NULL,
` c2m12 ` float DEFAULT NULL,
` c2m13 ` float DEFAULT NULL,
` c2m14 ` float DEFAULT NULL,
` c2m15 ` float DEFAULT NULL,
` c2m16 ` float DEFAULT NULL,
The PRIMARY KEY (` id `)
) ENGINE=InnoDB AUTO_INCREMENT=502653 DEFAULT CHARSET=utf8;
CodePudding user response:
The CREATE TABLE MONITOR
(id NUMBER (20, 0) NOT NULL, ENABLE
Iris_id NVARCHAR2 (10),
Measure_time DATE,
Measure_type NUMBER (11, 0),
Measure_cycles NUMBER (11, 0),
Measure_sensitivity NUMBER (11, 0),
Cycle_shift NUMBER (11, 0),
Measure_status NUMBER (11, 0),
Measure_quality NUMBER (11, 0),
Phase_name NVARCHAR2 (45),
Phase_channel NVARCHAR2 (45),
Nqn_c1_plus NUMBER,
Nqn_c1_minus NUMBER,
Qm_cl_plus NUMBER,
Qm_cl_minus NUMBER,
Nqn_c2_plus NUMBER,
Nqn_c2_minus NUMBER,
Qm_c2_plus NUMBER (11, 0),
Qm_c2_minus NUMBER,
C1p1 NUMBER,
C1p2 NUMBER,
C1p3 NUMBER,
C1p4 NUMBER,
C1p5 NUMBER,
C1p6 NUMBER,
C1p7 NUMBER,
C1p8 NUMBER,
C1p9 NUMBER,
C1p10 NUMBER,
C1p11 NUMBER,
C1p12 NUMBER,
C1p13 NUMBER,
C1p14 NUMBER,
C1p15 NUMBER,
C1p16 NUMBER,
C1m1 NUMBER,
C1m2 NUMBER,
C1m3 NUMBER,
C1m4 NUMBER,
C1m5 NUMBER,
C1m6 NUMBER,
C1m7 NUMBER,
C1m8 NUMBER,
C1m9 NUMBER,
C1m10 NUMBER,
C1m11 NUMBER,
C1m12 NUMBER,
C1m13 NUMBER,
C1m14 NUMBER,
C1m15 NUMBER,
C1m16 NUMBER,
C2p1 NUMBER,
C2p2 NUMBER,
C2p3 NUMBER,
C2p4 NUMBER,
C2p5 NUMBER,
C2p6 NUMBER,
C2p7 NUMBER,
C2p8 NUMBER,
C2p9 NUMBER,
C2p10 NUMBER,
C2p11 NUMBER,
C2p12 NUMBER,
C2p13 NUMBER,
C2p14 NUMBER,
C2p15 NUMBER,
C2p16 NUMBER,
C2m1 NUMBER,
C2m2 NUMBER,
C2m3 NUMBER,
C2m4 NUMBER,
C2m5 NUMBER,
C2m6 NUMBER,
C2m7 NUMBER,
C2m8 NUMBER,
C2m9 NUMBER,
C2m10 NUMBER,
C2m11 NUMBER,
C2m12 NUMBER,
C2m13 NUMBER,
C2m14 NUMBER,
C2m15 NUMBER,
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull