Control Repository - mapping_histories_t.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: mapping_histories_t.sql -- -- Author: Steve Roach -- -- Date: 23-AUG-2006 -- -- Version: 01.00 -- -- -- -- Description: Create table MAPPING_HISTORIES. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 23-AUG-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- DROP TABLE mapping_histories CASCADE CONSTRAINTS / CREATE TABLE mapping_histories ( run_no NUMBER NOT NULL ,mapping_library VARCHAR2(30) NOT NULL ,start_tsp DATE NOT NULL ,end_tsp DATE NULL ) / COMMENT ON TABLE mapping_histories IS 'A history of mapping runs.' / COMMENT ON COLUMN mapping_histories.run_no IS 'Primary key. Generated from RUN_NO_S.' / COMMENT ON COLUMN mapping_histories.mapping_library IS 'Foreign key from MAPPING_LIBRARIES.MAPPING_NAME.' / COMMENT ON COLUMN mapping_histories.start_tsp IS 'Timestamp of mapping run start.' / COMMENT ON COLUMN mapping_histories.end_tsp IS 'Timestamp of mapping run end.' /