Country Dimension - s_countries_t.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: s_countries_t.sql -- -- Author: Steve Roach -- -- Date: 11-SEP-2006 -- -- Version: 01.00 -- -- -- -- Description: Create table S_COUNTRIES. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 11-SEP-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- DROP TABLE s_countries CASCADE CONSTRAINTS / CREATE TABLE s_countries ( run_no NUMBER NOT NULL ,data_seq NUMBER NOT NULL ,name VARCHAR2(4000) NULL ,iso2_code VARCHAR2(4000) NULL ,iso3_code VARCHAR2(4000) NULL ,un3_code VARCHAR2(4000) NULL ,windows_country_region VARCHAR2(4000) NULL ,windows_code VARCHAR2(4000) NULL ,mac_name VARCHAR2(4000) NULL ,mac_code VARCHAR2(4000) NULL ,ins_tsp DATE NOT NULL ) / COMMENT ON TABLE s_countries IS 'Staging Country table. This contains data newly extracted from the source web page.' / COMMENT ON COLUMN s_countries.run_no IS 'The run number of the mapping that created the data set.' / COMMENT ON COLUMN s_countries.data_seq IS 'Sequence of the data within the run number. Starts at 1 for each new data set.' / COMMENT ON COLUMN s_countries.name IS 'Name of the country.' / COMMENT ON COLUMN s_countries.iso2_code IS '2 character ISO Country code.' / COMMENT ON COLUMN s_countries.iso3_code IS '3 character ISO Country code.' / COMMENT ON COLUMN s_countries.un3_code IS '3 character UN Country code.' / COMMENT ON COLUMN s_countries.windows_country_region IS 'Windows country region.' / COMMENT ON COLUMN s_countries.windows_code IS 'Windows code.' / COMMENT ON COLUMN s_countries.mac_name IS 'Mac name.' / COMMENT ON COLUMN s_countries.mac_code IS 'Mac code.' / COMMENT ON COLUMN s_countries.ins_tsp IS 'Insert timestamp.' /