Navigation:  The Database >

The Administration Database

Previous page Next page
  rev. 19/10/2010        

The administration database (<%ADMINDB%>) database contains information that is global to all ManagingEnergy databases installed on the current server. There are several tables in the database and they are listed here with a brief description of their purpose.

 

Table Name

Description

tblAdmin_Log

This table is used to collect information about errors that occured in the application or when certain events happen in the application.

tblAdmin_SecurityTags

This table is not used anymore and is only present to serve legacy application versions (UMAS)

tblAdmin_Users

This table is the complete list of MEC application users.  It contains information about the type of user they are and the database the user is allowed to access.

tblAdmin_UserLog

This table stores information about how long a user has been logged on of either the application or webReports.

tblMECDatabaseListings

This table contains a listing of MEC database names and a user friendly name for them.  This friendly name is used by webReports to auithenticate users against a database.

tblSupportCaseEvents

Used as the reply forum for support cases.

tblSupportCases

User support calls are detailed and listed in this table.

tblSupport_Companies

Contains information about client companies.

tblSupport_HoursBilled

Lists the number of hours billed to each client.

tblSupport_Products

Listing of all the products we provide support for.

tblSupport_Purchases

This table contains records of how many support hour purchases a client has made.

tblWeb_ReportTags

This table lists all the reports available to clients and some additional information about where the reports appear in the webReports system.

 

There are also many stored procedures that allow you to select, insert, update and delete data from these tables.



BOSS_Admin         ©2011 Managing Energy Inc.