Control Repository - mapping_libraries_t.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: mapping_libraries_t.sql -- -- Author: Steve Roach -- -- Date: 23-AUG-2006 -- -- Version: 01.00 -- -- -- -- Description: Create table MAPPING_LIBRARIES. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 23-AUG-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- DROP TABLE mapping_libraries CASCADE CONSTRAINTS / CREATE TABLE mapping_libraries ( mapping_name VARCHAR2(30) NOT NULL ,rep_from VARCHAR2(50) NOT NULL ,rep_to VARCHAR2(50) NOT NULL ) / COMMENT ON TABLE mapping_libraries IS 'A library of all available mappings.' / COMMENT ON COLUMN mapping_libraries.mapping_name IS 'Primary Key. Name of the mapping.' / COMMENT ON COLUMN mapping_libraries.rep_from IS 'The FROM repository for data movement. Foreign key from REPOSITORIES.NAME.' / COMMENT ON COLUMN mapping_libraries.rep_to IS 'The TO repository for data movement. Foreign key from REPOSITORIES.NAME.' /