EcalCondDB/sql/create_channelview.sql

0001 /* Create channel mapping tables */
0002
0003 CREATE TABLE channelView (
0004   name VARCHAR2(32) NOT NULL,
0005   id1 NUMBER(10) DEFAULT NULL,
0006   id2 NUMBER(10) DEFAULT NULL,
0007   id3 NUMBER(10) DEFAULT NULL,
0008   maps_to VARCHAR2(32) NOT NULL,
0009   logic_id NUMBER(10) NOT NULL
0010 );
0011
0012 ALTER TABLE channelView ADD CONSTRAINT cv_ix1 UNIQUE(name, id1, id2, id3, logic_id);
0013 CREATE INDEX cv_ix2 ON channelView (maps_to);
0014 CREATE INDEX cv_ix3 ON channelView (logic_id);
0015
0016
0017
0018 CREATE TABLE viewDescription (
0019   name VARCHAR2(32) NOT NULL,
0020   description VARCHAR2(4000),
0021   id1name VARCHAR2(32) DEFAULT NULL,
0022   id2name VARCHAR2(32) DEFAULT NULL,
0023   id3name VARCHAR2(32) DEFAULT NULL
0024 );
0025
0026 ALTER TABLE viewDescription ADD CONSTRAINT cvd_pk PRIMARY KEY (name);