Get HTML - html_parse_passes_t.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: html_parse_passes_t.sql -- -- Author: Steve Roach -- -- Date: 24-JUL-2006 -- -- Version: 01.00 -- -- -- -- Description: Create table HTML_PARSE_PASSES. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 24-JUL-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- DROP TABLE html_parse_passes CASCADE CONSTRAINTS / CREATE TABLE html_parse_passes ( parse_run_no NUMBER NOT NULL ,raw_run_no NUMBER NOT NULL ,status VARCHAR2(30) NOT NULL CONSTRAINT html_parse_passes_c1 CHECK (status IN ('PARSING' ,'PARSED' ,'FAILED')) ,start_tsp DATE NOT NULL ) / COMMENT ON TABLE html_parse_passes IS 'Holds a record of when a web page was parsed.' / COMMENT ON COLUMN html_parse_passes.parse_run_no IS 'Part of Primary Key. Foreign key from MAPPING_HISTORIES.' / COMMENT ON COLUMN html_parse_passes.raw_run_no IS 'Part of Primary Key. Foreign key from HTML_PAGE_ACCESS.' / COMMENT ON COLUMN html_parse_passes.status IS 'Status of the parse. One of PARSING, PARSED or FAILED.' / COMMENT ON COLUMN html_parse_passes.start_tsp IS 'Timestamp of when the process that parsed the page was started.' /