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

From dbscript Online Help
Jump to: navigation, search
 
(6 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.ifservices
 
| public.ifservices
−
|-
 
 
|}
 
|}
  
−
 
+
=== 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
 +
| not null
 
|  
 
|  
−
| not null
 
−
| nextval('opennmsnxtid'::regclass)
 
−
| ifservices_pkey
 
 
|  
 
|  
−
|-
+
|- valign="top"
 
| nodeid
 
| nodeid
−
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
| ifservices_nodeid_ipaddr_svc_uniqueifservices_nodeid_ipaddr_statusifservices_nodeid_statusifservices_nodeid_idxifservices_nodeid_serviceid_idx
+
|- valign="top"
−
|-
 
 
| ipaddr
 
| ipaddr
−
|  
+
| varchar(16)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
| ifservices_nodeid_ipaddr_svc_uniqueifservices_nodeid_ipaddr_status
+
|- valign="top"
−
|-
 
 
| ifindex
 
| ifindex
−
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| serviceid
 
| serviceid
−
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
−
| ifservices_nodeid_ipaddr_svc_uniqueifservices_serviceid_idxifservices_nodeid_serviceid_idx
+
|- valign="top"
−
|-
 
 
| lastgood
 
| lastgood
−
|  
+
| timestamp with time zone
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| lastfail
 
| lastfail
−
|  
+
| timestamp with time zone
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| qualifier
 
| qualifier
−
|  
+
| char(16)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| status
 
| status
−
|  
+
| char(1)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
−
| ifservices_nodeid_ipaddr_statusifservices_nodeid_status
+
|- valign="top"
−
|-
 
 
| source
 
| source
 +
| char(1)
 +
| null
 
|  
 
|  
 +
|
 +
|- valign="top"
 +
| notify
 +
| char(1)
 
| null
 
| null
 
|  
 
|  
 
|  
 
|  
 +
|- valign="top"
 +
| ipinterfaceid
 +
| integer
 +
| not null
 
|  
 
|  
−
|-
 
−
| notify
 
 
|  
 
|  
−
| null
+
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| ifservices_pkey
 +
| id
 +
|}
 +
 
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 
 +
|- valign="top"
 +
| ifservices_nodeid_idx
 
|  
 
|  
 +
| nodeid
 +
|- valign="top"
 +
| ifservices_nodeid_ipaddr_status
 
|  
 
|  
 +
| nodeid, ipaddr, status
 +
|- valign="top"
 +
| ifservices_nodeid_ipaddr_svc_unique
 
|  
 
|  
−
|-
+
| nodeid, ipaddr, serviceid
−
| ipinterfaceid
+
|- valign="top"
 +
| ifservices_nodeid_serviceid_idx
 
|  
 
|  
−
| not null
+
| nodeid, serviceid
 +
|- valign="top"
 +
| ifservices_nodeid_status
 
|  
 
|  
 +
| nodeid, status
 +
|- valign="top"
 +
| ifservices_serviceid_idx
 
|  
 
|  
 +
| serviceid
 +
|- valign="top"
 
| ifservicves_ipinterfaceid_idx
 
| ifservicves_ipinterfaceid_idx
 +
|
 +
| ipinterfaceid
 
|}
 
|}
  
−
 
+
=== 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 111: Line 143:
 
| '''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.service_(table)|public.service]]
 
| [[public.service_(table)|public.service]]
 
| serviceid
 
| serviceid
 
| serviceid
 
| serviceid
−
|-
+
|- valign="top"
 
| [[public.ipinterface_(table)|public.ipinterface]]
 
| [[public.ipinterface_(table)|public.ipinterface]]
 
| ipinterfaceid
 
| ipinterfaceid
Line 126: Line 158:
 
|}
 
|}
  
−
 
+
=== 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 132: Line 164:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[public.outages_(table)|public.outages]]
 
| [[public.outages_(table)|public.outages]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.outages_(table)|public.outages]]
 
| [[public.outages_(table)|public.outages]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.outages_(table)|public.outages]]
 
| [[public.outages_(table)|public.outages]]
 
| nodeid
 
| nodeid
 
| nodeid
 
| nodeid
−
|-
+
|- valign="top"
 
| [[public.outages_(table)|public.outages]]
 
| [[public.outages_(table)|public.outages]]
 
| id
 
| id
 
| ifserviceid
 
| ifserviceid
−
|-
+
|- valign="top"
 
| [[public.application_service_map_(table)|public.application_service_map]]
 
| [[public.application_service_map_(table)|public.application_service_map]]
 
| id
 
| id
 
| ifserviceid
 
| ifserviceid
−
|-
+
|- valign="top"
 
| [[public.location_specific_status_changes_(table)|public.location_specific_status_changes]]
 
| [[public.location_specific_status_changes_(table)|public.location_specific_status_changes]]
 
| id
 
| id
Line 159: Line 191:
 
|}
 
|}
  
−
 
+
=== 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"
 
| setipinterfacekeysoninserttrigger
 
| setipinterfacekeysoninserttrigger
−
| ROWBEFORE INSERT
+
| STATEMENT AFTER
 
| setipinterfacekeysoninsert
 
| setipinterfacekeysoninsert
−
|-
+
|- valign="top"
 
| setipinterfacekeysonupdatetrigger
 
| setipinterfacekeysonupdatetrigger
−
| ROWBEFORE UPDATE
+
| STATEMENT AFTER
 
| setipinterfacekeysonupdate
 
| setipinterfacekeysonupdate
 
|}
 
|}

Latest revision as of 10:25, 27 August 2011

wikibot[edit]

Table public.ifservices

Columns[edit]

Column Data Type Nullable Default Description
id integer not null
nodeid integer not null
ipaddr varchar(16) not null
ifindex integer null
serviceid integer not null
lastgood timestamp with time zone null
lastfail timestamp with time zone null
qualifier char(16) null
status char(1) null
source char(1) null
notify char(1) null
ipinterfaceid integer not null

Primary Key[edit]

Primary Key Columns
ifservices_pkey id

Indexes[edit]

Index Type Columns
ifservices_nodeid_idx nodeid
ifservices_nodeid_ipaddr_status nodeid, ipaddr, status
ifservices_nodeid_ipaddr_svc_unique nodeid, ipaddr, serviceid
ifservices_nodeid_serviceid_idx nodeid, serviceid
ifservices_nodeid_status nodeid, status
ifservices_serviceid_idx serviceid
ifservicves_ipinterfaceid_idx ipinterfaceid

Foreign Keys[edit]

Relation Column Referenced Column
public.node nodeid nodeid
public.service serviceid serviceid
public.ipinterface ipinterfaceid id

Detail Tables[edit]

Detail Table Column Referencing Column
public.outages nodeid nodeid
public.outages nodeid nodeid
public.outages nodeid nodeid
public.outages id ifserviceid
public.application_service_map id ifserviceid
public.location_specific_status_changes id ifserviceid

Triggers[edit]

Trigger Type Function
setipinterfacekeysoninserttrigger STATEMENT AFTER setipinterfacekeysoninsert
setipinterfacekeysonupdatetrigger STATEMENT AFTER setipinterfacekeysonupdate
Retrieved from "http://dbshelp.devio.at/index.php?title=Public.ifservices_(table)&oldid=3030"