Primary data table (compounds)

[petermr]

[cut and pasted from Word]

infocdata

icoid(PK)                 pid(fk)                  coid(fk)                          percent                                  ppid(fk)   
    cagroup(Array of FKs)

        **infocdata**

expcid(fk)                  idfnid(fk)                             casid(fk)

and descriptions • compounddata: coid(pk) auto_increment, coname, chname • plantpartdata: ppid(pk) auto_increment, ppname • compoundactivitydata: caid(pk) auto_increment, caname • expconditiondata: expcid(pk) auto_increment, expcname • identificationdata: idfnid(pk) auto_increment, idfnname • casdata: casid(pk) auto_increment, casno

[petermr]

This table should describe properties of the compound (independent of the plant or experiment. My current guess is:

• compound data should be included
• plantparts should be moved to Observation (not yet created)
• compound activity MIGHT be associated with compound OR with observation OR excluded (Action: discuss)
• expconditiondata (need more description) ACTION
• identification data ((need more description) ACTION
• CAS data: direct attribute of compund. Flatten to a single column attribute or remove altogether

The primary test is:

• if this data is always associated with this compound it is an attribute
• if this data is can be separated from the compound it probably needs to be in a separate table