monitored_areas


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
aggregated_movements.area_id fkrktppka7cjdkx2u65xx2k71eg R
aggregated_trajectories.area_id fkkaevl15e8hps569eu2xwjv94t R
screenshots.area_id fkmy94ykomgw3uebmjhgowb2crn R
zone_sequences.monitored_area_id fke2ivrb0ke7nhlf9dto4sn5hr4 R
zones.area_id fkk7uyctqapp9grsaf050yk007a R
active bool 1 √ null
device_latitude float8 17,17 √ null
device_longitude float8 17,17 √ null
area_name varchar 255 √ null
detection_parameters_id uuid 2147483647 √ null
detection_parameters.id fkim5dj1mwupcrqq235tmsob2rq R
device_id uuid 2147483647 √ null
device.id fk6gbtmqat4r3ec93933aqmffq8 R

Table contained 3 rows

Indexes

Constraint Name Type Sort Column(s)
monitored_areas_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation