Welcome Guest, you are in: <root> • Login

Page History: public snmpinterface (table)

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: 2010/06/25 22:48

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 ¶

Detail Table	Column	Referencing Column
public.ipinterface	id	snmpinterfaceid

Dependencies ¶

Reference Type	Object Type	Referencing Object
Select	Trigger Function	public.setsnmpinterfacekeysoninsert
Select	Trigger Function	public.setsnmpinterfacekeysonupdate