Country Dimension - v_countries_t.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: v_countries_t.sql -- -- Author: Steve Roach -- -- Date: 16-SEP-2006 -- -- Version: 01.00 -- -- -- -- Description: Create table V_COUNTRIES. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 16-SEP-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- DROP TABLE v_countries CASCADE CONSTRAINTS / CREATE TABLE v_countries ( name VARCHAR2(100) NOT NULL ,iso2_code VARCHAR2(2) NULL ,iso3_code VARCHAR2(3) NULL ,un3_number VARCHAR2(3) NULL ,run_no NUMBER NOT NULL ,ins_tsp DATE NOT NULL ) / COMMENT ON TABLE v_countries IS 'Names of countries and their various codes as defined by the ISO.' / COMMENT ON COLUMN v_countries.name IS 'Full name of the country.' / COMMENT ON COLUMN v_countries.iso2_code IS '2 character ISO code.' / COMMENT ON COLUMN v_countries.iso3_code IS '3 character ISO code.' / COMMENT ON COLUMN v_countries.un3_number IS '3 digit numeric UN code.' / COMMENT ON COLUMN v_countries.run_no IS 'The Run Number that created this row.' / COMMENT ON COLUMN v_countries.ins_tsp IS 'Insert timestamp.' /