The PROFILE table is central to V1.0 it links to everything. It is critical that the keys in the new tables are linked correctly to PROFILE.
PROFILE contains the individual experiments that were done. It will contain PROFILE_DATA (a list of COMPOUND-PERCENT pairs) . Profile data should be a separate table .
DO WE HAVE A PROFILE TABLE?? It would have about 5000 records . (PROFILE_DATA will have about 142,000 records). The PROFILE table will have (see poster)
foreign key to LOCATION (Ambarish)
foreign key to PLANT (Shruthi)
foreign key to PLANTPART (who is doing this table?)
freeform date-time
freeform conditions OR link to CONDITIONS_TABLE
foreign key to BIBLIOGRAPHY
freeform experimental conditions
LINK to PROFILE_DATA (the compounds will be in this table)
It is CRITICAL this is solved before Shruthi goes.
The PROFILE table is central to V1.0 it links to everything. It is critical that the keys in the new tables are linked correctly to PROFILE.
PROFILE contains the individual experiments that were done. It will contain PROFILE_DATA (a list of COMPOUND-PERCENT pairs) . Profile data should be a separate table .
DO WE HAVE A PROFILE TABLE?? It would have about 5000 records . (PROFILE_DATA will have about 142,000 records). The PROFILE table will have (see poster)
It is CRITICAL this is solved before Shruthi goes.