observer
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
device_snmpalias
Columns
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
zone_id
int4
10
null
device_id
int4
10
null
device
.id
fk_device_alias_device
C
snmpalias_id
int4
10
null
snmpalias
.id
fk_device_alias_alias
C
last_update
timestamptz
35,6
√
now()
Table contained
0
rows
Indexes
Constraint Name
Type
Sort
Column(s)
pk_device_alias
Primary key
Asc
/
Asc
device_id + snmpalias_id
Relationships
Close relationships within degrees of separation
One
Two degrees