tdenginee

-- 1.设备主状态 status

CREATE STABLE IF NOT EXISTS stihl_status_stb (
ts TIMESTAMP,
val TINYINT
) TAGS (
sn BINARY(64)
);

-- 2.建图子状态 status_mapping
CREATE STABLE IF NOT EXISTS stihl_status_mapping_stb (
ts TIMESTAMP,
val TINYINT
) TAGS (
sn BINARY(64)
);

-- 3.故障码 fault
CREATE STABLE IF NOT EXISTS stihl_fault_stb (
ts TIMESTAMP,
val INT
) TAGS (
sn BINARY(64)
);

-- 4.剩余电量 bat_soc
CREATE STABLE IF NOT EXISTS stihl_bat_soc_stb (
ts TIMESTAMP,
val TINYINT
) TAGS (
sn BINARY(64)
);

-- 5.雨淋开关 rain_delay_enable
CREATE STABLE IF NOT EXISTS stihl_rain_delay_enable_stb (
ts TIMESTAMP,
val BOOL
) TAGS (
sn BINARY(64)
);

-- 6.雨淋延时时长 rain_delay_time
CREATE STABLE IF NOT EXISTS stihl_rain_delay_time_stb (
ts TIMESTAMP,
val INT
) TAGS (
sn BINARY(64)
);

-- 7.工作区域总面积 work_area_sq
CREATE STABLE IF NOT EXISTS stihl_work_area_sq_stb (
ts TIMESTAMP,
val INT
) TAGS (
sn BINARY(64)
);

-- 8.当日工作时长 day_work_time
CREATE STABLE IF NOT EXISTS stihl_day_work_time_stb (
ts TIMESTAMP,
val INT
) TAGS (
sn BINARY(64)
);

-- 9.当日作业面积 day_work_sq
CREATE STABLE IF NOT EXISTS stihl_day_work_sq_stb (
ts TIMESTAMP,
val INT
) TAGS (
sn BINARY(64)
);

-- 10.本周工作时长 week_work_time
CREATE STABLE IF NOT EXISTS stihl_week_work_time_stb (
ts TIMESTAMP,
val INT
) TAGS (
sn BINARY(64)
);

-- 11.本周作业面积 week_work_sq
CREATE STABLE IF NOT EXISTS stihl_week_work_sq_stb (
ts TIMESTAMP,
val INT
) TAGS (
sn BINARY(64)
);

-- 12.当前任务时长 task_work_time
CREATE STABLE IF NOT EXISTS stihl_task_work_time_stb (
ts TIMESTAMP,
val INT
) TAGS (
sn BINARY(64)
);

-- 13.当前任务面积 task_work_sq
CREATE STABLE IF NOT EXISTS stihl_task_work_sq_stb (
ts TIMESTAMP,
val INT
) TAGS (
sn BINARY(64)
);

-- 14.累计总时长 total_work_time
CREATE STABLE IF NOT EXISTS stihl_total_work_time_stb (
ts TIMESTAMP,
val INT
) TAGS (
sn BINARY(64)
);

-- 15.累计总面积 total_work_sq
CREATE STABLE IF NOT EXISTS stihl_total_work_sq_stb (
ts TIMESTAMP,
val INT
) TAGS (
sn BINARY(64)
);

-- 16.任务类型 task_type
CREATE STABLE IF NOT EXISTS stihl_task_type_stb (
ts TIMESTAMP,
val TINYINT
) TAGS (
sn BINARY(64)
);
CREATE TABLE stb_d1001 USING stihl_status_stb (sn ) TAGS ("d1001");

CREATE TABLE bat_d1001 USING stihl_bat_soc_stb (sn ) TAGS ("d1001");

CREATE TABLE worksq_d1001 USING stihl_day_work_sq_stb (sn ) TAGS ("d1001");

CREATE TABLE worktime_d1001 USING stihl_day_work_time_stb (sn ) TAGS ("d1001");

CREATE TABLE fault_d1001 USING stihl_fault_stb (sn ) TAGS ("d1001");

CREATE TABLE raindelay_stb_d1001 USING stihl_rain_delay_enable_stb (sn ) TAGS ("d1001");

CREATE TABLE raindelay_time_d1001 USING stihl_rain_delay_time_stb (sn ) TAGS ("d1001");

CREATE TABLE mappingstb_d1001 USING stihl_status_mapping_stb (sn ) TAGS ("d1001");

CREATE TABLE task_type USING stihl_task_type_stb(sn ) TAGS ("d1001");

CREATE TABLE work_sq_stb USING stihl_task_work_sq_stb(sn ) TAGS ("d1001");

CREATE STABLE meters_v (
ts timestamp,
dev_status TINYINT,
map_sub_status TINYINT,
fault_code INT,
battery_soc TINYINT,
rain_delay_switch BOOL,
rain_delay_min INT,
day_work_min INT,
day_work_area INT,
curr_task_area INT,
curr_task_type TINYINT
) TAGS (group_id int) VIRTUAL 1;

//duo lie
CREATE VTABLE d1001_v (
dev_status FROM stb_d1001.val,
map_sub_status FROM mappingstb_d1001.val,
fault_code FROM fault_d1001.val,
battery_soc FROM bat_d1001.val,
rain_delay_switch FROM raindelay_stb_d1001.val,
rain_delay_min FROM raindelay_time_d1001.val,
day_work_min FROM worktime_d1001.val,
day_work_area FROM worksq_d1001.val,
curr_task_area FROM work_sq_stb.val,
curr_task_type FROM task_type.val
) USING meters_v TAGS (2);

//kua yuan
CREATE VTABLE current_v (
ts timestamp,
d1001_status TINYINT FROM stb_d1001.val

);

1.先建设字段，每个字段一个表
2.给每个设备分配字段，每个设备一个表
3.建设一个虚拟表，汇聚所有字段，
4.基于上面虚拟表构建每个设备虚拟子表
5。也可以根据2直接构建虚拟表，汇总所有设备