fjunior.f2mobile.eu

Tabela: [PASMO_Occupation] -> Numero Registos Tabela = 10 CONDICAO = ORDER BY ID DESC LIMIT 10

ID(int(11))	day(int(11))	free(int(11))	hour(int(11))	taken(int(11))	DATA(datetime)
744	23	35	23	227	2020-06-23 23:04:41
743	23	33	22	231	2020-06-23 22:04:44
742	23	27	21	239	2020-06-23 21:04:49
741	23	25	20	246	2020-06-23 20:04:41
740	23	35	19	232	2020-06-23 19:04:46
739	23	36	18	235	2020-06-23 18:04:36
738	23	41	17	230	2020-06-23 17:04:18
737	23	22	16	248	2020-06-23 16:04:27
736	23	23	15	245	2020-06-23 15:04:21
735	23	18	14	251	2020-06-23 14:04:47

Tabela: [PASMO_Parking] -> Numero Registos Tabela = 10 CONDICAO = ORDER BY ID DESC LIMIT 10

ID(int(11))	sensor_id(int(11))	status(int(11))	timestamp(text)	lat(varchar(50))	lng(varchar(50))
470469	300687	1	2020-04-03T11:25:50.546Z	?	?
470468	301265	1	2020-04-03T11:25:50.505Z	?	?
470467	301069	1	2020-04-03T11:25:50.44Z	?	?
470466	301204	1	2020-04-03T11:25:34.305Z	?	?
470465	300605	0	2020-04-03T11:25:34.255Z	?	?
470464	301079	0	2020-04-03T11:25:34.186Z	?	?
470463	300606	0	2020-04-03T11:25:34.132Z	?	?
470462	300687	1	2020-04-03T11:25:34.089Z	?	?
470461	301133	1	2020-04-03T11:25:34.043Z	?	?
470460	301069	1	2020-04-03T11:25:34.003Z	?	?

Tabela: [PASMO_Radars] -> Numero Registos Tabela = 1 CONDICAO = ORDER BY ID DESC LIMIT 10

ID(int(11))	radar_id(int(11))	object_id(int(11))	lat(varchar(50))	lng(varchar(50))	xSpeed(int(11))	ySpeed(int(11))	xPoint(int(11))	yPoint(int(11))	oLength(int(11))
1	1	1	trytry	tryrty	2	3	4	5	6

Tabela: [PASMO_Radars_Event] -> Numero Registos Tabela = 10 CONDICAO = ORDER BY ID DESC LIMIT 10

ID(int(11))	ID_REGION(int(11))	DATA(date)	HORA(int(11))	MINUTO(int(11))	CARS(int(11))	CARS_IN(int(11))	CARS_OUT(int(11))
1414372	5	2020-12-27	0	0	3	0	0
1414371	5	2020-12-26	23	59	3	0	0
1414370	5	2020-12-26	23	58	3	0	0
1414369	5	2020-12-26	23	57	3	0	1
1414368	5	2020-12-26	23	56	4	0	1
1414367	5	2020-12-26	23	55	5	0	1
1414366	5	2020-12-26	23	54	6	0	0
1414365	5	2020-12-26	23	53	6	2	0
1414364	5	2020-12-26	23	52	4	0	0
1414363	5	2020-12-26	23	51	4	1	0

Tabela: [PASMO_Regions] -> Numero Registos Tabela = 5 CONDICAO = ORDER BY ID DESC LIMIT 10

Tabela: [RadarData] -> Numero Registos Tabela = 0 CONDICAO = ORDER BY ID DESC LIMIT 10

radarID(varchar(10))	carIn(int(11))	carOut(int(11))	timestamp(int(11))

Tabela: [VehicleData] -> Numero Registos Tabela = 0 CONDICAO = ORDER BY ID DESC LIMIT 10

radarID(varchar(10))	type(varchar(10))	value(int(11))	timestamp(int(11))

Pagina Inicial Do Projecto PEI-PASMO