From dbscript Online Help
wikibot
Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
id
|
|
not null
|
nextval('opennmsnxtid'::regclass)
|
ipinterface_pkey
|
|
nodeid
|
|
not null
|
|
|
ipinterface_nodeid_ipaddr_notzero_idxipinterface_nodeid_idxipinterface_nodeid_ipaddr_ismanaged_idx
|
ipaddr
|
|
not null
|
|
|
ipinterface_nodeid_ipaddr_notzero_idxipinterface_nodeid_ismanaged_idxipinterface_ipaddr_idxipinterface_ipaddr_ismanaged_idxipinterface_nodeid_ipaddr_ismanaged_idx
|
ifindex
|
|
null
|
|
|
|
iphostname
|
|
null
|
|
|
|
ismanaged
|
|
null
|
|
|
ipinterface_ipaddr_ismanaged_idxipinterface_nodeid_ipaddr_ismanaged_idx
|
ipstatus
|
|
null
|
|
|
|
iplastcapsdpoll
|
|
null
|
|
|
|
issnmpprimary
|
|
null
|
|
|
|
snmpinterfaceid
|
|
null
|
|
|
ipinterface_snmpinterfaceid_idx
|