第三个设备 通信

建表

3_通信_20210707.csv 作废

"sid","des","value"
"name","名称","通信"
"sn","编号","communication"
"k1","产线编码","line"
"k2","pack编码","psn"
"k3","设备编码","esn"
"k4","用户标识","usn"
"k5","物料","msn"
"k6","单体电压值（多个）","SingleVoltageValue"
"k7","压差","differentialPressure"
"k8","最大电压值","maxVoltage"
"k9","最小电压值","minVoltage"
"k10","温度值（多个）","temperatureValue"
"k11","温差","temperatureDifference"
"k12","最大温度","maxTemperature"
"k13","最小温度","minTemperature"

3_通信_20210804.csv

"sid","des","value"
"name","名称","通信"
"sn","编号","communication"
"k1","工站名","wsn"
"k2","设备号","esn"
"k3","用户编号","usn"
"k4","压差","differentialPressure"
"k5","温差","temperatureDifference"
"k6","测试结果","testResult"

"k7","电压1","V1"
"k8","电压2","V2"
"k9","电压3","V3"
"k10","电压4","V4"
"k11","电压5","V5"
"k12","电压6","V6"
"k13","电压7","V7"
"k14","电压8","V8"
"k15","电压9","V9"
"k16","电压10","V10"

"k17","电压11","V11"
"k18","电压12","V12"
"k19","电压13","V13"
"k20","电压14","V14"
"k21","电压15","V15"
"k22","电压16","V16"
"k23","电压17","V17"
"k24","电压18","V18"
"k25","电压19","V19"
"k26","电压20","V20"

"k27","电压21","V21"
"k28","电压22","V22"
"k29","电压23","V23"
"k30","电压24","V24"
"k31","电压25","V25"
"k32","电压26","V26"
"k33","电压27","V27"
"k34","电压28","V28"
"k35","电压29","V29"
"k36","电压30","V30"

"k37","电压31","V31"
"k38","电压32","V32"
"k39","电压33","V33"
"k40","电压34","V34"
"k41","电压35","V35"
"k42","电压36","V36"
"k43","电压37","V37"
"k44","电压38","V38"
"k45","电压39","V39"
"k46","电压40","V40"

"k47","电压41","V41"
"k48","电压42","V42"
"k49","电压43","V43"
"k50","电压44","V44"
"k51","电压45","V45"
"k52","电压46","V46"
"k53","电压47","V47"
"k54","电压48","V48"
"k55","电压49","V49"
"k56","电压50","V50"

"k57","温度1","T1"
"k58","温度2","T2"
"k59","温度3","T3"
"k60","温度4","T4"
"k61","温度5","T5"
"k62","温度6","T6"
"k63","温度7","T7"
"k64","温度8","T8"
"k65","温度9","T9"
"k66","温度10","T10"

"k67","温度11","T11"
"k68","温度12","T12"
"k69","温度13","T13"
"k70","温度14","T14"
"k71","温度15","T15"
"k72","温度16","T16"
"k73","温度17","T17"
"k74","温度18","T18"
"k75","温度19","T19"
"k76","温度20","T20"

"k77","温度21","T21"
"k78","温度22","T22"
"k79","温度23","T23"
"k80","温度24","T24"
"k81","温度25","T25"
"k82","温度26","T26"
"k83","温度27","T27"
"k84","温度28","T28"
"k85","温度29","T29"
"k86","温度30","T30"

"k87","温度31","T31"
"k88","温度32","T32"
"k89","温度33","T33"
"k90","温度34","T34"
"k91","温度35","T35"
"k92","温度36","T36"
"k93","温度37","T37"
"k94","温度38","T38"
"k95","温度39","T39"
"k96","温度40","T40"

"k97","温度41","T41"
"k98","温度42","T42"
"k99","温度43","T43"
"k100","温度44","T44"
"k101","温度45","T45"
"k102","温度46","T46"
"k103","温度47","T47"
"k104","温度48","T48"
"k105","温度49","T49"
"k106","温度50","T50"

"k107","电压51","V51"
"k108","电压52","V52"
"k109","电压53","V53"
"k110","电压54","V54"
"k111","电压55","V55"
"k112","电压56","V56"
"k113","电压57","V57"
"k114","电压58","V58"
"k115","电压59","V59"
"k116","电压60","V60"

"k117","电压61","V61"
"k118","电压62","V62"
"k119","电压63","V63"
"k120","电压64","V64"
"k121","电压65","V65"
"k122","电压66","V66"
"k123","电压67","V67"
"k124","电压68","V68"
"k125","电压69","V69"
"k126","电压70","V70"

"k127","电压71","V71"
"k128","电压72","V72"
"k129","电压73","V73"
"k130","电压74","V74"
"k131","电压75","V75"
"k132","电压76","V76"
"k133","电压77","V77"
"k134","电压78","V78"
"k135","电压79","V79"
"k136","电压80","V80"

"k137","温度51","T51"
"k138","温度52","T52"
"k139","温度53","T53"
"k140","温度54","T54"
"k141","温度55","T55"
"k142","温度56","T56"
"k143","温度57","T57"
"k144","温度58","T58"
"k145","温度59","T59"
"k146","温度60","T60"

"k147","温度61","T61"
"k148","温度62","T62"
"k149","温度63","T63"
"k150","温度64","T64"
"k151","温度65","T65"
"k152","温度66","T66"
"k153","温度67","T67"
"k154","温度68","T68"
"k155","温度69","T69"
"k156","温度70","T70"

"k157","温度71","T71"
"k158","温度72","T72"
"k159","温度73","T73"
"k160","温度74","T74"
"k161","温度75","T75"
"k162","温度76","T76"
"k163","温度77","T77"
"k164","温度78","T78"
"k165","温度79","T79"
"k166","温度80","T80"

通信json格式

{
	"cmd": "put",
	"data": {
		"tab": "communication",
		"tags": {
			"wsn": "IPC_OP150",
			"esn": "eol001",
			"psn": "08IPBBC00000000000000010",
			"usn": "wangyong",
			"differentialPressure": "144",
			"temperatureDifference": "0",
			"time": "2021-07-16 17:13:58",
			"testResult": "NG"
		},
		"fields": {
			"voltages": {
				"V1": "3.149",
				"V2": "3.245",
				"V3": "3.293",
				"V4": "3.293",
				"V5": "3.293",
				"V6": "3.293",
				"V7": "3.292",
				"V8": "3.291",
				"V9": "3.287"
			},
			"temperatures": {
				"T1": "24",
				"T2": "24",
				"T3": "24"
			}
		}
	}
}