Data model-Documentation

Database: Standard

JavaName

Class

GenSecure

GenInsecure

MassDeletes

MassUpdates

org.enhydra.shark.eventaudit.data.ActivityHistoryDetailsActivityHistoryDetails
false
true
false
false
org.enhydra.shark.eventaudit.data.ActivityHistoryInfoActivityHistoryInfo
false
true
false
false
org.enhydra.shark.eventaudit.data.ProcessHistoryDetailsProcessHistoryDetails
false
true
false
false
org.enhydra.shark.eventaudit.data.ProcessHistoryInfoProcessHistoryInfo
false
true
false
false

Class:
ActivityHistoryDetails
id: ActivityHistoryDetails
Table Name: SHKActivityHistoryDetails
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
OId . . no java.math.BigDecimal DECIMAL 19,0 . .
Version..nointINTEGER4,0..
ActivityIdyesnonoStringVARCHAR100 . .
ActivityHistoryInfonoyesnoActivityHistoryInfoDO DECIMAL 19,0 ActivityHistoryInfoSHKActivityHistoryInfo
TheTypeyesnonointINTEGER12,0 . .
RecordedTimeyesnonolongBIGINT20,0 . .
RecordedTimeTZOyesnonolongBIGINT20,0 . .
TheUsernameyesnonoStringVARCHAR100 . .
ReassignFromyesnoyesStringVARCHAR100 . .
ReassignToyesnoyesStringVARCHAR100 . .
PriorityyesnoyesintINTEGER12,0 . .
LimitTimeyesnoyeslongBIGINT20,0 . .
DescriptionyesnoyesStringVARCHAR254 . .
NameyesnoyesStringVARCHAR254 . .
DeadlineTimeLimityesnoyeslongBIGINT20,0 . .
DeadlineExceptionNameyesnoyesStringVARCHAR100 . .
DeadlineIsSynchronousyesnoyesbooleanBIT3,0 . .
VariableDefinitionIdyesnoyesStringVARCHAR100 . .
VariableTypenonoyesintINTEGER12,0 . .
VariableValuenonoyesbyte[]LONGVARBINARY . . .
VariableValueXMLnonoyesorg.w3c.dom.NodeLONGVARCHAR . . .
VariableValueVCHARnonoyesStringVARCHAR4000 . .
VariableValueDBLnonoyesdoubleDOUBLE16,16 . .
VariableValueLONGnonoyeslongBIGINT20,0 . .
VariableValueDATEnonoyesTimestampTIMESTAMP . . .
VariableValueBOOLnonoyesbooleanBIT3,0 . .
OrdNoyesnonointINTEGER12,0 . .
CNTnononojava.math.BigDecimalDECIMAL19,0 . .

Indexes
index
indexColumn
iduniqueclusteredidincluded
ActivityHistoryDetails-I1yesnoCNT
ActivityHistoryDetails-I2nonoActivityId


