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: [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: [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_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_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))
1513801	4	2021-05-22	23	0	566	0	0
1513800	4	2021-05-22	22	59	566	1	3
1513799	4	2021-05-22	22	58	568	5	2
1513798	4	2021-05-22	22	57	565	4	1
1513797	4	2021-05-22	22	56	562	0	1
1513796	4	2021-05-22	22	55	563	2	1
1513795	4	2021-05-22	22	54	562	0	1
1513794	4	2021-05-22	22	53	563	2	2
1513793	4	2021-05-22	22	52	563	2	1
1513792	4	2021-05-22	22	51	562	3	4

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

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))	DATA(datetime)

Pagina Inicial Do Projecto PEI-PASMO