From dbscript Online Help
wikibot
| Table
|
public.snmpinterface
|
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| id
|
integer
|
not null
|
nextval('opennmsnxtid'::regclass)
|
snmpinterface_pkey
|
|
| nodeid
|
integer
|
not null
|
|
|
snmpinterface_nodeid_ifindex_unique_idxsnmpinterface_nodeid_idx
|
| ipaddr
|
varchar(16)
|
not null
|
|
|
snmpinterface_ipaddr_idx
|
| snmpipadentnetmask
|
varchar(16)
|
null
|
|
|
|
| snmpphysaddr
|
char(12)
|
null
|
|
|
|
| snmpifindex
|
integer
|
not null
|
|
|
snmpinterface_nodeid_ifindex_unique_idx
|
| snmpifdescr
|
varchar(256)
|
null
|
|
|
|
| snmpiftype
|
integer
|
null
|
|
|
|
| snmpifname
|
varchar(96)
|
null
|
|
|
|
| snmpifspeed
|
bigint
|
null
|
|
|
|
| snmpifadminstatus
|
integer
|
null
|
|
|
|
| snmpifoperstatus
|
integer
|
null
|
|
|
|
| snmpifalias
|
varchar(256)
|
null
|
|
|
|
| Relation
|
Column
|
Referenced Column
|
| public.node
|
nodeid
|
nodeid
|
