CREATE TABLE IF NOT EXISTS `t_emind_dashboard_snapshot` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `station_local_id` bigint NOT NULL COMMENT '本地站点ID', `station_id` bigint NOT NULL COMMENT '平台站点ID',
  `station_name` varchar(255) NOT NULL COMMENT '站点名称', `platform_name` varchar(64) NOT NULL COMMENT '平台名称',
  `income_sum` decimal(18,4) DEFAULT NULL COMMENT '累计收益(元)', `income_today` decimal(18,4) DEFAULT NULL COMMENT '当日收益(元)',
  `charged_energy_sum` decimal(18,4) DEFAULT NULL COMMENT '累计充电量',
  `discharged_energy_sum` decimal(18,4) DEFAULT NULL COMMENT '累计放电量', `charged_energy_today` decimal(18,4) DEFAULT NULL COMMENT '当日充电量',
  `discharged_energy_today` decimal(18,4) DEFAULT NULL COMMENT '当日放电量', `real_time_power` decimal(18,4) DEFAULT NULL COMMENT '实时功率',
  `surplus_energy` decimal(18,4) DEFAULT NULL COMMENT '剩余电量', `soc` decimal(8,4) DEFAULT NULL COMMENT '电池荷电状态', `capacity` decimal(18,4) DEFAULT NULL COMMENT '电池容量',
  `elink_total` int DEFAULT 0 COMMENT '能源链总数', `elink_online` int DEFAULT 0 COMMENT '能源链在线数', `eblock_total` int DEFAULT 0 COMMENT '能量块总数', `eblock_online` int DEFAULT 0 COMMENT '能量块在线数',
  `synced_at` datetime NOT NULL COMMENT '同步时间', 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 COMMENT '主键', `station_id` bigint NOT NULL COMMENT '站点ID', `record_time` varchar(64) NOT NULL COMMENT '记录时间',
  `power` decimal(18,4) DEFAULT NULL COMMENT '功率', `soc` decimal(8,4) DEFAULT NULL COMMENT '电池荷电状态', `synced_at` datetime NOT NULL COMMENT '同步时间',
  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 COMMENT '主键', `station_id` bigint NOT NULL COMMENT '站点ID', `stat_date` date NOT NULL COMMENT '统计日期',
  `price` decimal(18,4) DEFAULT NULL COMMENT '当日电价', `price_name` varchar(128) DEFAULT NULL COMMENT '电价名称',
  `income` decimal(18,4) DEFAULT NULL COMMENT '日收益(元)', `charged_energy` decimal(18,4) DEFAULT NULL COMMENT '日充电量',
  `charged_energy_sharp` decimal(18,4) DEFAULT NULL COMMENT '尖时段充电量', `charged_energy_peak` decimal(18,4) DEFAULT NULL COMMENT '峰时段充电量',
  `charged_energy_flat` decimal(18,4) DEFAULT NULL COMMENT '平时段充电量', `charged_energy_valley` decimal(18,4) DEFAULT NULL COMMENT '谷时段充电量',
  `discharged_energy` decimal(18,4) DEFAULT NULL COMMENT '日放电量', `discharged_energy_sharp` decimal(18,4) DEFAULT NULL COMMENT '尖时段放电量',
  `discharged_energy_peak` decimal(18,4) DEFAULT NULL COMMENT '峰时段放电量', `discharged_energy_flat` decimal(18,4) DEFAULT NULL COMMENT '平时段放电量',
  `discharged_energy_valley` decimal(18,4) DEFAULT NULL COMMENT '谷时段放电量', `synced_at` datetime NOT NULL COMMENT '同步时间',
  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 COMMENT '尖时段充电量（kWh）' AFTER `charged_energy`,
  ADD COLUMN IF NOT EXISTS `charged_energy_peak` decimal(18,4) DEFAULT NULL COMMENT '峰时段充电量（kWh）' AFTER `charged_energy_sharp`,
  ADD COLUMN IF NOT EXISTS `charged_energy_flat` decimal(18,4) DEFAULT NULL COMMENT '平时段充电量（kWh）' AFTER `charged_energy_peak`,
  ADD COLUMN IF NOT EXISTS `charged_energy_valley` decimal(18,4) DEFAULT NULL COMMENT '谷时段充电量（kWh）' AFTER `charged_energy_flat`,
  ADD COLUMN IF NOT EXISTS `discharged_energy_sharp` decimal(18,4) DEFAULT NULL COMMENT '尖时段放电量（kWh）' AFTER `discharged_energy`,
  ADD COLUMN IF NOT EXISTS `discharged_energy_peak` decimal(18,4) DEFAULT NULL COMMENT '峰时段放电量（kWh）' AFTER `discharged_energy_sharp`,
  ADD COLUMN IF NOT EXISTS `discharged_energy_flat` decimal(18,4) DEFAULT NULL COMMENT '平时段放电量（kWh）' AFTER `discharged_energy_peak`,
  ADD COLUMN IF NOT EXISTS `discharged_energy_valley` decimal(18,4) DEFAULT NULL COMMENT '谷时段放电量（kWh）' AFTER `discharged_energy_flat`;