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

From dbscript Online Help
Jump to: navigation, search
 
(4 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| public.ipinterface
 
| public.ipinterface
−
|-
 
 
|}
 
|}
  
−
 
+
=== 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 14:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| id
 
| id
 
| integer
 
| integer
 
| not null
 
| not null
−
| nextval('opennmsnxtid'::regclass)
 
−
| ipinterface_pkey
 
 
|  
 
|  
−
|-
+
|
 +
|- valign="top"
 
| nodeid
 
| nodeid
 
| integer
 
| integer
Line 31: Line 28:
 
|  
 
|  
 
|  
 
|  
−
| ipinterface_nodeid_ipaddr_notzero_idxipinterface_nodeid_idxipinterface_nodeid_ipaddr_ismanaged_idx
+
|- valign="top"
−
|-
 
 
| ipaddr
 
| ipaddr
 
| varchar(16)
 
| varchar(16)
Line 38: Line 34:
 
|  
 
|  
 
|  
 
|  
−
| ipinterface_nodeid_ipaddr_notzero_idxipinterface_nodeid_ismanaged_idxipinterface_ipaddr_idxipinterface_ipaddr_ismanaged_idxipinterface_nodeid_ipaddr_ismanaged_idx
+
|- valign="top"
−
|-
 
 
| ifindex
 
| ifindex
 
| integer
 
| integer
Line 45: Line 40:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| iphostname
 
| iphostname
 
| varchar(256)
 
| varchar(256)
Line 52: Line 46:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| ismanaged
 
| ismanaged
 
| char(1)
 
| char(1)
Line 59: Line 52:
 
|  
 
|  
 
|  
 
|  
−
| ipinterface_ipaddr_ismanaged_idxipinterface_nodeid_ipaddr_ismanaged_idx
+
|- valign="top"
−
|-
 
 
| ipstatus
 
| ipstatus
 
| integer
 
| integer
Line 66: Line 58:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| iplastcapsdpoll
 
| iplastcapsdpoll
 
| timestamp with time zone
 
| timestamp with time zone
Line 73: Line 64:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| issnmpprimary
 
| issnmpprimary
 
| char(1)
 
| char(1)
Line 80: Line 70:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| snmpinterfaceid
 
| snmpinterfaceid
 
| integer
 
| integer
Line 87: Line 76:
 
|  
 
|  
 
|  
 
|  
−
| ipinterface_snmpinterfaceid_idx
 
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| ipinterface_pkey
 +
| id
 +
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
  
 +
|- valign="top"
 +
| ipinterface_ipaddr_idx
 +
|
 +
| ipaddr
 +
|- valign="top"
 +
| ipinterface_ipaddr_ismanaged_idx
 +
|
 +
| ipaddr, ismanaged
 +
|- valign="top"
 +
| ipinterface_nodeid_idx
 +
|
 +
| nodeid
 +
|- valign="top"
 +
| ipinterface_nodeid_ipaddr_ismanaged_idx
 +
|
 +
| nodeid, ipaddr, ismanaged
 +
|- valign="top"
 +
| ipinterface_nodeid_ipaddr_notzero_idx
 +
|
 +
| nodeid, ipaddr
 +
|- valign="top"
 +
| ipinterface_nodeid_ismanaged_idx
 +
|
 +
| ipaddr
 +
|- valign="top"
 +
| ipinterface_snmpinterfaceid_idx
 +
|
 +
| snmpinterfaceid
 +
|}
 +
 +
=== 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 97: Line 131:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
−
+
 
−
|-
+
|- valign="top"
 
| [[public.node_(table)|public.node]]
 
| [[public.node_(table)|public.node]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.snmpinterface_(table)|public.snmpinterface]]
 
| [[public.snmpinterface_(table)|public.snmpinterface]]
 
| snmpinterfaceid
 
| snmpinterfaceid
Line 108: Line 142:
 
|}
 
|}
  
−
 
+
=== 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 114: Line 148:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[public.ifservices_(table)|public.ifservices]]
 
| [[public.ifservices_(table)|public.ifservices]]
 
| id
 
| id
Line 121: Line 155:
 
|}
 
|}
  
−
 
+
=== 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"
−
| '''Triggers
+
| '''Trigger
 
| '''Type
 
| '''Type
 
| '''Function
 
| '''Function
−
+
 
−
|-
+
|- valign="top"
 
| setsnmpinterfacekeysoninserttrigger
 
| setsnmpinterfacekeysoninserttrigger
−
| ROW BEFORE INSERT
+
| STATEMENT AFTER
 
| setsnmpinterfacekeysoninsert
 
| setsnmpinterfacekeysoninsert
−
|-
+
|- valign="top"
 
| setsnmpinterfacekeysonupdatetrigger
 
| setsnmpinterfacekeysonupdatetrigger
−
| ROW BEFORE UPDATE
+
| STATEMENT AFTER
 
| setsnmpinterfacekeysonupdate
 
| setsnmpinterfacekeysonupdate
 
|}
 
|}

Latest revision as of 11:25, 27 August 2011

wikibot[edit]

Table public.ipinterface

Columns[edit]

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[edit]

Primary Key Columns
ipinterface_pkey id

Indexes[edit]

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[edit]

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

Detail Tables[edit]

Detail Table Column Referencing Column
public.ifservices id ipinterfaceid

Triggers[edit]

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