Class:
ActivityHistoryInfo
id: ActivityHistoryInfo
Table Name: SHKActivityHistoryInfo
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false

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

Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
OId . . no java.math.BigDecimal DECIMAL 19,0 . .
Version..nointINTEGER4,0..
ProcessIdyesnonoStringVARCHAR100 . .
ProcessNameyesnoyesStringVARCHAR254 . .
ProcessFactoryNameyesnonoStringVARCHAR200 . .
ProcessFactoryVersionyesnonoStringVARCHAR20 . .
ProcessDefinitionIdyesnonoStringVARCHAR90 . .
ProcessDefinitionNameyesnoyesStringVARCHAR90 . .
ProcessPriorityyesnoyesintINTEGER12,0 . .
ProcessLimitTimeyesnoyeslongBIGINT20,0 . .
ProcessDescriptionyesnoyesStringVARCHAR254 . .
PackageIdyesnonoStringVARCHAR90 . .
ActivityIdyesnonoStringVARCHAR100 . .
ActivityNameyesnoyesStringVARCHAR254 . .
ActivityPriorityyesnoyesintINTEGER12,0 . .
ActivityLimitTimeyesnoyeslongBIGINT20,0 . .
ActivityDescriptionyesnoyesStringVARCHAR254 . .
ActivityDefinitionIdyesnonoStringVARCHAR90 . .
ActivityDefinitionNameyesnoyesStringVARCHAR90 . .
ActivityDefinitionTypeyesnoyesintINTEGER12,0 . .
DeadlineTimeLimityesnoyeslongBIGINT20,0 . .
DeadlineExceptionNameyesnoyesStringVARCHAR100 . .
DeadlineIsSynchronousyesnoyesbooleanBIT3,0 . .
CreatedTimeyesnonolongBIGINT20,0 . .
CreatedTimeTZOyesnoyeslongBIGINT20,0 . .
StartedTimeyesnoyeslongBIGINT20,0 . .
StartedTimeTZOyesnoyeslongBIGINT20,0 . .
SuspendedTimeyesnoyeslongBIGINT20,0 . .
SuspendedTimeTZOyesnoyeslongBIGINT20,0 . .
ResumedTimeyesnoyeslongBIGINT20,0 . .
ResumedTimeTZOyesnoyeslongBIGINT20,0 . .
AcceptedTimeyesnoyeslongBIGINT20,0 . .
AcceptedTimeTZOyesnoyeslongBIGINT20,0 . .
RejectedTimeyesnoyeslongBIGINT20,0 . .
RejectedTimeTZOyesnoyeslongBIGINT20,0 . .
ClosedTimeyesnoyeslongBIGINT20,0 . .
ClosedTimeTZOyesnoyeslongBIGINT20,0 . .
DeletionTimeyesnoyeslongBIGINT20,0 . .
DeletionTimeTZOyesnoyeslongBIGINT20,0 . .
CreatedByUsernameyesnoyesStringVARCHAR100 . .
StartedByUsernameyesnoyesStringVARCHAR100 . .
SuspendedByUsernameyesnoyesStringVARCHAR100 . .
ResumedByUsernameyesnoyesStringVARCHAR100 . .
AcceptedByUsernameyesnoyesStringVARCHAR100 . .
RejectedByUsernameyesnoyesStringVARCHAR100 . .
ClosedByUsernameyesnoyesStringVARCHAR100 . .
DeletedByUsernameyesnoyesStringVARCHAR100 . .
CurrentUsernameyesnoyesStringVARCHAR100 . .
LastStateyesnoyesStringVARCHAR100 . .
LastStateTimeyesnoyeslongBIGINT20,0 . .
LastStateTimeTZOyesnoyeslongBIGINT20,0 . .
LastRecordedTimeyesnoyeslongBIGINT20,0 . .
LastRecordedTimeTZOyesnoyeslongBIGINT20,0 . .
ActivityDurationyesnoyeslongBIGINT20,0 . .
IsDeletedyesnoyesbooleanBIT3,0 . .

Indexes
index
indexColumn
iduniqueclusteredidincluded
ActivityHistoryInfo-I1yesnoActivityId
ActivityHistoryInfo-I2nonoProcessId


Class:
ProcessHistoryDetails
id: ProcessHistoryDetails
Table Name: SHKProcessHistoryDetails
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
OId . . no java.math.BigDecimal DECIMAL 19,0 . .
Version..nointINTEGER4,0..
ProcessIdyesnonoStringVARCHAR100 . .
ProcessHistoryInfonoyesnoProcessHistoryInfoDO DECIMAL 19,0 ProcessHistoryInfoSHKProcessHistoryInfo
TheTypeyesnonointINTEGER12,0 . .
RecordedTimeyesnonolongBIGINT20,0 . .
RecordedTimeTZOyesnonolongBIGINT20,0 . .
TheUsernameyesnonoStringVARCHAR100 . .
PriorityyesnoyesintINTEGER12,0 . .
LimitTimeyesnoyeslongBIGINT20,0 . .
DescriptionyesnoyesStringVARCHAR254 . .
NameyesnoyesStringVARCHAR254 . .
VariableDefinitionIdyesnoyesStringVARCHAR100 . .
VariableTypenonoyesintINTEGER12,0 . .
VariableValuenonoyesbyte[]LONGVARBINARY . . .
VariableValueXMLnonoyesorg.w3c.dom.NodeLONGVARCHAR . . .
VariableValueVCHARnonoyesStringVARCHAR4000 . .
VariableValueDBLnonoyesdoubleDOUBLE16,16 . .
VariableValueLONGnonoyeslongBIGINT20,0 . .
VariableValueDATEnonoyesTimestampTIMESTAMP . . .
VariableValueBOOLnonoyesbooleanBIT3,0 . .
OrdNoyesnonointINTEGER12,0 . .
CNTnononojava.math.BigDecimalDECIMAL19,0 . .

