Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: public ifservices (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/02/11 09:23


wikibot

Tablepublic.ifservices

Columns

ColumnData TypeNullableDefaultDescription
idintegernot nullnextval('opennmsnxtid'::regclass) 
nodeidintegernot null  
ipaddrvarchar(16)not null  
ifindexintegernull  
serviceidintegernot null  
lastgoodtimestamp with time zonenull  
lastfailtimestamp with time zonenull  
qualifierchar(16)null  
statuschar(1)null  
sourcechar(1)null  
notifychar(1)null  
ipinterfaceidintegernot null  

Primary Key

Primary KeyColumns
ifservices_pkeyid

Indexes

IndexTypeColumns
ifservices_nodeid_ipaddr_svc_uniqueUniquenodeid, ipaddr, serviceid
ifservices_serviceid_idx serviceid
ifservices_nodeid_ipaddr_status nodeid, ipaddr, status
ifservices_nodeid_status nodeid, status
ifservicves_ipinterfaceid_idx ipinterfaceid
ifservices_nodeid_idx nodeid
ifservices_nodeid_serviceid_idx nodeid, serviceid

Foreign Keys

RelationColumnReferenced Column
public.nodenodeidnodeid
public.serviceserviceidserviceid
public.ipinterfaceipinterfaceidid

Detail Tables

Detail TableColumnReferencing Column
public.outagesnodeidnodeid
public.outagesnodeidnodeid
public.outagesnodeidnodeid
public.outagesidifserviceid
public.application_service_mapidifserviceid
public.location_specific_status_changesidifserviceid

Triggers

TriggersTypeFunction
setipinterfacekeysoninserttriggerROW BEFORE INSERTsetipinterfacekeysoninsert
setipinterfacekeysonupdatetriggerROW BEFORE UPDATEsetipinterfacekeysonupdate

Dependencies

Reference TypeObject TypeReferencing Object
SelectFunctionpublic.getmanagedoutageforintfinwindow
SelectFunctionpublic.getmanagedoutagefornodeinwindow
SelectFunctionpublic.getmanagedservicecountforintf
SelectFunctionpublic.getmanagedservicecountfornode
SelectTrigger Functionpublic.setifservicekeysoninsert
SelectTrigger Functionpublic.setifservicekeysonupdate

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.