Data model-Documentation

Database: Standard

Package

Class

GenSecure

GenInsecure

MassDeletes

MassUpdates

DirtyDOs

org
org. enhydra
org. enhydra. shark
org. enhydra. shark. instancepersistence
org. enhydra. shark. instancepersistence. data
Activity
false
true
true
false
Compatible
ActivityData
false
true
true
false
Compatible
ActivityDataBLOB
false
true
true
false
Compatible
ActivityDataWOB
false
true
true
false
Compatible
ActivityState
false
true
true
false
Compatible
AndJoinEntry
false
true
true
false
Compatible
Assignment
false
true
true
false
Compatible
Deadline
false
true
true
false
Compatible
Process
false
true
true
false
Compatible
ProcessData
false
true
true
false
Compatible
ProcessDataBLOB
false
true
true
false
Compatible
ProcessDataWOB
false
true
true
false
Compatible
ProcessDefinition
false
true
true
false
Compatible
ProcessRequester
false
true
true
false
Compatible
ProcessState
false
true
true
false
Compatible
Resource
false
true
true
false
Compatible

Package:

org

Package:

org. enhydra

Package:

org. enhydra. shark

Package:

org. enhydra. shark. instancepersistence

Package:

org. enhydra. shark. instancepersistence. data

Classes:


Activity
ActivityData
ActivityDataBLOB
ActivityDataWOB
ActivityState
AndJoinEntry
Assignment
Deadline
Process
ProcessData
ProcessDataBLOB
ProcessDataWOB
ProcessDefinition
ProcessRequester
ProcessState
Resource
Class:
Activity
id: org.enhydra.shark.instancepersistence.data.Activity
Table Name: SHKActivities
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible

Relations
ClassTable NameAttribute
org. enhydra. shark. instancepersistence. data. ProcessRequesterSHKProcessRequestersActivityRequester
org. enhydra. shark. instancepersistence. data. AssignmentSHKAssignmentsTableActivity
org. enhydra. shark. instancepersistence. data. ActivityDataSHKActivityDataActivity
org. enhydra. shark. instancepersistence. data. ActivityDataWOBSHKActivityDataWOBActivity
org. enhydra. shark. instancepersistence. data. AndJoinEntrySHKAndJoinTableBlockActivity
org. enhydra. shark. instancepersistence. data. AndJoinEntrySHKAndJoinTableActivity
org. enhydra. shark. instancepersistence. data. DeadlineSHKDeadlinesActivity

Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
IdyesnonoStringVARCHAR100
ActivitySetDefinitionIdyesnoyesStringVARCHAR90
ActivityDefinitionIdyesnonoStringVARCHAR90
ProcessyesyesnoProcessDODECIMAL 19,0 ProcessSHKProcesses
TheResourceyesyesyesResourceDODECIMAL 19,0 ResourceSHKResourcesTable
PDefNameyesnonoStringVARCHAR200
ProcessIdyesnonoStringVARCHAR200
ResourceIdyesnoyesStringVARCHAR100
StateyesyesnoActivityStateDODECIMAL 19,0 ActivityStateSHKActivityStates
BlockActivityIdyesnoyesStringVARCHAR100
PerformeryesnoyesStringVARCHAR100
IsPerformerAsynchronousyesnoyesbooleanBIT
PriorityyesnoyesshortINTEGER
NameyesnoyesStringVARCHAR254
ActivatedyesnonolongBIGINT
ActivatedTZOyesnonolongBIGINT
AcceptedyesnoyeslongBIGINT
AcceptedTZOyesnoyeslongBIGINT
LastStateTimeyesnonolongBIGINT
LastStateTimeTZOyesnonolongBIGINT
LimitTimeyesnonolongBIGINT
LimitTimeTZOyesnonolongBIGINT
DescriptionyesnoyesStringVARCHAR254

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoId
I2nonoProcess
I2nonoActivitySetDefinitionId
I2nonoActivityDefinitionId
I3nonoProcess
I3nonoState