Indexes
index
indexColumn
iduniqueclusteredidincluded
ProcessHistoryDetails-I1yesnoCNT
ProcessHistoryDetails-I2nonoProcessId


Class:
ProcessHistoryInfo
id: ProcessHistoryInfo
Table Name: SHKProcessHistoryInfo
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false

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

Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
OId . . no java.math.BigDecimal DECIMAL 19,0 . .
Version..nointINTEGER4,0..
ProcessIdyesnonoStringVARCHAR100 . .
ProcessNameyesnoyesStringVARCHAR254 . .
ProcessFactoryNameyesnonoStringVARCHAR200 . .
ProcessFactoryVersionyesnonoStringVARCHAR20 . .
ProcessDefinitionIdyesnonoStringVARCHAR90 . .
ProcessDefinitionNameyesnoyesStringVARCHAR90 . .
ProcessPriorityyesnoyesintINTEGER12,0 . .
ProcessLimitTimeyesnoyeslongBIGINT20,0 . .
ProcessDescriptionyesnoyesStringVARCHAR254 . .
PackageIdyesnonoStringVARCHAR90 . .
PActivityIdyesnoyesStringVARCHAR100 . .
PProcessIdyesnoyesStringVARCHAR100 . .
PProcessNameyesnoyesStringVARCHAR254 . .
PProcessFactoryNameyesnoyesStringVARCHAR200 . .
PProcessFactoryVersionyesnoyesStringVARCHAR20 . .
PActivityDefinitionIdyesnoyesStringVARCHAR90 . .
PActivityDefinitionNameyesnoyesStringVARCHAR90 . .
PProcessDefinitionIdyesnoyesStringVARCHAR90 . .
PProcessDefinitionNameyesnoyesStringVARCHAR90 . .
PPackageIdyesnoyesStringVARCHAR90 . .
CreatedTimeyesnoyeslongBIGINT20,0 . .
CreatedTimeTZOyesnoyeslongBIGINT20,0 . .
StartedTimeyesnoyeslongBIGINT20,0 . .
StartedTimeTZOyesnoyeslongBIGINT20,0 . .
SuspendedTimeyesnoyeslongBIGINT20,0 . .
SuspendedTimeTZOyesnoyeslongBIGINT20,0 . .
ResumedTimeyesnoyeslongBIGINT20,0 . .
ResumedTimeTZOyesnoyeslongBIGINT20,0 . .
ClosedTimeyesnoyeslongBIGINT20,0 . .
ClosedTimeTZOyesnoyeslongBIGINT20,0 . .
DeletionTimeyesnoyeslongBIGINT20,0 . .
DeletionTimeTZOyesnoyeslongBIGINT20,0 . .
CreatedByUsernameyesnoyesStringVARCHAR100 . .
StartedByUsernameyesnoyesStringVARCHAR100 . .
SuspendedByUsernameyesnoyesStringVARCHAR100 . .
ResumedByUsernameyesnoyesStringVARCHAR100 . .
ClosedByUsernameyesnoyesStringVARCHAR100 . .
DeletedByUsernameyesnoyesStringVARCHAR100 . .
LastStateyesnoyesStringVARCHAR100 . .
LastStateTimeyesnoyeslongBIGINT20,0 . .
LastStateTimeTZOyesnoyeslongBIGINT20,0 . .
LastRecordedTimeyesnoyeslongBIGINT20,0 . .
LastRecordedTimeTZOyesnoyeslongBIGINT20,0 . .
ProcessDurationyesnoyeslongBIGINT20,0 . .
IsDeletedyesnoyesbooleanBIT3,0 . .

Indexes
index
indexColumn
iduniqueclusteredidincluded
ProcessHistoryInfo-I1yesnoProcessId