Database Schema

 

The following are the database tables that are used in AdventNet SNMP API for the MIB loading.

Module Table contains the information about all the modules loaded in the database. For performance reasons, other tables are created for each MIB module. For example, for the MIB RFC1213-MIB, say MODULE1 is appended at the beginning of the table names, such as MODULE1MODULEIDTYTABLE, MODULE1TCTABLE, etc.

 

Module Table - Attributes

 

S. No

Field Name

Description

1

MODULENAME

The MIB module name.

2

RESOLVED

Indicates whether imports are successful. It takes the boolean value.

3

OTHERROOTNODES

Resolves the OIDs.

4

TABLENAME

The table name of each individual module.

 

Module Identity Table - Attributes

 

S. No

Field Name

Description

1

MODULENAME

The MIB Module Name.

2

MODITYNAME

Specifies information about the MIB MODULE.

3

LUPDATED

The Last Updated field - Specifies the date and time at which the module was created or last modified.

4

ORG

The Organization field - Gives information about the organization responsible for the module.

5

CONTINFO

The Contact Info field - Specifies the contact information of the person responsible for the module.

6

DESCR

The Description field - Explains the purpose of the module.

7

REVITEM

The Revision field - Specifies the revision timestamp in the UTC format.

8

OID

The Object Identifier

 

Textual Convention Table - Attributes

 

S. No

Field Name

Description

1

MODULETCNAME

The Module Textual Convention field - Specifies the name of the textual convention construct.

2

DISPHINT

The Display Hint field - Hints on how to display the value of the type or describe the sub-structuring of the value.

3

STAT

The Status field - Specifies the status of the definition.

4

DESCR

The Description field - Describes of the node or item being defined.

5

REF

The Reference field - Specifies the source of the definition.

6

TYPE

Syntax of the base data type.

 

Trap Table - Attributes

 

S. No

Field Name

Description

1

MODULETRAPNAME

The Module Trap Name field - Specifies the name of the TRAP-TYPE construct.

2

ENTERPRISES

The vendor identification for the network management subsystem that generated the trap.

3

VARIABLES

Specifies one or more scalar or columnar objects with values describing the event.

4

DESCR

The Description field - specifies information describing the status of the variables.

5

REF

The Reference field - Specifies the source of the definition.

6

TRAPTYPE

Gives the name of the trap.

 

Unit Table - Attributes

 

S. No

Field Name

Description

1

MODULENAME

The MIB Module Name

2

OID

The Object Identifier

3

UNITVAL

Specifies the value of the Units field of the node object.

 

Node Table - Attributes

 

S. No

Field Name

Description

1

OID

The Object Identifier

2

NODENAME

The name of the leaf node.

3

MACROTYPE

The name of the Macro type.

 

Object Type Table - Attributes

 

S. No

Field Name

Description

1

OID

The Object Identifier

2

SYNT

The Syntax field - Specifies the syntax of the data type. It should be one of the basic SNMP data types.

3

ACCSS

The Access field - Specifies the allowed access to the leaf object.

4

STAT

The Status field - Specifies the status of the definition.

5

DESCR

The Description field - Describes the node or item being defined.

6

REF

The Reference field - Specifies the source of the definition.

7

DEFVAL

The Default Value field - Specifies an acceptable value for a columnar object which may be used to create an instance of a row.

 

Dependency Table - Attributes

 

S. No

Field Name

Description

1

DEPENDANTMODULENAME

Name of the imported module name.

2

IMPORTEDNODES

Information on the imported objects.

 

Agent Capabilities and Module Compliance Table - Attributes

 

S. No

Field Name

Description

1

OID

The Object Identifier

2

PDTREL

The Product Release field - Describes the product release that includes the implemented capabilities.

3

STAT

The Status field - Specifies the status of the definition.

4

DESCR

The Description field - Describes the node or item being defined.

5

REF

The Reference field - Specifies the source of the definition.

6

ACMMCMNAME

Agent Capabilities Module and the Module Compliance Module Name.

 

Module Compliance Modules Table - Attributes

 

S. No

Field Name

Description

1

MCNAME

The Module Compliance Construct Name

2

MCMNAME

The Module Compliance Module sub-clause name

3

MANDATORYGP

The Mandatory Group field - Specifies a conditionally required object or notification group.

4

GRPOBJ

The Group Object

 

Agent Capabilities Module Table - Attributes

 

S. No

Field Name

Description

1

ACMNAME

The Agent Capabilities Module Name

2

SUPPORTS

Specifies the module identifier.

3

ACVINCLUDES

The AGENT CAPABILITIES VARIATION INCLUDES field - Specifies object and event groups that an agent implements.

4

ACVNAME

The Agent Capabilities Variation Name

 

Agent Capabilities Variation Table - Attributes

 

S. No

Field Name

Description

1

ACMNAME

The Agent Capabilities Module Name

2

ACVNAME

The Agent Capabilities Variation Name

3

SYNT

The SYNTAX field

4

WRITESYNT

The Write Syntax field

5

ACCSS

The Access field - Specifies the allowed access to the leaf object

6

CREAOBJ

The Creation-Requires field is used to document the objects that are required in a SET operation to create an instance of a row in a table.

7

DEFVALCREAOBJ

The DEFVAL clause is used to specify an acceptable value for a columnar object which may be used to create an instance of a row.

8

DESCR

The Description field - Describes the node or item being defined.

 

Sequence Table - Attributes

 

S. No

Field Name

Description

1

SEQID

The name of the table entry.

2

SEQVAL

The values in the Sequence construct.

 

Range List Table - Attributes

 

S. No

Field Name

Description

1

OID

The Object Identifier

2

RANGE

The range value for the specified node.

3

ENUM

The enumerated values for the specified node

 

Object Group, Notification Group, Notification Type Table - Attributes

 

S. No

Field Name

Description

1

OID

The Object Identifier

2

NAME

The name of this Object

3

STAT

The Status field - Specifies the status of the definition.

4

DESCR

The Description field - Describes the node or item being defined

5

REF

The Reference field - Specifies the source of the definition.

 



Copyright © 1996-2006, AdventNet Inc. All Rights Reserved.