Difference between revisions of "Public.snmpinterface (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.snmpinterface |- |} {| border="1" cellpadding="5" cellspacing="0" sty...)
 
Line 20: Line 20:
 
|-
 
|-
 
| id
 
| id
|  
+
| integer
 
| not null
 
| not null
 
| nextval('opennmsnxtid'::regclass)
 
| nextval('opennmsnxtid'::regclass)
Line 27: Line 27:
 
|-
 
|-
 
| nodeid
 
| nodeid
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
Line 34: Line 34:
 
|-
 
|-
 
| ipaddr
 
| ipaddr
|  
+
| varchar(16)
 
| not null
 
| not null
 
|  
 
|  
Line 41: Line 41:
 
|-
 
|-
 
| snmpipadentnetmask
 
| snmpipadentnetmask
|  
+
| varchar(16)
 
| null
 
| null
 
|  
 
|  
Line 48: Line 48:
 
|-
 
|-
 
| snmpphysaddr
 
| snmpphysaddr
|  
+
| char(12)
 
| null
 
| null
 
|  
 
|  
Line 55: Line 55:
 
|-
 
|-
 
| snmpifindex
 
| snmpifindex
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
Line 62: Line 62:
 
|-
 
|-
 
| snmpifdescr
 
| snmpifdescr
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  
Line 69: Line 69:
 
|-
 
|-
 
| snmpiftype
 
| snmpiftype
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
Line 76: Line 76:
 
|-
 
|-
 
| snmpifname
 
| snmpifname
|  
+
| varchar(96)
 
| null
 
| null
 
|  
 
|  
Line 83: Line 83:
 
|-
 
|-
 
| snmpifspeed
 
| snmpifspeed
|  
+
| bigint
 
| null
 
| null
 
|  
 
|  
Line 90: Line 90:
 
|-
 
|-
 
| snmpifadminstatus
 
| snmpifadminstatus
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
Line 97: Line 97:
 
|-
 
|-
 
| snmpifoperstatus
 
| snmpifoperstatus
|  
+
| integer
 
| null
 
| null
 
|  
 
|  
Line 104: Line 104:
 
|-
 
|-
 
| snmpifalias
 
| snmpifalias
|  
+
| varchar(256)
 
| null
 
| null
 
|  
 
|  

Revision as of 15:44, 7 August 2009

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


Detail Table Column Referencing Column
public.ipinterface id snmpinterfaceid