From dbscript Online Help
wikibot
Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
id
|
|
not null
|
nextval('opennmsnxtid'::regclass)
|
ifservices_pkey
|
|
nodeid
|
|
not null
|
|
|
ifservices_nodeid_ipaddr_svc_uniqueifservices_nodeid_ipaddr_statusifservices_nodeid_statusifservices_nodeid_idxifservices_nodeid_serviceid_idx
|
ipaddr
|
|
not null
|
|
|
ifservices_nodeid_ipaddr_svc_uniqueifservices_nodeid_ipaddr_status
|
ifindex
|
|
null
|
|
|
|
serviceid
|
|
not null
|
|
|
ifservices_nodeid_ipaddr_svc_uniqueifservices_serviceid_idxifservices_nodeid_serviceid_idx
|
lastgood
|
|
null
|
|
|
|
lastfail
|
|
null
|
|
|
|
qualifier
|
|
null
|
|
|
|
status
|
|
null
|
|
|
ifservices_nodeid_ipaddr_statusifservices_nodeid_status
|
source
|
|
null
|
|
|
|
notify
|
|
null
|
|
|
|
ipinterfaceid
|
|
not null
|
|
|
ifservicves_ipinterfaceid_idx
|
Triggers
|
Type
|
Function
|
setipinterfacekeysoninserttrigger
|
ROWBEFORE INSERT
|
setipinterfacekeysoninsert
|
setipinterfacekeysonupdatetrigger
|
ROWBEFORE UPDATE
|
setipinterfacekeysonupdate
|