Data model-Documentation

Database: Standard

Package

Class

GenSecure

GenInsecure

MassDeletes

MassUpdates

DirtyDOs

org
org. enhydra
org. enhydra. shark
org. enhydra. shark. eventaudit
org. enhydra. shark. eventaudit. data
ActivityHistoryDetails
false
true
false
false
Compatible
ActivityHistoryInfo
false
true
false
false
Compatible
ProcessHistoryDetails
false
true
false
false
Compatible
ProcessHistoryInfo
false
true
false
false
Compatible

Package:

org

Package:

org. enhydra

Package:

org. enhydra. shark

Package:

org. enhydra. shark. eventaudit

Package:

org. enhydra. shark. eventaudit. data

Classes:


ActivityHistoryDetails
ActivityHistoryInfo
ProcessHistoryDetails
ProcessHistoryInfo
Class:
ActivityHistoryDetails
id: org.enhydra.shark.eventaudit.data.ActivityHistoryDetails
Table Name: SHKActivityHistoryDetails
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible
Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
ActivityIdyesnonoStringVARCHAR100
ActivityHistoryInfoyesyesnoActivityHistoryInfoDODECIMAL 19,0 ActivityHistoryInfoSHKActivityHistoryInfo
TheTypeyesnonoshortINTEGER
RecordedTimeyesnonolongBIGINT
RecordedTimeTZOyesnonolongBIGINT
TheUsernameyesnonoStringVARCHAR100
ReassignFromyesnoyesStringVARCHAR100
ReassignToyesnoyesStringVARCHAR100
VariableDefinitionIdyesnoyesStringVARCHAR100
VariableTypenonoyesshortINTEGER
VariableValuenonoyesbyte[]LONGVARBINARY
VariableValueXMLnonoyesNodeLONGVARCHAR
VariableValueVCHARnonoyesStringVARCHAR4000
VariableValueDBLnonoyesdoubleDOUBLE
VariableValueLONGnonoyeslongBIGINT
VariableValueDATEnonoyesTimestampTIMESTAMP
VariableValueBOOLnonoyesbooleanBIT
OrdNoyesnonointINTEGER
CNTnononoBigDecimalDECIMAL19,0

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoCNT
I2nonoActivityId


Class:
ActivityHistoryInfo
id: org.enhydra.shark.eventaudit.data.ActivityHistoryInfo
Table Name: SHKActivityHistoryInfo
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible

Relations
ClassTable NameAttribute
org. enhydra. shark. eventaudit. data. ActivityHistoryDetailsSHKActivityHistoryDetailsActivityHistoryInfo

Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
ProcessIdyesnonoStringVARCHAR100
ProcessNameyesnoyesStringVARCHAR254
ProcessFactoryNameyesnonoStringVARCHAR200
ProcessFactoryVersionyesnonoStringVARCHAR20
ProcessDefinitionIdyesnonoStringVARCHAR90
ProcessDefinitionNameyesnoyesStringVARCHAR90
PackageIdyesnonoStringVARCHAR90
ActivityIdyesnonoStringVARCHAR100
ActivityNameyesnoyesStringVARCHAR254
ActivityDefinitionIdyesnonoStringVARCHAR90
ActivityDefinitionNameyesnoyesStringVARCHAR90
ActivityDefinitionTypeyesnoyesintINTEGER
CreatedTimeyesnonolongBIGINT
CreatedTimeTZOyesnoyeslongBIGINT
StartedTimeyesnoyeslongBIGINT
StartedTimeTZOyesnoyeslongBIGINT
SuspendedTimeyesnoyeslongBIGINT
SuspendedTimeTZOyesnoyeslongBIGINT
ResumedTimeyesnoyeslongBIGINT
ResumedTimeTZOyesnoyeslongBIGINT
AcceptedTimeyesnoyeslongBIGINT
AcceptedTimeTZOyesnoyeslongBIGINT
RejectedTimeyesnoyeslongBIGINT
RejectedTimeTZOyesnoyeslongBIGINT
ClosedTimeyesnoyeslongBIGINT
ClosedTimeTZOyesnoyeslongBIGINT
CreatedByUsernameyesnoyesStringVARCHAR100
StartedByUsernameyesnoyesStringVARCHAR100
SuspendedByUsernameyesnoyesStringVARCHAR100
ResumedByUsernameyesnoyesStringVARCHAR100
AcceptedByUsernameyesnoyesStringVARCHAR100
RejectedByUsernameyesnoyesStringVARCHAR100
ClosedByUsernameyesnoyesStringVARCHAR100
CurrentUsernameyesnoyesStringVARCHAR100
LastStateyesnoyesStringVARCHAR100
LastStateTimeyesnoyeslongBIGINT
LastStateTimeTZOyesnoyeslongBIGINT
ActivityDurationyesnoyeslongBIGINT

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoActivityId
I2nonoProcessId


