Database

Table battery

Name	Type	Null?	Key?	Extra
id	int(11)	NO	PRI	auto_increment
nodeId	varchar(255)	NO	MUL
voltage	float	NO
timestamp	timestamp	NO		on update current_timestamp()

Table current

Name	Type	Null?	Key?	Extra
id	int(11)	NO	PRI	auto_increment
sensorId	varchar(255)	NO
sensorName	varchar(255)	NO
nodeId	varchar(255)	NO
nodeName	varchar(255)	NO
timestamp	timestamp	NO		on update current_timestamp()
sensorValue	float	NO
battery	float	NO
isActive	int(11)	NO
liveness	int(11)	NO
typicalInterval	int(11)	NO

Table humidity

Name	Type	Null?	Key?	Extra
id	int(11)	NO	PRI	auto_increment
sensorId	varchar(255)	NO
value	float	NO
timestamp	timestamp	NO		on update current_timestamp()
nodeId	varchar(255)	NO

Table nodes

Name	Type	Null?	Key?	Extra
id	int(11)	NO	PRI	auto_increment
nodeId	varchar(255)	NO
nodeName	varchar(255)	NO
isActive	int(11)	NO
powerSource	int(11)	NO

Table oil

Name	Type	Null?	Key?	Extra
id	int(11)	NO	PRI	auto_increment
sensorId	varchar(255)	NO
value	float	NO
timestamp	timestamp	NO		on update current_timestamp()
nodeId	varchar(255)	NO	MUL

Table sensors

Name	Type	Null?	Key?	Extra
id	int(11)	NO	PRI	auto_increment
sensorId	varchar(255)	NO
sensorName	varchar(255)	NO
isActive	int(11)	NO

Table temperatures

Name	Type	Null?	Key?	Extra
id	int(11)	NO	PRI	auto_increment
sensorId	varchar(255)	NO
value	float	NO
timestamp	timestamp	NO		on update current_timestamp()
nodeId	varchar(255)	NO	MUL

Table weights

Name	Type	Null?	Key?	Extra
id	int(11)	NO	PRI	auto_increment
timestamp	timestamp	NO		on update current_timestamp()
personId	int(11)	NO
value	float	NO
nodeId	varchar(255)	NO
sensorId	varchar(255)	NO