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
PriorityyesnoyesshortINTEGER
LimitTimeyesnoyeslongBIGINT
DescriptionyesnoyesStringVARCHAR254
NameyesnoyesStringVARCHAR254
DeadlineTimeLimityesnoyeslongBIGINT
DeadlineExceptionNameyesnoyesStringVARCHAR100
DeadlineIsSynchronousyesnoyesbooleanBIT
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
ProcessPriorityyesnoyesshortINTEGER
ProcessLimitTimeyesnoyeslongBIGINT
ProcessDescriptionyesnoyesStringVARCHAR254
PackageIdyesnonoStringVARCHAR90
ActivityIdyesnonoStringVARCHAR100
ActivityNameyesnoyesStringVARCHAR254
ActivityPriorityyesnoyesshortINTEGER
ActivityLimitTimeyesnoyeslongBIGINT
ActivityDescriptionyesnoyesStringVARCHAR254
ActivityDefinitionIdyesnonoStringVARCHAR90
ActivityDefinitionNameyesnoyesStringVARCHAR90
ActivityDefinitionTypeyesnoyesintINTEGER
DeadlineTimeLimityesnoyeslongBIGINT
DeadlineExceptionNameyesnoyesStringVARCHAR100
DeadlineIsSynchronousyesnoyesbooleanBIT
CreatedTimeyesnonolongBIGINT
CreatedTimeTZOyesnoyeslongBIGINT
StartedTimeyesnoyeslongBIGINT
StartedTimeTZOyesnoyeslongBIGINT
SuspendedTimeyesnoyeslongBIGINT
SuspendedTimeTZOyesnoyeslongBIGINT
ResumedTimeyesnoyeslongBIGINT
ResumedTimeTZOyesnoyeslongBIGINT
AcceptedTimeyesnoyeslongBIGINT
AcceptedTimeTZOyesnoyeslongBIGINT
RejectedTimeyesnoyeslongBIGINT
RejectedTimeTZOyesnoyeslongBIGINT
ClosedTimeyesnoyeslongBIGINT
ClosedTimeTZOyesnoyeslongBIGINT
DeletionTimeyesnoyeslongBIGINT
DeletionTimeTZOyesnoyeslongBIGINT
CreatedByUsernameyesnoyesStringVARCHAR100
StartedByUsernameyesnoyesStringVARCHAR100
SuspendedByUsernameyesnoyesStringVARCHAR100
ResumedByUsernameyesnoyesStringVARCHAR100
AcceptedByUsernameyesnoyesStringVARCHAR100
RejectedByUsernameyesnoyesStringVARCHAR100
ClosedByUsernameyesnoyesStringVARCHAR100
DeletedByUsernameyesnoyesStringVARCHAR100
CurrentUsernameyesnoyesStringVARCHAR100
LastStateyesnoyesStringVARCHAR100
LastStateTimeyesnoyeslongBIGINT
LastStateTimeTZOyesnoyeslongBIGINT
LastRecordedTimeyesnoyeslongBIGINT
LastRecordedTimeTZOyesnoyeslongBIGINT
ActivityDurationyesnoyeslongBIGINT
IsDeletedyesnoyesbooleanBIT

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
PriorityyesnoyesshortINTEGER
LimitTimeyesnoyeslongBIGINT
DescriptionyesnoyesStringVARCHAR254
NameyesnoyesStringVARCHAR254
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
ProcessPriorityyesnoyesshortINTEGER
ProcessLimitTimeyesnoyeslongBIGINT
ProcessDescriptionyesnoyesStringVARCHAR254
PackageIdyesnonoStringVARCHAR90
PActivityIdyesnoyesStringVARCHAR100
PProcessIdyesnoyesStringVARCHAR100
PProcessNameyesnoyesStringVARCHAR254
PProcessFactoryNameyesnoyesStringVARCHAR200
PProcessFactoryVersionyesnoyesStringVARCHAR20
PActivityDefinitionIdyesnoyesStringVARCHAR90
PActivityDefinitionNameyesnoyesStringVARCHAR90
PProcessDefinitionIdyesnoyesStringVARCHAR90
PProcessDefinitionNameyesnoyesStringVARCHAR90
PPackageIdyesnoyesStringVARCHAR90
CreatedTimeyesnoyeslongBIGINT
CreatedTimeTZOyesnoyeslongBIGINT
StartedTimeyesnoyeslongBIGINT
StartedTimeTZOyesnoyeslongBIGINT
SuspendedTimeyesnoyeslongBIGINT
SuspendedTimeTZOyesnoyeslongBIGINT
ResumedTimeyesnoyeslongBIGINT
ResumedTimeTZOyesnoyeslongBIGINT
ClosedTimeyesnoyeslongBIGINT
ClosedTimeTZOyesnoyeslongBIGINT
DeletionTimeyesnoyeslongBIGINT
DeletionTimeTZOyesnoyeslongBIGINT
CreatedByUsernameyesnoyesStringVARCHAR100
StartedByUsernameyesnoyesStringVARCHAR100
SuspendedByUsernameyesnoyesStringVARCHAR100
ResumedByUsernameyesnoyesStringVARCHAR100
ClosedByUsernameyesnoyesStringVARCHAR100
DeletedByUsernameyesnoyesStringVARCHAR100
LastStateyesnoyesStringVARCHAR100
LastStateTimeyesnoyeslongBIGINT
LastStateTimeTZOyesnoyeslongBIGINT
LastRecordedTimeyesnoyeslongBIGINT
LastRecordedTimeTZOyesnoyeslongBIGINT
ProcessDurationyesnoyeslongBIGINT
IsDeletedyesnoyesbooleanBIT

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoProcessId