Public.snmpinterface (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table public.snmpinterface

Columns[edit]

Column Data Type Nullable Default Description
id integer not null
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[edit]

Primary Key Columns
snmpinterface_pkey id

Indexes[edit]

Index Type Columns
snmpinterface_ipaddr_idx ipaddr
snmpinterface_nodeid_idx nodeid
snmpinterface_nodeid_ifindex_unique_idx nodeid, snmpifindex

Foreign Keys[edit]

Relation Column Referenced Column
public.node nodeid nodeid

Detail Tables[edit]

Detail Table Column Referencing Column
public.ipinterface id snmpinterfaceid