Columns

Columns

Table	Type	Column	Type	Size	Nulls	Auto	Default	Comments
monitored_areas	Table	area_name	varchar	255	√		null
aggregated_trajectories	Table	fromx	int4	10	√		null
movements	Table	transit_id	uuid	2147483647	√		null
zones	Table	world_vertices	json	2147483647	√		null
device	Table	id	uuid	2147483647			null
statistics	Table	statistics_id	uuid	2147483647			null
aggregated_movements	Table	area_id	uuid	2147483647	√		null
aggregated_movements	Table	time	timestamptz	35	√		null
movements	Table	id	uuid	2147483647			null
zone_sequences	Table	active	bool	1	√		null
statistics	Table	time_since	timestamptz	35	√		null
movements	Table	velocity	json	2147483647	√		null
aggregated_trajectories	Table	toy	int4	10	√		null
aggregated_trajectories	Table	weight	int4	10	√		null
aggregated_trajectories	Table	tox	int4	10	√		null
movements	Table	velocity_y	float8	17	√		null
aggregated_trajectories	Table	from_x	int4	10	√		null
screenshots	Table	id	uuid	2147483647			null
zones	Table	zone_name	varchar	255	√		null
movements	Table	position_y	int4	10	√		null
aggregated_movements	Table	id	uuid	2147483647			null
transits	Table	transit_end	timestamptz	35	√		null
aggregated_movements	Table	weight	int4	10	√		null
aggregated_trajectories	Table	to_x	int4	10	√		null
transits	Table	receive_time	timestamptz	35	√		null
zones	Table	camera_vertices	json	2147483647	√		null
monitored_areas	Table	active	bool	1	√		null
aggregated_movements	Table	speed	float8	17	√		null
aggregated_trajectories	Table	to_y	int4	10	√		null
movements	Table	velocity_x	float8	17	√		null
zones	Table	active	bool	1	√		null
movements	Table	diff	float8	17	√		null
device	Table	name	varchar	255	√		null
aggregated_trajectories	Table	from_y	int4	10	√		null
zone_sequences	Table	zone_numbers	_int4	10	√		null
transits	Table	zone_sequence_id	uuid	2147483647	√		null
monitored_areas	Table	detection_parameters_id	uuid	2147483647	√		null
monitored_areas	Table	device_latitude	float8	17	√		null
aggregated_movements	Table	position_y	int4	10	√		null
zone_sequences	Table	monitored_area_id	uuid	2147483647	√		null
movements	Table	time	timestamptz	35	√		null
monitored_areas	Table	device_longitude	float8	17	√		null
movements	Table	position_x	int4	10	√		null
statistics	Table	zone_sequence_id	uuid	2147483647	√		null
movements	Table	position	json	2147483647	√		null
aggregated_trajectories	Table	fromy	int4	10	√		null
screenshots	Table	area_id	uuid	2147483647			null
detection_parameters	Table	detector_min_contour_height	int4	10	√		null
zones	Table	zone_number	int4	10			null
detection_parameters	Table	id	uuid	2147483647			null
zone_sequences	Table	zone_sequence_id	uuid	2147483647			null
screenshots	Table	data	bytea	2147483647			null
aggregated_trajectories	Table	speed	float8	17	√		null
transits	Table	transit_id	uuid	2147483647			null
monitored_areas	Table	device_id	uuid	2147483647	√		null
aggregated_trajectories	Table	area_id	uuid	2147483647			null
aggregated_trajectories	Table	time	timestamptz	35	√		null
transits	Table	transit_start	timestamptz	35	√		null
aggregated_trajectories	Table	id	uuid	2147483647			null
statistics	Table	vehicle_passed	int8	19	√		null
detection_parameters	Table	detector_min_contour_width	int4	10	√		null
monitored_areas	Table	id	uuid	2147483647			null
zone_sequences	Table	name	varchar	255	√		null
aggregated_movements	Table	position_x	int4	10	√		null
movements	Table	speed	float8	17	√		null
aggregated_trajectories	Table	points	json	2147483647	√		null
zones	Table	area_id	uuid	2147483647			null