Refactoring table structure and normalizing names

[petermr]

I have added refactoring requirements to each of the 14 tables. In general these are:

• keep table
• merge tables
• delete table without merging

For keep/merge we need to

• rename fields
• describe fields
• gradually normalize and clean content

The tables are listed in https://github.com/gilienv/EssOilDB/blob/master/ESSOilDB_PosterDocumentation.md and fall into categories:

• data reported in publication
• data deducible from data in database. These are generally used for searching and include

• plant family (Table 4)
• chemicalgroup (Table 11)
• compoundactivity (Table 13)

• tables with no future use (Table 5, habitat (NOT habit))
• tables to merge into other tables (Table 7, collection time)

== Immediate activity: (Please comment) ==

• merge plantfamily into plant (add new field) and delete plantfamily table
• merge chemical group into compound table and delete chemical group
• remove compound activity tabke (completely derived)
• remove habitat table
• merge collection time into profile (extra field)
• make sure all varities and cultivars are kept as new field in plant
• make sure that all hybrids are kept a new field in plant.

== longer term ==

• create search tools with generic information (families, etc, maybe using RDF)
• transform collection time into ISO 8601 datetime format

[petermr]

have added "wireframe"s (images) as drafts of new structure. Warning:
There may be details missing.

These have the functions:

• help develop the new table structure
• act as draft for poster

[petermr]

The new tables and their fields need documenting.
Shruthi and Vinita.

[Shruthi-M]

The new tables and their fields need documenting.
Shruthi and Vinita.

Sir, Manish is working on the restructuring of tables. Yesterday, after I had a short discussion with Gitanjali ma'am, I realised that a lot of work is pending related to the disambiguation of plant names (eg: some scientific names have 2 authors in the GBIF database). I am currently working on it.

[petermr]

Good! Concentrate on plants at the moment. But document what the columns in the plant table mean.

…

On Thu, Jul 25, 2019 at 10:30 AM Shruthi-M ***@***.***> wrote: The new tables and their fields need documenting. Shruthi and Vinita. Sir, Manish is working on the restructuring of tables. Yesterday, after I had a short discussion with Gitanjali ma'am, I realised that a lot of work is pending related to the disambiguation of plant names (eg: some scientific names have 2 authors in the GBIF database). I am currently working on it. — You are receiving this because you were assigned. Reply to this email directly, view it on GitHub <#78?email_source=notifications&email_token=AAFTCS3EBSJDFR2A7B4SJOTQBFXCXA5CNFSM4ICNDZ72YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD2Y5NYA#issuecomment-514971360>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAFTCSYHTTQGS63AJWORUHDQBFXCXANCNFSM4ICNDZ7Q> .

-- Peter Murray-Rust Founder ContentMine.org and Reader Emeritus in Molecular Informatics Dept. Of Chemistry, University of Cambridge, CB2 1EW, UK