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

From dbscript Online Help
Jump to: navigation, search
Line 9: Line 9:
  
  
 +
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 16:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
 
 
 
 
|-
 
|-
Line 23: Line 23:
 
| not null
 
| not null
 
| nextval('opennmsnxtid'::regclass)
 
| nextval('opennmsnxtid'::regclass)
−
| ipinterface_pkey
 
 
|  
 
|  
 
|-
 
|-
Line 31: Line 30:
 
|  
 
|  
 
|  
 
|  
−
| ipinterface_nodeid_ipaddr_notzero_idxipinterface_nodeid_idxipinterface_nodeid_ipaddr_ismanaged_idx
 
 
|-
 
|-
 
| ipaddr
 
| ipaddr
Line 38: Line 36:
 
|  
 
|  
 
|  
 
|  
−
| ipinterface_nodeid_ipaddr_notzero_idxipinterface_nodeid_ismanaged_idxipinterface_ipaddr_idxipinterface_ipaddr_ismanaged_idxipinterface_nodeid_ipaddr_ismanaged_idx
 
 
|-
 
|-
 
| ifindex
 
| ifindex
 
| integer
 
| integer
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 50: Line 46:
 
| varchar(256)
 
| varchar(256)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 59: Line 54:
 
|  
 
|  
 
|  
 
|  
−
| ipinterface_ipaddr_ismanaged_idxipinterface_nodeid_ipaddr_ismanaged_idx
 
 
|-
 
|-
 
| ipstatus
 
| ipstatus
 
| integer
 
| integer
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 71: Line 64:
 
| timestamp with time zone
 
| timestamp with time zone
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 78: Line 70:
 
| char(1)
 
| char(1)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 87: Line 78:
 
|  
 
|  
 
|  
 
|  
−
| ipinterface_snmpinterfaceid_idx
 
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|-
 +
| ipinterface_pkey
 +
| id
 +
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|-
 +
| ipinterface_nodeid_ipaddr_notzero_idx
 +
| Unique
 +
| nodeid, ipaddr
 +
|-
 +
| ipinterface_snmpinterfaceid_idx
 +
|
 +
| snmpinterfaceid
 +
|-
 +
| ipinterface_nodeid_ismanaged_idx
 +
|
 +
| ipaddr
 +
|-
 +
| ipinterface_ipaddr_idx
 +
|
 +
| ipaddr
 +
|-
 +
| ipinterface_ipaddr_ismanaged_idx
 +
|
 +
| ipaddr, ismanaged
 +
|-
 +
| ipinterface_nodeid_idx
 +
|
 +
| nodeid
 +
|-
 +
| ipinterface_nodeid_ipaddr_ismanaged_idx
 +
|
 +
| nodeid, ipaddr, ismanaged
 +
|}
  
 +
=== Foreign Keys ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 108: Line 144:
 
|}
 
|}
  
−
 
+
=== Detail Tables ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 122: Line 158:
  
  
 +
=== Triggers ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 136: Line 173:
 
| ROW BEFORE UPDATE
 
| ROW BEFORE UPDATE
 
| setsnmpinterfacekeysonupdate
 
| setsnmpinterfacekeysonupdate
 +
|}
 +
 +
=== Dependencies ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|-
 +
| Select
 +
| Function
 +
| [[public.getmanagedoutageforintfinwindow_(function)|public.getmanagedoutageforintfinwindow]]
 +
 +
|-
 +
| Select
 +
| Function
 +
| [[public.getmanagedoutagefornodeinwindow_(function)|public.getmanagedoutagefornodeinwindow]]
 +
 +
|-
 +
| Select
 +
| Function
 +
| [[public.getmanagedservicecountforintf_(function)|public.getmanagedservicecountforintf]]
 +
 +
|-
 +
| Select
 +
| Function
 +
| [[public.getmanagedservicecountfornode_(function)|public.getmanagedservicecountfornode]]
 +
 +
|-
 +
| Select
 +
| Trigger Function
 +
| [[public.setipinterfacekeysoninsert_(trigger_function)|public.setipinterfacekeysoninsert]]
 +
 +
|-
 +
| Select
 +
| Trigger Function
 +
| [[public.setipinterfacekeysonupdate_(trigger_function)|public.setipinterfacekeysonupdate]]
 +
 
|}
 
|}

Revision as of 08:31, 11 February 2010

wikibot

Table public.ipinterface


Columns

Column Data Type Nullable Default Description
id integer not null nextval('opennmsnxtid'::regclass)
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_nodeid_ipaddr_notzero_idx Unique nodeid, ipaddr
ipinterface_snmpinterfaceid_idx snmpinterfaceid
ipinterface_nodeid_ismanaged_idx ipaddr
ipinterface_ipaddr_idx ipaddr
ipinterface_ipaddr_ismanaged_idx ipaddr, ismanaged
ipinterface_nodeid_idx nodeid
ipinterface_nodeid_ipaddr_ismanaged_idx nodeid, ipaddr, ismanaged

Foreign Keys

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

Detail Tables

Detail Table Column Referencing Column
public.ifservices id ipinterfaceid


Triggers

Triggers Type Function
setsnmpinterfacekeysoninserttrigger ROW BEFORE INSERT setsnmpinterfacekeysoninsert
setsnmpinterfacekeysonupdatetrigger ROW BEFORE UPDATE setsnmpinterfacekeysonupdate

Dependencies

Reference Type Object Type Referencing Object
Select Function public.getmanagedoutageforintfinwindow
Select Function public.getmanagedoutagefornodeinwindow
Select Function public.getmanagedservicecountforintf
Select Function public.getmanagedservicecountfornode
Select Trigger Function public.setipinterfacekeysoninsert
Select Trigger Function public.setipinterfacekeysonupdate
Retrieved from "http://dbshelp.devio.at/index.php?title=Public.ipinterface_(table)&oldid=2362"