Database

Diagram

elmah_database_schema.png

Installation

For now there is only a .bak file which you can restore. I'll try to upload the sql script files a.s.a.p.

Tables

Agent

  • Id: a unique identifier for the agent.
  • Name: the name of the agent.
  • Description: the description of the agent.
  • CreatedOn: the date the agent was created on.
  • LastHeartbeat: the date of the last received heartbeat.
  • IsActive: indicates whether the agent is active or not.

ELMAH_Error

  • ErrorId: a unique identifier for the error
  • ApplicationName: the application name that generated the exception
  • HostName: the name of the host that exception was generated on
  • ExceptionType: the type of the exception
  • Source: the source of the exception
  • ErrorMessage: the error message of the exception
  • UserName: the username of the user for whom the exception occurred (if authenticated)
  • StatusCode: the status code of the exception
  • HappeningTime: the date and time the exception occurred
  • SequencialId: a sequencial id
  • AllXml: the all the exceptions data that is normally displayed on the red/yellow Error page
  • ErrorLevel: the error level of the exception (this is generated by the Intelligent error filter)
  • ErrorType: the type of the exception (this is generated by the Intelligent error filter)
  • AppliedRules: the rules that are apply (this is generated by the Intelligent error filter)

ErrorFilterRule

  • Id: a unique identifier of the error filter rule
  • Name: the name of the error filter rule
  • Description: the description of the error filter rule
  • Level: the level of the exception should be placed at if the rule is applicable
  • Type: the type the exception should be set at if the rule is applicable

ErrorFilterRuleXPathMap

  • ErrorFilterRuleId: a foreign key on the ErrorFilterRule table
  • XPathId: a foreign key on the XPath table
This is a link table that normalizes the database (no many-to-many relations).

XPath


Last edited Nov 3, 2009 at 4:42 PM by wdeconinck, version 3

Comments

kiquenet Nov 6, 2013 at 10:57 AM 
Where is SQL file for script?