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

From dbscript Online Help
Jump to: navigation, search
Line 113: Line 113:
 
|- valign="top"
 
|- valign="top"
 
| ipinterface_nodeid_ipaddr_notzero_idx
 
| ipinterface_nodeid_ipaddr_notzero_idx
−
| Unique
+
|  
 
| nodeid, ipaddr
 
| nodeid, ipaddr
 
|- valign="top"
 
|- valign="top"
Line 155: Line 155:
 
|- valign="top"
 
|- valign="top"
 
| setsnmpinterfacekeysoninserttrigger
 
| setsnmpinterfacekeysoninserttrigger
−
| ROW BEFORE INSERT
+
| STATEMENT AFTER
 
| setsnmpinterfacekeysoninsert
 
| setsnmpinterfacekeysoninsert
 
|- valign="top"
 
|- valign="top"
 
| setsnmpinterfacekeysonupdatetrigger
 
| setsnmpinterfacekeysonupdatetrigger
−
| ROW BEFORE UPDATE
+
| STATEMENT AFTER
 
| setsnmpinterfacekeysonupdate
 
| setsnmpinterfacekeysonupdate
−
|}
 
−
 
−
=== Dependencies ===
 
−
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
−
|- style="background:silver"
 
−
| '''Reference Type
 
−
| '''Object Type
 
−
| '''Referencing Object
 
−
 
−
|- valign="top"
 
−
| Select
 
−
| Function
 
−
| [[public.getmanagedoutageforintfinwindow_(function)|public.getmanagedoutageforintfinwindow]]
 
−
 
−
|- valign="top"
 
−
| Select
 
−
| Function
 
−
| [[public.getmanagedoutagefornodeinwindow_(function)|public.getmanagedoutagefornodeinwindow]]
 
−
 
−
|- valign="top"
 
−
| Select
 
−
| Function
 
−
| [[public.getmanagedservicecountforintf_(function)|public.getmanagedservicecountforintf]]
 
−
 
−
|- valign="top"
 
−
| Select
 
−
| Function
 
−
| [[public.getmanagedservicecountfornode_(function)|public.getmanagedservicecountfornode]]
 
−
 
−
|- valign="top"
 
−
| Select
 
−
| Trigger Function
 
−
| [[public.setipinterfacekeysoninsert_(trigger function)|public.setipinterfacekeysoninsert]]
 
−
 
−
|- valign="top"
 
−
| Select
 
−
| Trigger Function
 
−
| [[public.setipinterfacekeysonupdate_(trigger function)|public.setipinterfacekeysonupdate]]
 
−
 
 
|}
 
|}

Revision as of 10:19, 27 August 2011

wikibot

Table public.ipinterface

Columns

Column Data Type Nullable Default Description
id integer not null
nodeid integer not null
ipaddr varchar(16) not null
ifindex integer null
iphostname varchar(256) null
ismanaged char(1) null
ipstatus integer null
iplastcapsdpoll timestamp with time zone null
issnmpprimary char(1) null
snmpinterfaceid integer null

Primary Key

Primary Key Columns
ipinterface_pkey id

Indexes

Index Type Columns
ipinterface_ipaddr_idx ipaddr
ipinterface_ipaddr_ismanaged_idx ipaddr, ismanaged
ipinterface_nodeid_idx nodeid
ipinterface_nodeid_ipaddr_ismanaged_idx nodeid, ipaddr, ismanaged
ipinterface_nodeid_ipaddr_notzero_idx nodeid, ipaddr
ipinterface_nodeid_ismanaged_idx ipaddr
ipinterface_snmpinterfaceid_idx snmpinterfaceid

Foreign Keys

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

Triggers

Trigger Type Function
setsnmpinterfacekeysoninserttrigger STATEMENT AFTER setsnmpinterfacekeysoninsert
setsnmpinterfacekeysonupdatetrigger STATEMENT AFTER setsnmpinterfacekeysonupdate
Retrieved from "http://dbshelp.devio.at/index.php?title=Public.ipinterface_(table)&oldid=2998"