Class:
ActivityData
id: org.enhydra.shark.instancepersistence.data.ActivityData
Table Name: SHKActivityData
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible
Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
ActivityyesyesnoActivityDODECIMAL 19,0 ActivitySHKActivities
VariableDefinitionIdyesnonoStringVARCHAR100
VariableTypenononoshortINTEGER
VariableValuenonoyesbyte[]LONGVARBINARY
VariableValueXMLnonoyesNodeLONGVARCHAR
VariableValueVCHARnonoyesStringVARCHAR4000
VariableValueDBLnonoyesdoubleDOUBLE
VariableValueLONGnonoyeslongBIGINT
VariableValueDATEnonoyesTimestampTIMESTAMP
VariableValueBOOLnonoyesbooleanBIT
IsResultnononobooleanBIT
OrdNoyesnonointINTEGER
CNTnononoBigDecimalDECIMAL19,0

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoCNT
I2yesnoActivity
I2yesnoVariableDefinitionId
I2yesnoOrdNo


Class:
ActivityDataBLOB
id: org.enhydra.shark.instancepersistence.data.ActivityDataBLOB
Table Name: SHKActivityDataBLOBs
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible
Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
ActivityDataWOByesyesnoActivityDataWOBDODECIMAL 19,0 ActivityDataWOBSHKActivityDataWOB
VariableValuenonoyesbyte[]LONGVARBINARY
OrdNoyesnonointINTEGER

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoActivityDataWOB
I1yesnoOrdNo


Class:
ActivityDataWOB
id: org.enhydra.shark.instancepersistence.data.ActivityDataWOB
Table Name: SHKActivityDataWOB
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible

Relations
ClassTable NameAttribute
org. enhydra. shark. instancepersistence. data. ActivityDataBLOBSHKActivityDataBLOBsActivityDataWOB

Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
ActivityyesyesnoActivityDODECIMAL 19,0 ActivitySHKActivities
VariableDefinitionIdyesnonoStringVARCHAR100
VariableTypenononoshortINTEGER
VariableValueXMLnonoyesNodeLONGVARCHAR
VariableValueVCHARnonoyesStringVARCHAR4000
VariableValueDBLnonoyesdoubleDOUBLE
VariableValueLONGnonoyeslongBIGINT
VariableValueDATEnonoyesTimestampTIMESTAMP
VariableValueBOOLnonoyesbooleanBIT
IsResultnononobooleanBIT
OrdNoyesnonointINTEGER
CNTnononoBigDecimalDECIMAL19,0

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoCNT
I2yesnoActivity
I2yesnoVariableDefinitionId
I2yesnoOrdNo


Class:
ActivityState
id: org.enhydra.shark.instancepersistence.data.ActivityState
Table Name: SHKActivityStates
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible

Relations
ClassTable NameAttribute
org. enhydra. shark. instancepersistence. data. ActivitySHKActivitiesState

Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
KeyValueyesnonoStringVARCHAR30
NameyesnonoStringVARCHAR50

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoKeyValue
I2yesnoName


Class:
AndJoinEntry
id: org.enhydra.shark.instancepersistence.data.AndJoinEntry
Table Name: SHKAndJoinTable
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible
Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
ProcessyesyesnoProcessDODECIMAL 19,0 ProcessSHKProcesses
BlockActivityyesyesyesActivityDODECIMAL 19,0 ActivitySHKActivities
ActivityDefinitionIdyesnonoStringVARCHAR90
ActivityyesyesnoActivityDODECIMAL 19,0 ActivitySHKActivities
CNTnononoBigDecimalDECIMAL19,0

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoCNT
I2nonoProcess
I2nonoBlockActivity
I2nonoActivityDefinitionId
I3nonoActivity


Class:
Assignment
id: org.enhydra.shark.instancepersistence.data.Assignment
Table Name: SHKAssignmentsTable
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible
Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
ActivityyesyesnoActivityDODECIMAL 19,0 ActivitySHKActivities
TheResourceyesyesnoResourceDODECIMAL 19,0 ResourceSHKResourcesTable
ActivityIdyesnonoStringVARCHAR100
ActivityProcessIdyesnonoStringVARCHAR100
ActivityProcessDefNameyesnonoStringVARCHAR200
ResourceIdyesnonoStringVARCHAR100
IsAcceptedyesnonobooleanBIT
IsValidyesnonobooleanBIT
CNTnononoBigDecimalDECIMAL19,0

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoCNT
I2yesnoActivity
I2yesnoTheResource
I3nonoTheResource
I3nonoIsValid
I4nonoActivityId
I5nonoResourceId


