8cdd8083f8
Enterprise EMS reference system for study purposes. - Backend: Spring Boot + MyBatis Plus + Sa-Token - Frontend: Vue 2 + Element UI + ECharts - Database: MySQL + TDengine + Redis - Features: energy monitoring, alarm management, quota, charging, maintenance - Source: https://cp-ems.cn This is a read-only reference. Do not develop on this repo.
468 B
468 B
TDengine 数据库创建脚本
CREATE DATABASE energy KEEP 365000;
USE energy;
CREATE STABLE energy (ts timestamp, client_id varchar(50), val float) TAGS (type varchar(50));
CREATE TABLE electricityi USING energy TAGS('electricityi');
CREATE TABLE electricityu USING energy TAGS('electricityu');
CREATE TABLE electricityw USING energy TAGS('electricityw');
CREATE TABLE electricityp USING energy TAGS('electricityp');
CREATE TABLE water USING energy TAGS('water');