TEPCO 5分間隔データ（月別 ZIP）の生データ格納テーブル
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | false | public.stg_tepco_demand_5min | |||
| date_str | text | false | 日付文字列 (YYYY/M/D) | |||
| time_str | text | false | 時刻文字列 (H:MM) | |||
| demand_mw_str | text | true | 需要実績 (万kW, TEXT) | |||
| solar_mw_str | text | true | 太陽光発電実績 (万kW, TEXT) | |||
| solar_pct_str | text | true | 太陽光発電割合 (%, TEXT) | |||
| loaded_at | timestamp with time zone | now() | false |
| Name | Type | Definition |
|---|---|---|
| raw_tepco_demand_5min_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| raw_tepco_demand_5min_date_str_time_str_key | UNIQUE | UNIQUE (date_str, time_str) |
| Name | Definition |
|---|---|
| raw_tepco_demand_5min_pkey | CREATE UNIQUE INDEX raw_tepco_demand_5min_pkey ON public.raw_tepco_demand_5min USING btree (id) |
| raw_tepco_demand_5min_date_str_time_str_key | CREATE UNIQUE INDEX raw_tepco_demand_5min_date_str_time_str_key ON public.raw_tepco_demand_5min USING btree (date_str, time_str) |
| idx_raw_tepco_demand_5min_date_time | CREATE INDEX idx_raw_tepco_demand_5min_date_time ON public.raw_tepco_demand_5min USING btree (date_str, time_str) |
Generated by tbls