3e675ser

1DROP TABLE IF EXISTS kdz17.staging_weather_facts;
2CREATE TABLE IF NOT EXISTS kdz17.staging_weather_facts (
3   icao_code varchar(10) NOT NULL,
4   local_datetime timestamp NOT NULL,  -- Изменен тип на timestamp
5   t_air_temperature numeric(3, 1),
6   p0_sea_lvl numeric(4, 1),
7   p_station_lvl numeric(4, 1),
8   u_humidity int,
9   dd_wind_direction varchar(100),
10   ff_wind_speed int,
11   ff10_max_gust_value int,
12   ww_present varchar(100),
13   ww_recent varchar(50),
14   c_total_clouds varchar(200),
15   vv_horizontal_visibility numeric(3, 1),
16   td_temperature_dewpoint numeric(3, 1),
17   loaded_ts timestamp NOT NULL DEFAULT now(),
18   PRIMARY KEY (icao_code, local_datetime)
19);
20