Class:
ProcessHistoryDetails
id: org.enhydra.shark.eventaudit.data.ProcessHistoryDetails
Table Name: SHKProcessHistoryDetails
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible
Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
ProcessIdyesnonoStringVARCHAR100
ProcessHistoryInfoyesyesnoProcessHistoryInfoDODECIMAL 19,0 ProcessHistoryInfoSHKProcessHistoryInfo
TheTypeyesnonoshortINTEGER
RecordedTimeyesnonolongBIGINT
RecordedTimeTZOyesnonolongBIGINT
TheUsernameyesnonoStringVARCHAR100
VariableDefinitionIdyesnoyesStringVARCHAR100
VariableTypenonoyesshortINTEGER
VariableValuenonoyesbyte[]LONGVARBINARY
VariableValueXMLnonoyesNodeLONGVARCHAR
VariableValueVCHARnonoyesStringVARCHAR4000
VariableValueDBLnonoyesdoubleDOUBLE
VariableValueLONGnonoyeslongBIGINT
VariableValueDATEnonoyesTimestampTIMESTAMP
VariableValueBOOLnonoyesbooleanBIT
OrdNoyesnonointINTEGER
CNTnononoBigDecimalDECIMAL19,0

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoCNT
I2nonoProcessId


Class:
ProcessHistoryInfo
id: org.enhydra.shark.eventaudit.data.ProcessHistoryInfo
Table Name: SHKProcessHistoryInfo
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible

Relations
ClassTable NameAttribute
org. enhydra. shark. eventaudit. data. ProcessHistoryDetailsSHKProcessHistoryDetailsProcessHistoryInfo

Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
ProcessIdyesnonoStringVARCHAR100
ProcessNameyesnoyesStringVARCHAR254
ProcessFactoryNameyesnonoStringVARCHAR200
ProcessFactoryVersionyesnonoStringVARCHAR20
ProcessDefinitionIdyesnonoStringVARCHAR90
ProcessDefinitionNameyesnoyesStringVARCHAR90
PackageIdyesnonoStringVARCHAR90
PActivityIdyesnoyesStringVARCHAR100
PProcessIdyesnoyesStringVARCHAR100
PProcessNameyesnoyesStringVARCHAR254
PProcessFactoryNameyesnoyesStringVARCHAR200
PProcessFactoryVersionyesnoyesStringVARCHAR20
PActivityDefinitionIdyesnoyesStringVARCHAR90
PActivityDefinitionNameyesnoyesStringVARCHAR90
PProcessDefinitionIdyesnoyesStringVARCHAR90
PProcessDefinitionNameyesnoyesStringVARCHAR90
PPackageIdyesnoyesStringVARCHAR90
CreatedTimeyesnoyeslongBIGINT
CreatedTimeTZOyesnoyeslongBIGINT
StartedTimeyesnoyeslongBIGINT
StartedTimeTZOyesnoyeslongBIGINT
SuspendedTimeyesnoyeslongBIGINT
SuspendedTimeTZOyesnoyeslongBIGINT
ResumedTimeyesnoyeslongBIGINT
ResumedTimeTZOyesnoyeslongBIGINT
ClosedTimeyesnoyeslongBIGINT
ClosedTimeTZOyesnoyeslongBIGINT
CreatedByUsernameyesnoyesStringVARCHAR100
StartedByUsernameyesnoyesStringVARCHAR100
SuspendedByUsernameyesnoyesStringVARCHAR100
ResumedByUsernameyesnoyesStringVARCHAR100
ClosedByUsernameyesnoyesStringVARCHAR100
LastStateyesnoyesStringVARCHAR100
LastStateTimeyesnoyeslongBIGINT
LastStateTimeTZOyesnoyeslongBIGINT
ProcessDurationyesnoyeslongBIGINT

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoProcessId