Add simple and full reference details and eliminate letter codes
Redesign the website so that the uninformative letter-code references to literature is replaced by a simple reference, which in turn refers to a full reference. That is, simple references replace the current letter codes. Full references should be available via a popup box when you click on the simple reference.
For example, in the current system C is often used as a shorthad reference for Gleason and Cronquist 1991. In the new system there will be a numeric primary key ID, a ref_simple = Gleason & Cronquist 1991, and a ref_full = Gleason, H.A., and A. Cronquist. 1991. Manual of vascular plants of northeastern United States and adjacent Canada, second edition. New York Botanical Garden, Bronx, NY.
I have filled in a spreadsheet version of this with 16 regular references, and 10 Placeholder values that will soon be replaced in the concepts table by approximately 800 unique references. We can implement this revision before the 800 are available by retaining the placeholds. This spreadhseet is available at http://www.bio.unc.edu/faculty/peet/temp/references-new.xls
I think we can now eliminate all the other fields pertaining to references that come from ConceptMapper, and indeed ConceptMapper should pick up this simple scheme.