Public.snmpinterface (table)

wikibot

Table

public.snmpinterface

Columns

Column	Data Type	Nullable	Default	Description
id	integer	not null
nodeid	integer	not null
ipaddr	varchar(16)	not null
snmpipadentnetmask	varchar(16)	null
snmpphysaddr	char(12)	null
snmpifindex	integer	not null
snmpifdescr	varchar(256)	null
snmpiftype	integer	null
snmpifname	varchar(96)	null
snmpifspeed	bigint	null
snmpifadminstatus	integer	null
snmpifoperstatus	integer	null
snmpifalias	varchar(256)	null

Primary Key

Primary Key	Columns
snmpinterface_pkey	id

Indexes

Index	Type	Columns
snmpinterface_ipaddr_idx		ipaddr
snmpinterface_nodeid_idx		nodeid
snmpinterface_nodeid_ifindex_unique_idx	Unique	nodeid, snmpifindex

Foreign Keys

Relation	Column	Referenced Column
public.node	nodeid	nodeid
public.snmpinterface	snmpinterfaceid	id

Dependencies

Reference Type	Object Type	Referencing Object
Select	Trigger Function	public.setsnmpinterfacekeysoninsert
Select	Trigger Function	public.setsnmpinterfacekeysonupdate