CREATE TABLE IF NOT EXISTS `t_emind_dashboard_snapshot` (
  `id` bigint NOT NULL AUTO_INCREMENT, `station_local_id` bigint NOT NULL, `station_id` bigint NOT NULL,
  `station_name` varchar(255) NOT NULL, `platform_name` varchar(64) NOT NULL,
  `income_sum` decimal(18,4) DEFAULT NULL, `income_today` decimal(18,4) DEFAULT NULL,
  `charged_energy_sum` decimal(18,4) DEFAULT NULL,
  `discharged_energy_sum` decimal(18,4) DEFAULT NULL, `charged_energy_today` decimal(18,4) DEFAULT NULL,
  `discharged_energy_today` decimal(18,4) DEFAULT NULL, `real_time_power` decimal(18,4) DEFAULT NULL,
  `surplus_energy` decimal(18,4) DEFAULT NULL, `soc` decimal(8,4) DEFAULT NULL, `capacity` decimal(18,4) DEFAULT NULL,
  `elink_total` int DEFAULT 0, `elink_online` int DEFAULT 0, `eblock_total` int DEFAULT 0, `eblock_online` int DEFAULT 0,
  `synced_at` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_dashboard_snapshot_station` (`station_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='eMind储能看板最新快照';

CREATE TABLE IF NOT EXISTS `t_emind_dashboard_curve` (
  `id` bigint NOT NULL AUTO_INCREMENT, `station_id` bigint NOT NULL, `record_time` varchar(64) NOT NULL,
  `power` decimal(18,4) DEFAULT NULL, `soc` decimal(8,4) DEFAULT NULL, `synced_at` datetime NOT NULL,
  PRIMARY KEY (`id`), UNIQUE KEY `uk_dashboard_curve_station_time` (`station_id`,`record_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='eMind储能看板当日曲线';

CREATE TABLE IF NOT EXISTS `t_emind_dashboard_daily` (
  `id` bigint NOT NULL AUTO_INCREMENT, `station_id` bigint NOT NULL, `stat_date` date NOT NULL,
  `price` decimal(18,4) DEFAULT NULL, `price_name` varchar(128) DEFAULT NULL,
  `income` decimal(18,4) DEFAULT NULL, `charged_energy` decimal(18,4) DEFAULT NULL,
  `charged_energy_sharp` decimal(18,4) DEFAULT NULL, `charged_energy_peak` decimal(18,4) DEFAULT NULL,
  `charged_energy_flat` decimal(18,4) DEFAULT NULL, `charged_energy_valley` decimal(18,4) DEFAULT NULL,
  `discharged_energy` decimal(18,4) DEFAULT NULL, `discharged_energy_sharp` decimal(18,4) DEFAULT NULL,
  `discharged_energy_peak` decimal(18,4) DEFAULT NULL, `discharged_energy_flat` decimal(18,4) DEFAULT NULL,
  `discharged_energy_valley` decimal(18,4) DEFAULT NULL, `synced_at` datetime NOT NULL,
  PRIMARY KEY (`id`), UNIQUE KEY `uk_dashboard_daily_station_date` (`station_id`,`stat_date`), KEY `idx_dashboard_daily_date` (`stat_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='eMind储能看板日历史';

ALTER TABLE `t_emind_dashboard_snapshot`
  ADD COLUMN IF NOT EXISTS `income_today` decimal(18,4) DEFAULT NULL COMMENT '当日实时收益(元)' AFTER `income_sum`;

ALTER TABLE `t_emind_dashboard_daily`
  ADD COLUMN IF NOT EXISTS `price` decimal(18,4) DEFAULT NULL COMMENT '当日电价' AFTER `stat_date`,
  ADD COLUMN IF NOT EXISTS `price_name` varchar(128) DEFAULT NULL COMMENT '电价名称' AFTER `price`,
  ADD COLUMN IF NOT EXISTS `charged_energy_sharp` decimal(18,4) DEFAULT NULL AFTER `charged_energy`,
  ADD COLUMN IF NOT EXISTS `charged_energy_peak` decimal(18,4) DEFAULT NULL AFTER `charged_energy_sharp`,
  ADD COLUMN IF NOT EXISTS `charged_energy_flat` decimal(18,4) DEFAULT NULL AFTER `charged_energy_peak`,
  ADD COLUMN IF NOT EXISTS `charged_energy_valley` decimal(18,4) DEFAULT NULL AFTER `charged_energy_flat`,
  ADD COLUMN IF NOT EXISTS `discharged_energy_sharp` decimal(18,4) DEFAULT NULL AFTER `discharged_energy`,
  ADD COLUMN IF NOT EXISTS `discharged_energy_peak` decimal(18,4) DEFAULT NULL AFTER `discharged_energy_sharp`,
  ADD COLUMN IF NOT EXISTS `discharged_energy_flat` decimal(18,4) DEFAULT NULL AFTER `discharged_energy_peak`,
  ADD COLUMN IF NOT EXISTS `discharged_energy_valley` decimal(18,4) DEFAULT NULL AFTER `discharged_energy_flat`;