Back to home page

Project CMSSW displayed by LXR

 
 

    


File indexing completed on 2021-02-14 12:52:15

0001 CREATE TABLE DT_NUMBERING_MASTER
0002         (       NUMBERING_ID                    NUMBER(8) NOT NULL,
0003                 NUMBERING_VERSION               VARCHAR2(400),
0004                 PRIMARY KEY (NUMBERING_ID)
0005         );
0006 
0007 CREATE TABLE DT_WHEEL
0008         (       WHEEL_ID                        NUMBER(1) NOT NULL,
0009                 PRIMARY KEY (WHEEL_ID)
0010         );
0011 
0012 CREATE TABLE DT_WHEEL_NUMBERING
0013         (       NUMBERING_ID                    NUMBER(8) NOT NULL,
0014                 WHEEL_ID                        NUMBER(1) NOT NULL,
0015                 OBJECT_NUMBER                   NUMBER(8) NOT NULL,
0016                 FOREIGN KEY (NUMBERING_ID) REFERENCES DT_NUMBERING_MASTER(NUMBERING_ID),
0017                 FOREIGN KEY (WHEEL_ID) REFERENCES DT_WHEEL(WHEEL_ID)
0018         );
0019 
0020 CREATE TABLE DT_SECTOR
0021         (       SECTOR_ID                       NUMBER(3) NOT NULL,
0022                 SECTOR_NUMBER                   NUMBER(2) NOT NULL,
0023                 WHEEL_ID                        NUMBER(1) NOT NULL,
0024                 CHAMBER_NUMBER                  NUMBER(1) NOT NULL,
0025                 PRIMARY KEY (SECTOR_ID),
0026                 FOREIGN KEY (WHEEL_ID) REFERENCES DT_WHEEL(WHEEL_ID)
0027         );
0028 
0029 CREATE TABLE DT_CHAMBER
0030         (       CHAMBER_ID                      NUMBER(4) NOT NULL,
0031                 CHAMBER_NUMBER                  NUMBER(1) NOT NULL,
0032                 SECTOR_ID                       NUMBER(3) NOT NULL,
0033                 SL_NUMBER                       NUMBER(1) NOT NULL,
0034                 ROB_NUMBER                      NUMBER(1) NOT NULL,
0035                 PRIMARY KEY (CHAMBER_ID),
0036                 FOREIGN KEY (SECTOR_ID) REFERENCES DT_SECTOR(SECTOR_ID)
0037         );
0038 
0039 CREATE TABLE DT_CHAMBER_NUMBERING
0040         (       NUMBERING_ID                    NUMBER(8) NOT NULL,
0041                 CHAMBER_ID                      NUMBER(4) NOT NULL,
0042                 STATION_NUMBER                  NUMBER(8) NOT NULL,
0043                 SECTOR_NUMBER                   NUMBER(8) NOT NULL,
0044                 FOREIGN KEY (NUMBERING_ID) REFERENCES DT_NUMBERING_MASTER(NUMBERING_ID),
0045                 FOREIGN KEY (CHAMBER_ID) REFERENCES DT_CHAMBER(CHAMBER_ID)
0046         );
0047 
0048 CREATE TABLE DT_SUPERLAYER
0049         (       SL_ID                           NUMBER(6) NOT NULL,
0050                 SL_NUMBER                       NUMBER(1) NOT NULL,
0051                 CHAMBER_ID                      NUMBER(4) NOT NULL,
0052                 FEB_NUMBER                      NUMBER(2) NOT NULL,
0053                 PRIMARY KEY (SL_ID),
0054                 FOREIGN KEY (CHAMBER_ID) REFERENCES DT_CHAMBER(CHAMBER_ID)
0055         );
0056 
0057 CREATE TABLE DT_SUPERLAYER_NUMBERING
0058         (       NUMBERING_ID                    NUMBER(8) NOT NULL,
0059                 SL_ID                           NUMBER(6) NOT NULL,
0060                 OBJECT_NUMBER                   NUMBER(8) NOT NULL,
0061                 FOREIGN KEY (NUMBERING_ID) REFERENCES DT_NUMBERING_MASTER(NUMBERING_ID),
0062                 FOREIGN KEY (SL_ID) REFERENCES DT_SUPERLAYER(SL_ID)
0063         );
0064 
0065 CREATE TABLE DT_LAYER
0066         (       LAYER_ID                        NUMBER(6) NOT NULL,
0067                 LAYER_NUMBER                    NUMBER(1) NOT NULL,
0068                 SL_ID                           NUMBER(6) NOT NULL,
0069                 CELL_NUMBER                     NUMBER(2) NOT NULL,
0070                 PRIMARY KEY (LAYER_ID),
0071                 FOREIGN KEY (SL_ID) REFERENCES DT_SUPERLAYER(SL_ID)
0072         );
0073 
0074 CREATE TABLE DT_LAYER_NUMBERING
0075         (       NUMBERING_ID                    NUMBER(8) NOT NULL,
0076                 LAYER_ID                        NUMBER(6) NOT NULL,
0077                 OBJECT_NUMBER                   NUMBER(8) NOT NULL,
0078                 FOREIGN KEY (NUMBERING_ID) REFERENCES DT_NUMBERING_MASTER(NUMBERING_ID),
0079                 FOREIGN KEY (LAYER_ID) REFERENCES DT_LAYER(LAYER_ID)
0080         );
0081 
0082 CREATE TABLE DT_CELL
0083         (       CELL_ID                         NUMBER(8) NOT NULL,
0084                 CELL_NUMBER                     NUMBER(2) NOT NULL,
0085                 LAYER_ID                        NUMBER(6) NOT NULL,
0086                 FE_POSITION                     NUMBER(2) NOT NULL,
0087                 HV_POSITION                     NUMBER(2) NOT NULL,
0088                 PRIMARY KEY (CELL_ID),
0089                 FOREIGN KEY (LAYER_ID) REFERENCES DT_LAYER(LAYER_ID)
0090         );
0091 
0092 CREATE TABLE DT_CELL_NUMBERING
0093         (       NUMBERING_ID                    NUMBER(8) NOT NULL,
0094                 CELL_ID                         NUMBER(8) NOT NULL,
0095                 OBJECT_NUMBER                   NUMBER(8) NOT NULL,
0096                 FOREIGN KEY (NUMBERING_ID) REFERENCES DT_NUMBERING_MASTER(NUMBERING_ID),
0097                 FOREIGN KEY (CELL_ID) REFERENCES DT_CELL(CELL_ID)
0098         );
0099 
0100 CREATE TABLE DT_FEB
0101         (       FEB_ID                          NUMBER(7) NOT NULL,
0102                 SL_ID                           NUMBER(6) NOT NULL,
0103                 CHANNEL_NUMBER                  NUMBER(2) NOT NULL,
0104                 PRIMARY KEY (FEB_ID),
0105                 FOREIGN KEY (SL_ID) REFERENCES DT_SUPERLAYER(SL_ID)
0106         );
0107 
0108 CREATE TABLE DT_FE_CHANNEL
0109         (       FE_CHANNEL_ID                   NUMBER(8) NOT NULL,
0110                 FE_CHANNEL_NUMBER               NUMBER(2) NOT NULL,
0111                 FEB_ID                          NUMBER(7) NOT NULL,
0112                 CELL_ID                         NUMBER(8) NOT NULL,
0113                 PRIMARY KEY (FE_CHANNEL_ID),
0114                 FOREIGN KEY (FEB_ID) REFERENCES DT_FEB(FEB_ID),
0115                 FOREIGN KEY (CELL_ID) REFERENCES DT_CELL(CELL_ID)
0116         );
0117 
0118 CREATE TABLE DT_TSM
0119         (       TSM_ID                          NUMBER(4) NOT NULL,
0120                 CHAMBER_ID                      NUMBER(4) NOT NULL,
0121                 PRIMARY KEY (TSM_ID),
0122                 FOREIGN KEY (CHAMBER_ID) REFERENCES DT_CHAMBER(CHAMBER_ID)
0123         );
0124 
0125 CREATE TABLE DT_TRB
0126         (       TRB_ID                          NUMBER(6) NOT NULL,
0127                 TRB_NUMBER                      NUMBER(1) NOT NULL,
0128                 TSM_ID                          NUMBER(4) NOT NULL,
0129                 TRACO_NUMBER                    NUMBER(1) NOT NULL,
0130                 PRIMARY KEY (TRB_ID),
0131                 FOREIGN KEY (TSM_ID) REFERENCES DT_TSM(TSM_ID)
0132         );
0133 
0134 CREATE TABLE DT_BTI
0135         (       BTI_ID                          NUMBER(7) NOT NULL,
0136                 BTI_NUMBER                      NUMBER(1) NOT NULL,
0137                 TRB_ID                          NUMBER(6) NOT NULL,
0138                 PRIMARY KEY (BTI_ID),
0139                 FOREIGN KEY (TRB_ID) REFERENCES DT_TRB(TRB_ID)
0140         );
0141 
0142 CREATE TABLE DT_TRACO
0143         (       TRACO_ID                        NUMBER(4) NOT NULL,
0144                 TRACO_NUMBER                    NUMBER(1) NOT NULL,
0145                 TRB_ID                          NUMBER(4) NOT NULL,
0146                 BTI_INNER                       NUMBER(7) NOT NULL,
0147                 BTI_OUTER_L                     NUMBER(7),
0148                 BTI_OUTER_C                     NUMBER(7) NOT NULL,
0149                 BTI_OUTER_R                     NUMBER(7),
0150                 PRIMARY KEY (TRACO_ID),
0151                 FOREIGN KEY (TRB_ID) REFERENCES DT_TRB(TRB_ID),
0152                 FOREIGN KEY (BTI_INNER) REFERENCES DT_BTI(BTI_ID),
0153                 FOREIGN KEY (BTI_OUTER_L) REFERENCES DT_BTI(BTI_ID),
0154                 FOREIGN KEY (BTI_OUTER_C) REFERENCES DT_BTI(BTI_ID),
0155                 FOREIGN KEY (BTI_OUTER_R) REFERENCES DT_BTI(BTI_ID)
0156         );
0157 
0158 CREATE TABLE DT_BTI_CHANNEL
0159         (       BTI_CHANNEL_ID                  NUMBER(8) NOT NULL,
0160                 BTI_CHANNEL_NUMBER              NUMBER(1) NOT NULL,
0161                 CELL_ID                         NUMBER(8) NOT NULL,
0162                 BTI_ID                          NUMBER(7) NOT NULL,
0163                 PRIMARY KEY (BTI_CHANNEL_ID),
0164                 FOREIGN KEY (BTI_ID) REFERENCES DT_BTI (BTI_ID),
0165                 FOREIGN KEY (CELL_ID) REFERENCES DT_CELL (CELL_ID)
0166         );
0167 
0168 CREATE TABLE DT_DDU
0169         (       DDU_ID                          NUMBER(2) NOT NULL,
0170                 DDU_NUMBER                      NUMBER(1) NOT NULL,
0171                 WHEEL_ID                        NUMBER(1) NOT NULL,
0172                 READ_OUT_NUMBER                 NUMBER(8) NOT NULL,
0173                 PRIMARY KEY (DDU_ID),
0174                 FOREIGN KEY (WHEEL_ID) REFERENCES DT_WHEEL(WHEEL_ID)
0175         );
0176 
0177 CREATE TABLE DT_ROS
0178         (       ROS_ID                          NUMBER(4) NOT NULL,
0179                 ROS_NUMBER                      NUMBER(2) NOT NULL,
0180                 DDU_ID                          NUMBER(2) NOT NULL,
0181                 READ_OUT_NUMBER                 NUMBER(8) NOT NULL,
0182                 PRIMARY KEY (ROS_ID),
0183                 FOREIGN KEY (DDU_ID) REFERENCES DT_DDU(DDU_ID)
0184         );
0185 
0186 CREATE TABLE DT_ROS_CHANNEL
0187         (       ROS_CHANNEL_ID                  NUMBER(6) NOT NULL,
0188                 ROS_CHANNEL_NUMBER              NUMBER(2) NOT NULL,
0189                 ROS_ID                          NUMBER(4) NOT NULL,
0190                 READ_OUT_NUMBER                 NUMBER(8) NOT NULL,
0191                 PRIMARY KEY (ROS_CHANNEL_ID),
0192                 FOREIGN KEY (ROS_ID) REFERENCES DT_ROS(ROS_ID)
0193         );
0194 
0195 CREATE TABLE DT_ROB
0196         (       ROB_ID                          NUMBER(6) NOT NULL,
0197                 ROB_NUMBER                      NUMBER(1) NOT NULL,
0198                 CHAMBER_ID                      NUMBER(4) NOT NULL,
0199                 TDC_NUMBER                      NUMBER(1) NOT NULL,
0200                 PRIMARY KEY (ROB_ID),
0201                 FOREIGN KEY (CHAMBER_ID) REFERENCES DT_CHAMBER(CHAMBER_ID)
0202         );
0203 
0204 CREATE TABLE DT_TDC
0205         (       TDC_ID                          NUMBER(6) NOT NULL,
0206                 TDC_NUMBER                      NUMBER(1) NOT NULL,
0207                 ROB_ID                          NUMBER(6) NOT NULL,
0208                 READ_OUT_NUMBER                 NUMBER(8) NOT NULL,
0209                 PRIMARY KEY (TDC_ID),
0210                 FOREIGN KEY (ROB_ID) REFERENCES DT_ROB(ROB_ID)
0211         );
0212 
0213 CREATE TABLE DT_TDC_CHANNEL
0214         (       TDC_CHANNEL_ID                  NUMBER(8) NOT NULL,
0215                 TDC_CHANNEL_NUMBER              NUMBER(2) NOT NULL,
0216                 TDC_ID                          NUMBER(6) NOT NULL,
0217                 READ_OUT_NUMBER                 NUMBER(8) NOT NULL,
0218                 PRIMARY KEY (TDC_CHANNEL_ID),
0219                 FOREIGN KEY (TDC_ID) REFERENCES DT_TDC(TDC_ID)
0220         );
0221 
0222 CREATE TABLE DT_SY1527
0223         (       SY1527_ID                       NUMBER(2) NOT NULL,
0224                 PRIMARY KEY (SY1527_ID)
0225         );
0226 
0227 CREATE TABLE DT_A876
0228         (       A876_ID                         NUMBER(3) NOT NULL,
0229                 A876_NUMBER                     NUMBER(1) NOT NULL,
0230                 SY1527_ID                       NUMBER(2) NOT NULL,
0231                 SECTOR_ID                       NUMBER(3) NOT NULL,
0232                 PRIMARY KEY (A876_ID),
0233                 FOREIGN KEY (SY1527_ID) REFERENCES DT_SY1527(SY1527_ID),
0234                 FOREIGN KEY (SECTOR_ID) REFERENCES DT_SECTOR(SECTOR_ID)
0235         );
0236 
0237 CREATE TABLE DT_A877
0238         (       A877_ID                         NUMBER(4) NOT NULL,
0239                 A877_NUMBER                     NUMBER(1) NOT NULL,
0240                 A876_ID                         NUMBER(3) NOT NULL,
0241                 CHAMBER_ID                      NUMBER(4) NOT NULL,
0242                 PRIMARY KEY (A877_ID),
0243                 FOREIGN KEY (A876_ID) REFERENCES DT_A876(A876_ID),
0244                 FOREIGN KEY (CHAMBER_ID) REFERENCES DT_CHAMBER(CHAMBER_ID)
0245         );
0246 
0247 CREATE TABLE DT_HV_CONNECTOR
0248         (       HV_CONNECTOR_ID                 NUMBER(6) NOT NULL,
0249                 HV_CONNECTOR_NUMBER             NUMBER(1) NOT NULL,
0250                 A877_ID                         NUMBER(4) NOT NULL,
0251                 SL_ID                           NUMBER(6) NOT NULL,
0252                 PRIMARY KEY (HV_CONNECTOR_ID),
0253                 FOREIGN KEY (A877_ID) REFERENCES DT_A877(A877_ID),
0254                 FOREIGN KEY (SL_ID) REFERENCES DT_SUPERLAYER(SL_ID)
0255         );
0256 
0257 CREATE TABLE DT_HV_CHANNEL
0258         (       HV_CHANNEL_ID                   NUMBER(7) NOT NULL,
0259                 HV_CHANNEL_NUMBER               NUMBER(2) NOT NULL,
0260                 HV_CHANNEL_CODE                 VARCHAR2(4) NOT NULL,
0261                 HV_CONNECTOR_ID                 NUMBER(6) NOT NULL,
0262                 PRIMARY KEY (HV_CHANNEL_ID),
0263                 FOREIGN KEY (HV_CONNECTOR_ID) REFERENCES DT_HV_CONNECTOR(HV_CONNECTOR_ID)
0264         );
0265 
0266 CREATE TABLE DT_HV_CARD
0267         (       HV_CARD_ID                      NUMBER(6) NOT NULL,
0268                 HV_CARD_NUMBER                  NUMBER(1) NOT NULL,
0269                 SL_ID                           NUMBER(6) NOT NULL,
0270                 CELL_NUMBER                     NUMBER(2) NOT NULL,
0271                 PRIMARY KEY (HV_CARD_ID),
0272                 FOREIGN KEY (SL_ID) REFERENCES DT_SUPERLAYER(SL_ID)
0273         );
0274 
0275 CREATE TABLE DT_HV_CARD_SIDE
0276         (       HV_CARD_SIDE_ID                 NUMBER(7) NOT NULL,
0277                 HV_CARD_SIDE_NUMBER             NUMBER(1) NOT NULL,
0278                 HV_CARD_ID                      NUMBER(6) NOT NULL,
0279                 HV_WIRE_CHANNEL_ID              NUMBER(7) NOT NULL,
0280                 HV_STRIP_CHANNEL_ID             NUMBER(7) NOT NULL,
0281                 HV_CATHODE_CHANNEL_ID           NUMBER(7) NOT NULL,
0282                 LAYER_ID                        NUMBER(6) NOT NULL,
0283                 PRIMARY KEY (HV_CARD_SIDE_ID),
0284                 FOREIGN KEY (HV_CARD_ID) REFERENCES DT_HV_CARD(HV_CARD_ID),
0285                 FOREIGN KEY (LAYER_ID) REFERENCES DT_LAYER(LAYER_ID),
0286                 FOREIGN KEY (HV_WIRE_CHANNEL_ID) REFERENCES DT_HV_CHANNEL(HV_CHANNEL_ID),
0287                 FOREIGN KEY (HV_STRIP_CHANNEL_ID) REFERENCES DT_HV_CHANNEL(HV_CHANNEL_ID),
0288                 FOREIGN KEY (HV_CATHODE_CHANNEL_ID) REFERENCES DT_HV_CHANNEL(HV_CHANNEL_ID)
0289         );
0290 
0291 CREATE TABLE DT_HV_CARD_WIRE
0292         (       HV_CARD_WIRE_ID                 NUMBER(8) NOT NULL,
0293                 HV_CARD_SIDE_ID                 NUMBER(8) NOT NULL,
0294                 CELL_ID                         NUMBER(8) NOT NULL,
0295                 PRIMARY KEY (HV_CARD_WIRE_ID),
0296                 FOREIGN KEY (HV_CARD_SIDE_ID) REFERENCES DT_HV_CARD_SIDE(HV_CARD_SIDE_ID),
0297                 FOREIGN KEY (CELL_ID) REFERENCES DT_CELL(CELL_ID)
0298         );
0299 
0300 CREATE TABLE DT_HV_CARD_STRIP
0301         (       HV_CARD_STRIP_ID                NUMBER(8) NOT NULL,
0302                 HV_CARD_SIDE_ID                 NUMBER(8) NOT NULL,
0303                 CELL_ID                         NUMBER(8) NOT NULL,
0304                 PRIMARY KEY (HV_CARD_STRIP_ID),
0305                 FOREIGN KEY (HV_CARD_SIDE_ID) REFERENCES DT_HV_CARD_SIDE(HV_CARD_SIDE_ID),
0306                 FOREIGN KEY (CELL_ID) REFERENCES DT_CELL(CELL_ID)
0307         );
0308 
0309 CREATE TABLE DT_HV_CARD_CATHODE
0310         (       HV_CARD_CATHODE_ID              NUMBER(8) NOT NULL,
0311                 HV_CARD_SIDE_ID                 NUMBER(8) NOT NULL,
0312                 CELL_ID                         NUMBER(8) NOT NULL,
0313                 PRIMARY KEY (HV_CARD_CATHODE_ID),
0314                 FOREIGN KEY (HV_CARD_SIDE_ID) REFERENCES DT_HV_CARD_SIDE(HV_CARD_SIDE_ID),
0315                 FOREIGN KEY (CELL_ID) REFERENCES DT_CELL(CELL_ID)
0316         );
0317 
0318 CREATE TABLE DT_IOV_MASTER
0319         (       IOV_ID                          NUMBER(8) NOT NULL,
0320                 VALID_FROM                      DATE DEFAULT '01-JAN-1970' NOT NULL,
0321                 VALID_UNTIL                     DATE DEFAULT '31-DEC-2099' NOT NULL,
0322                 IOV_VERSION                     VARCHAR2(50),
0323                 PRIMARY KEY (IOV_ID)
0324         );
0325 
0326 CREATE TABLE DT_FEB_TEMPERATURE
0327         (       FEB_ID                          NUMBER(7) NOT NULL,
0328                 IOV_ID                          NUMBER NOT NULL,
0329                 TEMPERATURE                     NUMBER(4) NOT NULL,
0330                 PRIMARY KEY (FEB_ID, IOV_ID),
0331                 FOREIGN KEY (FEB_ID) REFERENCES DT_FEB(FEB_ID),
0332                 FOREIGN KEY (IOV_ID) REFERENCES DT_IOV_MASTER(IOV_ID)
0333         );
0334 
0335 CREATE TABLE DT_MEAN_FEB_TEMPERATURE
0336         (       SL_ID                           NUMBER(6) NOT NULL,
0337                 IOV_ID                          NUMBER(8) NOT NULL,
0338                 MEAN_TEMPERATURE                NUMBER(4) NOT NULL,
0339                 PRIMARY KEY (SL_ID, IOV_ID),
0340                 FOREIGN KEY (SL_ID) REFERENCES DT_SUPERLAYER(SL_ID),
0341                 FOREIGN KEY (IOV_ID) REFERENCES DT_IOV_MASTER(IOV_ID)
0342         );
0343 
0344 CREATE TABLE DT_TRB_TEMPERATURE
0345         (       TRB_ID                          NUMBER(6) NOT NULL,
0346                 IOV_ID                          NUMBER(8) NOT NULL,
0347                 TEMPERATURE                     NUMBER(4) NOT NULL,
0348                 PRIMARY KEY (TRB_ID, IOV_ID),
0349                 FOREIGN KEY (TRB_ID) REFERENCES DT_TRB(TRB_ID),
0350                 FOREIGN KEY (IOV_ID) REFERENCES DT_IOV_MASTER(IOV_ID)
0351         );
0352 
0353 CREATE TABLE DT_CHAMBER_PRESSURE
0354         (       CHAMBER_ID                      NUMBER(4) NOT NULL,
0355                 IOV_ID                          NUMBER(8) NOT NULL,
0356                 PRESSURE_1                      NUMBER(4) NOT NULL,
0357                 PRESSURE_2                      NUMBER(4) NOT NULL,
0358                 PRIMARY KEY (CHAMBER_ID, IOV_ID),
0359                 FOREIGN KEY (CHAMBER_ID) REFERENCES DT_CHAMBER(CHAMBER_ID),
0360                 FOREIGN KEY (IOV_ID) REFERENCES DT_IOV_MASTER(IOV_ID)
0361         );
0362 
0363 CREATE TABLE DT_HV_VALUES
0364         (       HV_CHANNEL_ID                   NUMBER(7) NOT NULL,
0365                 IOV_ID                          NUMBER(8) NOT NULL,
0366                 VOLTAGE_VALUE                   NUMBER(6) NOT NULL,
0367                 CURRENT_VALUE                   NUMBER(6) NOT NULL,
0368                 PRIMARY KEY (HV_CHANNEL_ID, IOV_ID),
0369                 FOREIGN KEY (HV_CHANNEL_ID) REFERENCES DT_HV_CHANNEL(HV_CHANNEL_ID)
0370         );
0371 
0372 CREATE TABLE DT_TEST_PULSE
0373         (       CELL_ID                         NUMBER(8) NOT NULL,
0374                 IOV_ID                          NUMBER(8) NOT NULL,
0375                 MEAN_T0                         NUMBER(8) NOT NULL,
0376                 RMS_T0                          NUMBER(8) NOT NULL,
0377                 PRIMARY KEY (CELL_ID, IOV_ID),
0378                 FOREIGN KEY (CELL_ID) REFERENCES DT_CELL(CELL_ID)
0379         );
0380 
0381 CREATE TABLE DT_MEAN_TIMER
0382         (       SL_ID                           NUMBER(6) NOT NULL,
0383                 IOV_ID                          NUMBER(8) NOT NULL,
0384                 MEAN_MTIMER                     NUMBER(8) NOT NULL,
0385                 RMS_MTIMER                      NUMBER(8) NOT NULL,
0386                 PRIMARY KEY (SL_ID, IOV_ID),
0387                 FOREIGN KEY (SL_ID) REFERENCES DT_SUPERLAYER(SL_ID)
0388         );
0389 
0390 CREATE TABLE DT_FE_MASK
0391         (       FE_CHANNEL_ID                   NUMBER(8) NOT NULL,
0392                 IOV_ID                          NUMBER(8) NOT NULL,
0393                 ENABLE_MASK                     NUMBER(1) NOT NULL,
0394                 PRIMARY KEY (FE_CHANNEL_ID, IOV_ID),
0395                 FOREIGN KEY (FE_CHANNEL_ID) REFERENCES DT_FE_CHANNEL(FE_CHANNEL_ID)
0396         );
0397 
0398 CREATE TABLE DT_CONNECTION_MASTER
0399         (       CONNECTION_ID                   NUMBER(8) NOT NULL,
0400                 CONNECTION_TYPE                 VARCHAR2(40),
0401                 MAPPING_VERSION                 VARCHAR2(40),
0402                 PRIMARY KEY (CONNECTION_ID)
0403         );
0404 
0405 CREATE TABLE DT_CELL_READOUT_MAP
0406         (       CONNECTION_ID                   NUMBER(8) NOT NULL,
0407                 CELL_ID                         NUMBER(8) NOT NULL,
0408                 TDC_CHANNEL_ID                  NUMBER(8) NOT NULL,
0409                 FOREIGN KEY (CONNECTION_ID) REFERENCES DT_CONNECTION_MASTER(CONNECTION_ID),
0410                 FOREIGN KEY (CELL_ID) REFERENCES DT_CELL(CELL_ID),
0411                 FOREIGN KEY (TDC_CHANNEL_ID) REFERENCES DT_TDC_CHANNEL(TDC_CHANNEL_ID)
0412         );
0413 
0414 CREATE TABLE DT_ROB_ROS_CONNECTION
0415         (       CONNECTION_ID                   NUMBER(8) NOT NULL,
0416                 ROS_CHANNEL_ID                  NUMBER(6) NOT NULL,
0417                 ROB_ID                          NUMBER(6) NOT NULL,
0418                 FOREIGN KEY (CONNECTION_ID) REFERENCES DT_CONNECTION_MASTER(CONNECTION_ID),
0419                 FOREIGN KEY (ROS_CHANNEL_ID) REFERENCES DT_ROS_CHANNEL(ROS_CHANNEL_ID),
0420                 FOREIGN KEY (ROB_ID) REFERENCES DT_ROB(ROB_ID)
0421         );
0422