Untitled

mail@pastecode.io avatar
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)
);