ut_receq.tab

-- register tables and view that will have record comparison functions created
-- 12/26/01 dws
CREATE TABLE ut_receq (
   id INTEGER,
   name VARCHAR2(30),
   test_name VARCHAR2(30),
   created_by VARCHAR2(30),
   rec_owner VARCHAR2(30),
  CONSTRAINT ut_receq_pk PRIMARY KEY (id)
);

CREATE UNIQUE INDEX ut_receq_idx1 ON
   ut_receq(rec_owner , name);


-- Intersection table between ut_package and ut_receq   
CREATE TABLE ut_receq_pkg (
    receq_id integer,
    pkg_id  INTEGER,
   created_by VARCHAR2(30)
);

ALTER TABLE ut_receq_pkg ADD CONSTRAINT ut_receq_pkg
    primary key(receq_id,pkg_id,created_by);
    
ALTER TABLE ut_receq_pkg ADD CONSTRAINT ut_receq_pkg_receq_FK
    FOREIGN KEY(receq_id) REFERENCES ut_receq(id);

ALTER TABLE ut_receq_pkg ADD CONSTRAINT ut_receq_pkg_pkg_FK
    FOREIGN KEY(pkg_id) REFERENCES ut_package(id);