Changes between Version 3 and Version 4 of Backtracking

Timestamp:

Oct 16, 2009, 3:08:43 PM (15 years ago)

Author:

jurzua

Comment:

--

Backtracking

@@ -21 +21 @@
 The following query will be used to build the current entity:
 
-  ''select * from entity, attribute,  entity_attribute where entity.id = X && attribute.id= Y &&  entity_attribute.entityId = X && entity_attribute.attributeId= Y && entity.systemStatus = “original” && attribute.systemStatus = original“.'' 
+  ''select * from entity, attribute,  entity_attribute where entity.id = X && attribute.id= Y &&  entity_attribute.entityId = X && entity_attribute.attributeId= Y && entity.systemStatus = “original” && attribute.systemStatus = original“'', where X and Y are numbers. 
+
+The attribute systemStatus is not useful to build the a version of an entity, because every entity's versions will have the same value. The attribute unique for each version is the modifier, therefore the query will look like this:
+
+  ''select * from entity, attribute,  entity_attribute where entity.id = X && attribute.id= Y &&  entity_attribute.entityId = X && entity_attribute.attributeId= Y && entity. modifier = Z && attribute. modifier = Z'', where X and Y are numbers and Z is a time stamp.