CREATE TABLE "DTREADOUTMAPPING" ( "IOV_VALUE_ID" NUMBER(10), "CELL_MAP_VERSION" VARCHAR2(4000) NOT NULL, "ROB_MAP_VERSION" VARCHAR2(4000) NOT NULL, CONSTRAINT "DTREADOUTMAPPING_PK" PRIMARY KEY ( "IOV_VALUE_ID" ) );

CREATE TABLE "DTREADOUTCONNECTION" ( "CONNECTION_ID" NUMBER(10) NOT NULL, "IOV_VALUE_ID" NUMBER(10) NOT NULL, "CELL" NUMBER(10) NOT NULL, "CHANNEL" NUMBER(10) NOT NULL, "DDU" NUMBER(10) NOT NULL, "LAYER" NUMBER(10) NOT NULL, "ROB" NUMBER(10) NOT NULL, "ROS" NUMBER(10) NOT NULL, "SECTOR" NUMBER(10) NOT NULL, "SUPERLAYER" NUMBER(10) NOT NULL, "STATION" NUMBER(10) NOT NULL, "TDC" NUMBER(10) NOT NULL, "WHEEL" NUMBER(10) NOT NULL, CONSTRAINT "DTREADOUTCONNECTION_PK" PRIMARY KEY ( "IOV_VALUE_ID","CONNECTION_ID" ), CONSTRAINT "DTREADOUTCONNECTION_ID_FK" FOREIGN KEY ( "IOV_VALUE_ID" ) REFERENCES "DTREADOUTMAPPING" ( "IOV_VALUE_ID" ) );

ALTER TABLE "DTREADOUTMAPPING" ADD "TIME" NUMBER(10);