soeretypo: database schema modifications

Bug #878842 reported by Olivier Maury on 2011-10-20
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Datum
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
Olivier Maury (olivier-maury) wrote :

As parameters and methods were deleted in BasePRO, the last part of the bug report will be done in the future.

Changed in datum:
status: In Progress → Fix Committed
Changed in datum:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers