Get HTML - raw_html_t.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: raw_html_t.sql -- -- Author: Steve Roach -- -- Date: 24-JUL-2006 -- -- Version: 01.00 -- -- -- -- Description: Create table RAW_HTML. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 24-JUL-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- DROP TABLE raw_html CASCADE CONSTRAINTS / CREATE TABLE raw_html ( run_no NUMBER NOT NULL ,piece_seq NUMBER NOT NULL ,html_piece VARCHAR2(2000) NOT NULL ,ins_tsp DATE NOT NULL ) / COMMENT ON TABLE raw_html IS 'Holds raw external-site HTML in VARCHAR2s of up 2000 characters in length. Rows in this table hold pieces of HTML in no particular structure apart from their order on the page.' / COMMENT ON COLUMN raw_html.run_no IS 'Part of primary Key. The Run Number that created this row.' / COMMENT ON COLUMN raw_html.piece_seq IS 'Part of primary key. Maintains the order of the piece of the HTML page that this piece was stored in.' / COMMENT ON COLUMN raw_html.html_piece IS 'The piece of HTML fetched from the web page.' / COMMENT ON COLUMN raw_html.ins_tsp IS 'Insert timestamp.' /