| OLD | NEW |
| 1 # Schemas | 1 # Schemas |
| 2 | 2 |
| 3 This page documents schemas used for tasks and bots in the DB. | 3 This page documents schemas used for tasks and bots in the DB. |
| 4 | 4 |
| 5 | 5 |
| 6 ## Tasks | 6 ## Tasks |
| 7 | 7 |
| 8 The task description core has to be read in order like a story in 4 parts; each | 8 The task description core has to be read in order like a story in 4 parts; each |
| 9 block depends on the previous ones: | 9 block depends on the previous ones: |
| 10 | 10 |
| (...skipping 182 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 193 | 193 |
| 194 AppEngine's automatic key numbering is never used. The entities are directly | 194 AppEngine's automatic key numbering is never used. The entities are directly |
| 195 created with predefined keys so entity sharding can be tightly controlled to | 195 created with predefined keys so entity sharding can be tightly controlled to |
| 196 reduce DB contention. | 196 reduce DB contention. |
| 197 | 197 |
| 198 - TaskRequest has almost monotonically decreasing key ids based on time NOT'ed | 198 - TaskRequest has almost monotonically decreasing key ids based on time NOT'ed |
| 199 to make it decreasing. See task_request.py for more detail. | 199 to make it decreasing. See task_request.py for more detail. |
| 200 - TaskResultSummary has key id = 1. | 200 - TaskResultSummary has key id = 1. |
| 201 - TaskRunResult has monotonically increasing key id starting at 1. | 201 - TaskRunResult has monotonically increasing key id starting at 1. |
| 202 - TaskToRun has the key id as `dimensions_hash` value is calculated as an | 202 - TaskToRun has the key id as `dimensions_hash` value is calculated as an |
| 203 int32 from the TaskRequest.properties.dimensions dictionary. | 203 int32 from the TaskRequest.properties.dimensions list of tuples (key, |
| 204 value). |
| 204 - PerformanceStats has key id = 1. | 205 - PerformanceStats has key id = 1. |
| 205 - BotTaskDimensions and TaskDimensions have key id `dimensions_hash`. This | 206 - BotTaskDimensions and TaskDimensions have key id `dimensions_hash`. This |
| 206 value is calculated as an int32 from the TaskRequest.properties.dimensions | 207 value is calculated as an int32 from the TaskRequest.properties.dimensions |
| 207 dictionary. | 208 list of tuples (key, value). |
| 208 | 209 |
| 209 | 210 |
| 210 ## Notes | 211 ## Notes |
| 211 | 212 |
| 212 - Each root entity is tagged as Root. | 213 - Each root entity is tagged as Root. |
| 213 - Each line is annotated with the file that define the entities on this line. | 214 - Each line is annotated with the file that define the entities on this line. |
| 214 - Dotted line means a similar key relationship without actual entity | 215 - Dotted line means a similar key relationship without actual entity |
| 215 hierarchy. | 216 hierarchy. |
| OLD | NEW |