search

mfrasca / ghini-inception

a web based interface to botanical garden databases
6 stars 1 forks source link

describe btuu database #1

Closed mfrasca closed 12 years ago

mfrasca commented 12 years ago

write a description of the current form of the database as used at the botanische tuin of the Utrecht university.

the description should explicitly include foreign keys and reference to the ITFv2 document.

mfrasca commented 12 years ago

make sure local names are associated to a language and a place. sounds better than keeping a TEXT or large string.

mfrasca commented 12 years ago

I had a good idea on explaining what "taxon/accession/location" are! taxon: know; accession: have; location: put! I know a plant: it is described as a record in the taxon table. I have a plant: it is a record in the accession table. I put a plant in the garden: a record in location table.

mfrasca commented 12 years ago

about the taxon concept: a taxon is a node in a taxonomic description. all taxon objects have

this information represents the fact that an author (e.g.: Linneus) got the idea of grouping organisms at a specific rank (e.g.: family) under a name (e.g.: Liliaceae) and this group is part of a broader group (e.g.: the order of the Liliales).

mfrasca commented 12 years ago

forgot to state: the btuu database is not "what they use at the botanische tuinen", but Eric's interpretation of what we would need for Mompox or just any garden. we are adjusting it as it does not completely match what I understood and if I understood Eric correctly, he simplified the situation so that things would be easier according to him. since I need understand the situation as it is, not in a simplified form, I close this issue.