soeretypo: database schema modifications
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Datum |
Fix Released
|
Critical
|
Olivier Maury |
Bug Description
Some changes must be done to integrate all changes.
A product is spread somewhere, this place is not always the sampling place.
So, a new column "pdt_lie_cn" must be added into the table "produit".
And changes done in the form.
A sampling is done with a tool (defined by a name).
So, a new table "outil_prelevement" and a new column "prv_oprv_cn", must be added.
And changes done in the form.
Synchronization with BaseECH on this table.
Laboratory name is a bit long for the interface, a code is needed.
So, a new column "lbr_a_code", unique, must be added.
A record in "element" is not used : "Sans élément", and must be deleted.
New records in Parametre and in Methode, for chemical composition, for ValidationParametre are needed.
par_nom ; par_code ; met_nom
Matière sèche ; MS
Humidité résiduelle ; HumRes ; 105°C
Carbone organique ; C org ; Anne / CHN
Azote total ; N total ; Dumas
Azote amonical sec ; N-NH4 sec ; KCl sec
Azote nitrique sec ; N-NO3 sec ; KCl sec
Azote amoniacal frais ; N-NH4 frais ; KCl frais
Azote nitrique frais ; N-NO3 frais ; KCl frais
Some parameters must be tagged with the id of BasePRO
MS : 102
HumRes : 149
C org : 1
N total : 14
SOL : 74
HEM : 75
CEL : 76
LIG : 77
CEW : 78
Same for methods
105°C : 15
550°C : 16
480°C : 48
Anne : 57
Dumas : 29
KCl frais : 19
KCl sec : 20
Related branches
Changed in datum: | |
importance: | Undecided → Critical |
assignee: | nobody → Olivier Maury (olivier-maury) |
milestone: | none → soeretypo |
description: | updated |
description: | updated |
description: | updated |
description: | updated |
description: | updated |
description: | updated |
description: | updated |
description: | updated |
description: | updated |
Changed in datum: | |
status: | New → In Progress |
Changed in datum: | |
status: | Fix Committed → Fix Released |
As parameters and methods were deleted in BasePRO, the last part of the bug report will be done in the future.