|
|
| Line 11: |
Line 11: |
|
| |
|
| == Storage as attribute-value groups == | | == Storage as attribute-value groups == |
| Adding an actual new field to our database is not trivial, so in to get maximum flexibility our temporary project data is stored in attribute-value groups rather than in new fields for each project. The [[L TmpV2 table]] stores the data.
| | see [[Entity–attribute–value model of the L Tmp V2 table]] |
| * [[L TmpV2 table|L TmpV2]].project stores the project (or attribute name); there is no tight convention; but a lot of projects only need one entry but some need more, and for those two similarly named project entries will be used.
| |
| * [[L TmpV2 table|L TmpV2]].item contains the value for that project
| |
| * there are also a boolean, integer, real and notes field in each record of [[L TmpV2 table|L TmpV2]] that can be used to store additional data
| |
| The '''project''' and '''item''' fields are limited to entries in [[S tmp table]], which are supplied in a drop-down.
| |
|
| |
|
| == Related articles == | | == Related articles == |