Untitled
unknown
plain_text
2 years ago
835 B
6
Indexable
Never
CREATE TABLE DimTime ( timeID int primary key, date int not null, year int not null, quarter int not null, month int not null, day int not null, day_week int not null, day_year int not null, season varchar(8) not null ); CREATE TABLE DimElement ( elementID int primary key, name varchar(4) not null, description varchar(100), unit varchar(32), property varchar(15) ); CREATE TABLE DimStation ( stationID int primary key, country varchar(80) not null, state_alias varchar(2) not null, state_name varchar(32) not null, state_population int, state_total_area int, state_land_area int, state_water_area int, state_nr_reps int, country_fips varchar(2), coutry_name varchar(60), country_license_plate varchar(60), country_domain varchar(3), continent_code varchar(2), continent_name varchar(60) );