public ifservices (table)

wikibot

Tablepublic.ifservices

Columns

ColumnData TypeNullableDefaultDescription
idintegernot null  
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_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

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

TriggerTypeFunction
setipinterfacekeysoninserttriggerSTATEMENT AFTERsetipinterfacekeysoninsert
setipinterfacekeysonupdatetriggerSTATEMENT AFTERsetipinterfacekeysonupdate