Public.snmpinterface (table)

From dbscript Online Help
Revision as of 23:39, 24 June 2010 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Table public.snmpinterface

Columns

Column Data Type Nullable Default Description
id integer not null nextval('opennmsnxtid'::regclass)
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_nodeid_ifindex_unique_idx Unique nodeid, snmpifindex
snmpinterface_ipaddr_idx ipaddr
snmpinterface_nodeid_idx nodeid

Foreign Keys

Relation Column Referenced Column
public.node nodeid nodeid

Detail Tables

Detail Table Column Referencing Column
public.ipinterface id snmpinterfaceid

Dependencies

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