Class:
Deadline
id: org.enhydra.shark.instancepersistence.data.Deadline
Table Name: SHKDeadlines
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible
Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
ProcessyesyesnoProcessDODECIMAL 19,0 ProcessSHKProcesses
ActivityyesyesnoActivityDODECIMAL 19,0 ActivitySHKActivities
CNTyesnonoBigDecimalDECIMAL19,0
TimeLimityesnonolongBIGINT
TimeLimitTZOyesnonolongBIGINT
ExceptionNameyesnonoStringVARCHAR100
IsSynchronousyesnonobooleanBIT
IsExecutedyesnonobooleanBIT

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoCNT
I2nonoProcess
I2nonoTimeLimit
I3nonoActivity
I3nonoTimeLimit


Class:
Process
id: org.enhydra.shark.instancepersistence.data.Process
Table Name: SHKProcesses
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible

Relations
ClassTable NameAttribute
org. enhydra. shark. instancepersistence. data. ActivitySHKActivitiesProcess
org. enhydra. shark. instancepersistence. data. ProcessDataSHKProcessDataProcess
org. enhydra. shark. instancepersistence. data. ProcessDataWOBSHKProcessDataWOBProcess
org. enhydra. shark. instancepersistence. data. AndJoinEntrySHKAndJoinTableProcess
org. enhydra. shark. instancepersistence. data. DeadlineSHKDeadlinesProcess

Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
SyncVersionyesnonolongBIGINT
IdyesnonoStringVARCHAR100
ProcessDefinitionyesyesnoProcessDefinitionDODECIMAL 19,0 ProcessDefinitionSHKProcessDefinitions
PDefNameyesnonoStringVARCHAR200
ActivityRequesterIdyesnoyesStringVARCHAR100
ActivityRequesterProcessIdyesnoyesStringVARCHAR100
ResourceRequesterIdyesnonoStringVARCHAR100
ExternalRequesterClassNamenonoyesStringVARCHAR254
StateyesyesnoProcessStateDODECIMAL 19,0 ProcessStateSHKProcessStates
PriorityyesnoyesshortINTEGER
NameyesnoyesStringVARCHAR254
CreatedyesnonolongBIGINT
CreatedTZOyesnonolongBIGINT
StartedyesnoyeslongBIGINT
StartedTZOyesnoyeslongBIGINT
LastStateTimeyesnonolongBIGINT
LastStateTimeTZOyesnonolongBIGINT
LimitTimeyesnonolongBIGINT
LimitTimeTZOyesnonolongBIGINT
DescriptionyesnoyesStringVARCHAR254

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoId
I2nonoProcessDefinition
I3nonoState
I4nonoActivityRequesterId
I5nonoResourceRequesterId


Class:
ProcessData
id: org.enhydra.shark.instancepersistence.data.ProcessData
Table Name: SHKProcessData
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible
Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
ProcessyesyesnoProcessDODECIMAL 19,0 ProcessSHKProcesses
VariableDefinitionIdyesnonoStringVARCHAR100
VariableTypenononoshortINTEGER
VariableValuenonoyesbyte[]LONGVARBINARY
VariableValueXMLnonoyesNodeLONGVARCHAR
VariableValueVCHARnonoyesStringVARCHAR4000
VariableValueDBLnonoyesdoubleDOUBLE
VariableValueLONGnonoyeslongBIGINT
VariableValueDATEnonoyesTimestampTIMESTAMP
VariableValueBOOLnonoyesbooleanBIT
OrdNoyesnonointINTEGER
CNTnononoBigDecimalDECIMAL19,0

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoCNT
I2yesnoProcess
I2yesnoVariableDefinitionId
I2yesnoOrdNo


