JPA Schema of the persistence in TMS and WDS

@Table and @ContainerTable

All the classes to be stored in Tempo are declared as JPA entities:

(~/projects/tempo2)>grep -e @Table **/*.java 
tms-common/src/main/java/org/intalio/tempo/workflow/auth/ACL.java:@Table(name="tempo_acl")
tms-common/src/main/java/org/intalio/tempo/workflow/task/Notification.java:@Table(name = "tempo_notification")
tms-common/src/main/java/org/intalio/tempo/workflow/task/PATask.java:@Table(name = "tempo_pa")
tms-common/src/main/java/org/intalio/tempo/workflow/task/PIPATask.java:@Table(name = "tempo_pipa")
tms-common/src/main/java/org/intalio/tempo/workflow/task/Task.java:@Table(name = "tempo_task")
tms-common/src/main/java/org/intalio/tempo/workflow/task/attachments/Attachment.java:@Table(name="tempo_attachment")
tms-common/src/main/java/org/intalio/tempo/workflow/task/attachments/AttachmentMetadata.java:@Table(name="tempo_attachment_meta")
wds-service/src/main/java/org/intalio/tempo/workflow/wds/core/Item.java:@Table(name = "TEMPO_ITEM")

You can find the diagram of the relationship between each entities attached here.

The mapping also require a few connecting tables, tables that do not persist an entity directly, but are needed for java collections and java maps persistence. Those are the following:

(~/projects/tempo2)>grep -e @ContainerTable **/*.java
tms-common/src/main/java/org/intalio/tempo/workflow/auth/BaseRestrictedEntity.java:    @ContainerTable(name="tempo_user")
tms-common/src/main/java/org/intalio/tempo/workflow/auth/BaseRestrictedEntity.java:    @ContainerTable(name="tempo_role")
tms-common/src/main/java/org/intalio/tempo/workflow/task/PATask.java:    @ContainerTable(name = "tempo_attachment_map")
tms-common/src/main/java/org/intalio/tempo/workflow/task/Task.java:    @ContainerTable(name="tempo_acl_map")