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		nodeid, snmpifindex

Foreign Keys ¶

Relation	Column	Referenced Column
public.node	nodeid	nodeid

Detail Tables ¶

Detail Table	Column	Referencing Column
public.ipinterface	id	snmpinterfaceid