File indexing completed on 2024-04-06 12:03:11
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