Open-Meteo 東京エリア気象データの生データ格納テーブル
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | false | public.stg_weather_tokyo | |||
| recorded_at | timestamp with time zone | false | 観測日時 (UTC → JST で利用) | |||
| temperature_c | numeric(4,1) | true | 気温 (°C) | |||
| relative_humidity_pct | numeric(4,1) | true | 相対湿度 (%) | |||
| precipitation_mm | numeric(5,1) | true | 降水量 (mm) | |||
| shortwave_radiation_wm2 | numeric(6,1) | true | 短波放射 / 日射量 (W/m²) | |||
| wind_speed_ms | numeric(5,1) | true | 風速 (m/s) | |||
| wind_direction_deg | numeric(4,0) | true | 風向 (°) | |||
| cloud_cover_pct | numeric(4,1) | true | 雲量 (%) | |||
| pressure_hpa | numeric(6,1) | true | 海面気圧 (hPa) | |||
| loaded_at | timestamp with time zone | now() | false |
| Name | Type | Definition |
|---|---|---|
| raw_weather_tokyo_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| raw_weather_tokyo_recorded_at_key | UNIQUE | UNIQUE (recorded_at) |
| Name | Definition |
|---|---|
| raw_weather_tokyo_pkey | CREATE UNIQUE INDEX raw_weather_tokyo_pkey ON public.raw_weather_tokyo USING btree (id) |
| raw_weather_tokyo_recorded_at_key | CREATE UNIQUE INDEX raw_weather_tokyo_recorded_at_key ON public.raw_weather_tokyo USING btree (recorded_at) |
| idx_raw_weather_tokyo_recorded_at | CREATE INDEX idx_raw_weather_tokyo_recorded_at ON public.raw_weather_tokyo USING btree (recorded_at) |
Generated by tbls