Get HTML - html_page_access_t.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: html_page_access_t.sql -- -- Author: Steve Roach -- -- Date: 24-JUL-2006 -- -- Version: 01.00 -- -- -- -- Description: Create table HTML_PAGE_ACCESS. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 24-JUL-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- DROP TABLE html_page_access CASCADE CONSTRAINTS / CREATE TABLE html_page_access ( run_no NUMBER NOT NULL ,html_page_name VARCHAR2(30) NOT NULL ,status VARCHAR2(10) NOT NULL CONSTRAINT html_page_access_c1 CHECK (status IN ('FETCHING' ,'FETCHED' ,'PARSED' ,'PARSING' ,'FAILED')) ,start_tsp DATE NOT NULL ) / COMMENT ON TABLE html_page_access IS 'Holds a record of when a web page was accessed.' / COMMENT ON COLUMN html_page_access.run_no IS 'Primary key and foreign key from MAPPING_HISTORIES.RUN_NO.' / COMMENT ON COLUMN html_page_access.html_page_name IS 'Foreign key from HTML_PAGES.NAME.' / COMMENT ON COLUMN html_page_access.status IS 'Status of the access. One of FETCHING, FETCHED, PARSED, PARSING or FAILED.' / COMMENT ON COLUMN html_page_access.start_tsp IS 'Timestamp of when the process that accesses the page was started.' /