Public.snmpinterface (table)

From dbscript Online Help
Revision as of 10:20, 27 August 2011 by Bot (talk | contribs)
Jump to: navigation, search

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
public.snmpinterface snmpinterfaceid id