PolyFixHCF700Calibration/DBTabl.sql at master · sxpsxp12/PolyFixHCF700Calibration · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
/*********
** node_info：节点信息
** addr: 地址
** version:版本
** range: 量程(KPa)
***********/
CREATE TABLE IF NOT EXISTS node_info(
	sn VARCHAR(20) UNIQUE,
	addr int,
	version int,
	range int
);

/*************************
**full_payload:满量程负载数据
** temp:温度
** pressure:实际压强
** ref_pressure:参照压强
** div_pressure:压强偏差
**************************/
CREATE TABLE IF NOT EXISTS full_payload(
	unix_time double UNIQUE,
	temp double,
	pressure double,
	ref_pressure double,
	div_pressure double
);


/*************************
**four_fifth_payload:五分之四量程负载数据
** temp:温度
** pressure:实际压强
** ref_pressure:参照压强
** div_pressure:压强偏差
**************************/
CREATE TABLE IF NOT EXISTS four_fifth_payload(
	unix_time double UNIQUE,
	temp double,
	pressure double,
	ref_pressure double,
	div_pressure double
);


/*************************
**three_fifth_payload:五分之三量程负载数据
** temp:温度
** pressure:实际压强
** ref_pressure:参照压强
** div_pressure:压强偏差
**************************/
CREATE TABLE IF NOT EXISTS three_fifth_payload(
	unix_time double UNIQUE,
	temp double,
	pressure double,
	ref_pressure double,
	div_pressure double
);


/*************************
**two_fifth_payload:五分之二量程负载数据
** temp:温度
** pressure:实际压强
** ref_pressure:参照压强
** div_pressure:压强偏差
**************************/
CREATE TABLE IF NOT EXISTS two_fifth_payload(
	unix_time double UNIQUE,
	temp double,
	pressure double,
	ref_pressure double,
	div_pressure double
);


/*************************
**one_fifth_payload:五分之一量程负载数据
** temp:温度
** pressure:实际压强
** ref_pressure:参照压强
** div_pressure:压强偏差
**************************/
CREATE TABLE IF NOT EXISTS one_fifth_payload(
	unix_time double UNIQUE,
	temp double,
	pressure double,
	ref_pressure double,
	div_pressure double
);


/*************************
**zero_payload:零量程负载数据
** temp:温度
** pressure:实际压强
** ref_pressure:参照压强
** div_pressure:压强偏差
**************************/
CREATE TABLE IF NOT EXISTS zero_payload(
	unix_time double UNIQUE,
	temp double,
	pressure double,
	ref_pressure double,
	div_pressure double
);