Country Dimension - d_country_t.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: d_country_t.sql -- -- Author: Steve Roach -- -- Date: 05-SEP-2006 -- -- Version: 01.00 -- -- -- -- Description: Create table D_COUNTRY. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 05-SEP-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- DROP TABLE D_COUNTRY CASCADE CONSTRAINTS / CREATE TABLE D_COUNTRY ( ID NUMBER NOT NULL ,NAME VARCHAR2(100) NOT NULL ,ISO2_CODE VARCHAR2(2) NOT NULL ,ISO3_CODE VARCHAR2(3) NOT NULL ,UN3_NUMBER VARCHAR2(3) NOT NULL ,START_DATE DATE NOT NULL ,END_DATE DATE NOT NULL ,RUN_NO NUMBER NOT NULL ,INS_TSP DATE NOT NULL ) / COMMENT ON TABLE D_COUNTRY IS 'The Country Dimension contains the names of countries and their various codes as defined by the ISO.' / COMMENT ON COLUMN D_COUNTRY.ID IS 'UID of the row.' / COMMENT ON COLUMN D_COUNTRY.NAME IS 'Full name of the country.' / COMMENT ON COLUMN D_COUNTRY.ISO2_CODE IS '2 character ISO code.' / COMMENT ON COLUMN D_COUNTRY.ISO3_CODE IS '3 character ISO code.' / COMMENT ON COLUMN D_COUNTRY.UN3_NUMBER IS '3 digit numeric UN code.' / COMMENT ON COLUMN D_COUNTRY.START_DATE IS 'Date that the Country came into being.' / COMMENT ON COLUMN D_COUNTRY.END_DATE IS 'Date that the Country ceased.' / COMMENT ON COLUMN D_COUNTRY.RUN_NO IS 'The Run Number that created this row.' / COMMENT ON COLUMN D_COUNTRY.INS_TSP IS 'Insert timestamp.' /