Get HTML - html_tags_t.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: html_tags_t.sql -- -- Author: Steve Roach -- -- Date: 25-JUL-2006 -- -- Version: 01.00 -- -- -- -- Description: Create table HTML_TAGS. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 25-JUL-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- DROP TABLE html_tags CASCADE CONSTRAINTS / CREATE TABLE html_tags ( name VARCHAR2(50) NOT NULL ,treatment VARCHAR2(7) NOT NULL ,paired VARCHAR2(1) NOT NULL ) / COMMENT ON TABLE html_tags IS 'A list of HTML tags and whether they are kept or discarded when pre-processing them for data extraction.' / COMMENT ON COLUMN html_tags.name IS 'Primary Key. Name of the tag.' / COMMENT ON COLUMN html_tags.treatment IS 'Type of treatment for the tag when pre-processing for data extraction. One of KEEP or DISCARD.' / COMMENT ON COLUMN html_tags.paired IS 'Whether an opening tag must have a closing tag. One of Y or N.' /