Class:
ProcessDataBLOB
id: org.enhydra.shark.instancepersistence.data.ProcessDataBLOB
Table Name: SHKProcessDataBLOBs
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible
Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
ProcessDataWOByesyesnoProcessDataWOBDODECIMAL 19,0 ProcessDataWOBSHKProcessDataWOB
VariableValuenonoyesbyte[]LONGVARBINARY
OrdNoyesnonointINTEGER

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoProcessDataWOB
I1yesnoOrdNo


Class:
ProcessDataWOB
id: org.enhydra.shark.instancepersistence.data.ProcessDataWOB
Table Name: SHKProcessDataWOB
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible

Relations
ClassTable NameAttribute
org. enhydra. shark. instancepersistence. data. ProcessDataBLOBSHKProcessDataBLOBsProcessDataWOB

Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
ProcessyesyesnoProcessDODECIMAL 19,0 ProcessSHKProcesses
VariableDefinitionIdyesnonoStringVARCHAR100
VariableTypenononoshortINTEGER
VariableValueXMLnonoyesNodeLONGVARCHAR
VariableValueVCHARnonoyesStringVARCHAR4000
VariableValueDBLnonoyesdoubleDOUBLE
VariableValueLONGnonoyeslongBIGINT
VariableValueDATEnonoyesTimestampTIMESTAMP
VariableValueBOOLnonoyesbooleanBIT
OrdNoyesnonointINTEGER
CNTnononoBigDecimalDECIMAL19,0

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoCNT
I2yesnoProcess
I2yesnoVariableDefinitionId
I2yesnoOrdNo


Class:
ProcessDefinition
id: org.enhydra.shark.instancepersistence.data.ProcessDefinition
Table Name: SHKProcessDefinitions
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible

Relations
ClassTable NameAttribute
org. enhydra. shark. instancepersistence. data. ProcessSHKProcessesProcessDefinition

Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
NameyesnonoStringVARCHAR200
PackageIdyesnonoStringVARCHAR90
ProcessDefinitionIdyesnonoStringVARCHAR90
ProcessDefinitionNameyesnoyesStringVARCHAR90
ProcessDefinitionCreatedyesnonolongBIGINT
ProcessDefinitionVersionyesnonoStringVARCHAR20
StateyesnonointINTEGER

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoName


Class:
ProcessRequester
id: org.enhydra.shark.instancepersistence.data.ProcessRequester
Table Name: SHKProcessRequesters
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible
Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
IdyesnonoStringVARCHAR100
ActivityRequesteryesyesyesActivityDODECIMAL 19,0 ActivitySHKActivities
ResourceRequesteryesyesyesResourceDODECIMAL 19,0 ResourceSHKResourcesTable

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoId
I2nonoActivityRequester
I3nonoResourceRequester


Class:
ProcessState
id: org.enhydra.shark.instancepersistence.data.ProcessState
Table Name: SHKProcessStates
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible

Relations
ClassTable NameAttribute
org. enhydra. shark. instancepersistence. data. ProcessSHKProcessesState

Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
KeyValueyesnonoStringVARCHAR30
NameyesnonoStringVARCHAR50

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoKeyValue
I2yesnoName


Class:
Resource
id: org.enhydra.shark.instancepersistence.data.Resource
Table Name: SHKResourcesTable
GenerateSecure: false
GenerateInsecure: true
MassDeletes: false
MassUpdates: false
MultiDB: false
DirtyDOs: Compatible

Relations
ClassTable NameAttribute
org. enhydra. shark. instancepersistence. data. ProcessRequesterSHKProcessRequestersResourceRequester
org. enhydra. shark. instancepersistence. data. ActivitySHKActivitiesTheResource
org. enhydra. shark. instancepersistence. data. AssignmentSHKAssignmentsTableTheResource

Attributes
idQueryConstrNullJava TypeDB TypeSizeReferenceReference Table
oid..no.DECIMAL19,0..
version..no.INTEGER4..
UsernameyesnonoStringVARCHAR100
NameyesnoyesStringVARCHAR100

Indexes
index
indexColumn
iduniqueclusteredidincluded
I1yesnoUsername