[GeneX-dev] Re: Checked in table changes...

[<ja...@op...>]

"Michael Pear" <mic...@ho...> writes:

>  I checked in the table changes we discussed to the genex2 branch.
> --------------------------
> 
>         * SequenceFeature.tablepg
>         Added plate_identifier,plate_row, plate_col

There are two possible locations for this information. One is in the
SF table, as you have put them, the other is in the AL_Spots
table. The decision to have them one place or the other depends on how
we wish to use the SF table.

Here was my original desire:
* The info in AL_Spots describes *exactly* what is on the array, cDNA,
  oligo, PCR product, etc.
* the SF table would represent the higher level entity that the spot
  is attempting to measure, which corresponds to the 'Reporter' notion
  or our old CSF notion.

This way entries in the AL_Spots table are specific to each layout
(and thus would want plate, row, and column), and the SF table could
be shared among different layouts.

On the other hand, we could also put the information about what is in
each spot in the SF table, the only drawback is that it would get
pretty redundant with multiple layouts having to potentially re-enter
the same information multiple times.

That said, I don't see any drawbacks with either approach. Can you see
any drawbacks with re-utilizing the SF entries with multiple layouts?
If you can, we should use the approach you checked in. If you don't
forsee any re-use issues, I'd like to move those columns into
AL_Spots. 

jas.