From dbscript Online Help
wikibot
Table
|
public.snmpinterface
|
Columns
Column
|
Data Type
|
Nullable
|
Default
|
Description
|
id
|
integer
|
not null
|
nextval('opennmsnxtid'::regclass)
|
|
nodeid
|
integer
|
not null
|
|
|
ipaddr
|
varchar(16)
|
not null
|
|
|
snmpipadentnetmask
|
varchar(16)
|
null
|
|
|
snmpphysaddr
|
char(12)
|
null
|
|
|
snmpifindex
|
integer
|
not null
|
|
|
snmpifdescr
|
varchar(256)
|
null
|
|
|
snmpiftype
|
integer
|
null
|
|
|
snmpifname
|
varchar(96)
|
null
|
|
|
snmpifspeed
|
bigint
|
null
|
|
|
snmpifadminstatus
|
integer
|
null
|
|
|
snmpifoperstatus
|
integer
|
null
|
|
|
snmpifalias
|
varchar(256)
|
null
|
|
|
Primary Key
Primary Key
|
Columns
|
snmpinterface_pkey
|
id
|
Indexes
Index
|
Type
|
Columns
|
snmpinterface_nodeid_ifindex_unique_idx
|
Unique
|
nodeid, snmpifindex
|
snmpinterface_ipaddr_idx
|
|
ipaddr
|
snmpinterface_nodeid_idx
|
|
nodeid
|
Foreign Keys
Relation
|
Column
|
Referenced Column
|
public.node
|
nodeid
|
nodeid
|
Detail Tables
Dependencies