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`;
|
