Difference between revisions of "Public.snmpinterface (table)"

From dbscript Online Help
Jump to: navigation, search
Line 123: Line 123:
 
|- valign="top"
 
|- valign="top"
 
| snmpinterface_nodeid_ifindex_unique_idx
 
| snmpinterface_nodeid_ifindex_unique_idx
| Unique
+
|  
 
| nodeid, snmpifindex
 
| nodeid, snmpifindex
 
|}
 
|}
Line 142: Line 142:
 
| snmpinterfaceid
 
| snmpinterfaceid
 
| id
 
| id
|}
 
 
=== Dependencies ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
| '''Reference Type
 
| '''Object Type
 
| '''Referencing Object
 
 
|- valign="top"
 
| Select
 
| Trigger Function
 
| [[public.setsnmpinterfacekeysoninsert_(trigger function)|public.setsnmpinterfacekeysoninsert]]
 
 
|- valign="top"
 
| Select
 
| Trigger Function
 
| [[public.setsnmpinterfacekeysonupdate_(trigger function)|public.setsnmpinterfacekeysonupdate]]
 
 
 
|}
 
|}

Revision as of 10:20, 27 August 2011

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