TEPCO でんき予報 CSV の生データ格納テーブル
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | false | public.stg_tepco_demand | |||
| date_str | text | false | ||||
| time_str | text | false | ||||
| demand_mw_str | text | true | ||||
| supply_capacity_mw_str | text | true | ||||
| usage_pct_str | text | true | ||||
| loaded_at | timestamp with time zone | now() | false | |||
| forecast_mw_str | text | true | 予測値 (万kW, TEXT) — ZIP 1時間セクションのみ |
| Name | Type | Definition |
|---|---|---|
| raw_tepco_demand_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| uq_raw_tepco_date_time | UNIQUE | UNIQUE (date_str, time_str) |
| Name | Definition |
|---|---|
| raw_tepco_demand_pkey | CREATE UNIQUE INDEX raw_tepco_demand_pkey ON public.raw_tepco_demand USING btree (id) |
| uq_raw_tepco_date_time | CREATE UNIQUE INDEX uq_raw_tepco_date_time ON public.raw_tepco_demand USING btree (date_str, time_str) |
| idx_raw_tepco_demand_dedup | CREATE INDEX idx_raw_tepco_demand_dedup ON public.raw_tepco_demand USING btree (date_str, time_str, loaded_at DESC) |
Generated by tbls