[Gdpdm-devel] div_locality_id

[Terry C. <tm...@co...>]

Isaak,

Regarding div_locality_id in tables div_obs_unit
and div_accession_collecting...

div_accession_collecting.div_locality_id is NOT required.
So put NULL for unknown localities.

div_obs_unit.div_locality_id IS required.
So put as much information as you know in the
div_locality table.   Maybe you know the country at least.
If you know nothing, make an "unknown" entry in
the div_locality table for this purpose.




Cheers,

Terry






---------- Forwarded message from Isaak----------

>
> 3. I am normalizing data in div_locality table. Not all germplasm
> accessions have locality data. And, as I assign FK in the div_obs_unit or
> div_accession_collecting tables, I find that some records in these tables
> will not have FK in the div_locality_id field: since there is no locality
> data related to them.
>
> What do I do? leave these records with out the FK??? please look at the
> attached Fk file for illustration.
>