Appspy database schema

Table App

Contains the applications.

Table <b>App</b>
Field Type Description
App.appId long Primary key. The id of the application. Auto incremented value.
App.appCode String The code of the application.
App.appName String The name of the application.

Table AppUser

Contains the users of the applications.

Table <b>AppUser</b>
Field Type Description
AppUser.userId long Primary key. The id of the user. Auto incremented value.
AppUser.userName String The login of the user.

Table AppVersion

Contains the versions of the applications.

Table <b>AppVersion</b>
Field Type Description
AppVersion.versionId long Primary key. The id of the version. Auto incremented value.
AppVersion.versionName String The name of the version.
AppVersion.appId long Foreign key on App.appId.

Table ClientHost

Contains the client hosts.

Table <b>ClientHost</b>
Field Type Description
ClientHost.clientHostId long Primary key. The id of the client host. Auto incremented value.
ClientHost.clientHostIP String The IP Address of the client host.

Table DelayType

Contains the types of timer delay.

Table <b>DelayType</b>
Field Type Description
DelayType.delayTypeId long Primary key. The id of the delay type. Auto incremented value.
DelayType.delayTypeCode String The code of the delay type.
DelayType.delayTypeValue int The corresponding integer value.

Table Env

Contains the environments.

Table <b>Env</b>
Field Type Description
Env.envId long Primary key. The id of the environment. Auto incremented value.
Env.envCode String The code of the environment.
Env.envName String The name of the environment.
Env.orgId long Foreign key on Org.orgId.

Table EnvHostAssoc

Contains the associations between the environments and the hosts.

Table <b>EnvHostAssoc</b>
Field Type Description
EnvHostAssoc.envId long Foreign key on Env.envId.
EnvHostAssoc.hostId long Foreign key on Host.hostId.

Table Feature

Contains the features of the applications (URL, methods of classes, etc.).

Table <b>Feature</b>
Field Type Description
Feature.featureId long Primary key. The id of the feature. Auto incremented value.
Feature.featureName String The name of the feature.
Feature.appId long Foreign key on App.appId.

Table Hit

Contains commons informations for every hit on the application. One row per hit.

Table <b>Hit</b>
Field Type Description
Hit.hitId long Primary key. The id of the hit. Auto incremented value.
Hit.parentHitId long Foreign key on Hit.hitId.
Hit.blockingCount long Number of times the thread was blocked. According to : http://java.sun.com/j2se/1.5.0/docs/api/java/lang/management/ThreadInfo.html#getBlockedCount()
Hit.blockingDelay long Elapsed time during the thread was blocked (ms). According to : http://java.sun.com/j2se/1.5.0/docs/api/java/lang/management/ThreadInfo.html#getBlockedTime()
Hit.cpuTime long Thread CPU time (in ns). According to : http://java.sun.com/j2se/1.5.0/docs/api/java/lang/management/ThreadMXBean.html#getCurrentThreadCpuTime()
Hit.cpuUserTime long Thread CPU user time (in ns). According to : http://java.sun.com/j2se/1.5.0/docs/api/java/lang/management/ThreadMXBean.html#getCurrentThreadUserTime()
Hit.hitDelay long Elapsed time (in ms).
Hit.hitDate timestamp Date/Time of the data collection.
Hit.waitCount long Number of times the thread has been waiting. According to : http://java.sun.com/j2se/1.5.0/docs/api/java/lang/management/ThreadInfo.html#getWaitedCount()
Hit.waitDelay long Elapsed time during the thread was waiting (ms). According to : http://java.sun.com/j2se/1.5.0/docs/api/java/lang/management/ThreadInfo.html#getWaitedTime()
Hit.clientHostId long Foreign key on ClientHost.clientHostId.
Hit.delayType long Foreign key on DelayType.delayTypeId.
Hit.featureId long Foreign key on Feature.featureId.
Hit.hostId long Foreign key on Host.hostId.
Hit.hitResult long Foreign key on HitResult.hitResultId.
Hit.userId long Foreign key on AppUser.userId.
Hit.versionId long Foreign key on AppVersion.versionId.

Table HitResult

Contains the hit result (Success, Error).

Table <b>HitResult</b>
Field Type Description
HitResult.hitResultId long Primary key. The id of the hit result. Auto incremented value.
HitResult.hitResultCode String The code of the feature (Success, Error).
HitResult.hitResultValue int The corresponding integer value.

Table HitURL

Contains commons informations for every hit on the URL of the web application. One row per hit.

Table <b>HitURL</b>
Field Type Description
HitURL.hitId long Foreign key on Hit.hitId.
HitURL.inputHeaderSize long The size of the request headers.
HitURL.inputStreamSize long The size of the input stream that was read by the servlet.
HitURL.isNewSession boolean True if this session has just been created by this request.
HitURL.method String The HTTP method requested (GET, POST, ...).
HitURL.outputHeaderSize long The size of the response headers.
HitURL.outputStreamSize long The size of the stream send in the response.
HitURL.queryStringSize int The size of the query string.
HitURL.responseCode int The HTTP response code (200, 404, ...).
HitURL.sessionId long Foreign key on Session.sessionId.

Table Host

Contains the hosts.

Table <b>Host</b>
Field Type Description
Host.hostId long Primary key. The id of the host. Auto incremented value.
Host.hostName String The name of the host.
Host.hostAlias String The alias of the host.

Table Method

Contains the methods of classes.

Table <b>Method</b>
Field Type Description
Method.featureId long Foreign key on Feature.featureId.
Method.className String The name of the class.
Method.methodName String The name of the method.

Table Org

Contains the organizations.

Table <b>Org</b>
Field Type Description
Org.orgId long Primary key. The id of the organization. Auto incremented value.
Org.orgCode String The code of the organization.
Org.orgName String The name of the organization.

Table Session

Contains the sessions on the applications.

Table <b>Session</b>
Field Type Description
Session.sessionId long Primary key. The id of the session. Auto incremented value.
Session.sessionCode String The code of the session.
Session.clientHostId long Foreign key on ClientHost.clientHostId.
Session.envId long Foreign key on Env.envId.
Session.userId long Foreign key on AppUser.userId.
Session.versionId long Foreign key on AppVersion.versionId.

Table URL

Contains the URLs on the applications.

Table <b>URL</b>
Field Type Description
URL.featureId long Foreign key on Feature.featureId.
URL.webappId long Foreign key on Webapp.webappId.

Table URLParam

(Bad name for this table, should have been called FeatureParam) Contains the names of the parameters passed to the features.

Table <b>URLParam</b>
Field Type Description
URLParam.urlParamId long Primary key. The id of the parameter. Auto incremented value.
URLParam.urlParamName String The name of the parameter.

Table URLParVal

(Bad name for this table, should have been called FeatureParVal) Contains the values of the parameters passed to the features.

Table <b>URLParVal</b>
Field Type Description
URLParVal.urlParamValueId long Primary key. The id of the parameter value. Auto incremented value.
URLParVal.urlParamId long Foreign key on URLParam.urlParamId.
URLParVal.hitId long Foreign key on Hit.hitId.
URLParVal.urlParamValue String The value of the parameter.

Table Webapp

Contains the web applications.

Table <b>Webapp</b>
Field Type Description
Webapp.webappId long Primary key. The id of the parameter web application. Auto incremented value.
Webapp.appId long Foreign key on App.appId.
Webapp.webappName String The context path of the web application.