Implement reference and party-related database changes
#4 Updated by Michael Lee over 19 years ago
This is a SQL statement that creates the new reference tables for all 3
modules. It also creates the appropriate relationships. It adds auxillary
tables for the closed lists that are associated with these tables and inserts
the lists values.
Currently, alternateIdentifier is orphaned; I assume we need to add a FK into
the citation (reference) table that would link to alternateIdentifier.
#10 Updated by Robert Peet over 19 years ago
Notes on the ACCESS version of the reference model
For all fields in my email of 12 Dec where I had an *, grab the definition
and embed it in the definition field in the ACCESS database.
1. aux_citation_citationType. Why SortOrd? Not sure what this ordering is
2. Table: aux_citation_titleSuperior. You missed the point here.
Citation:titleSuperior is not a constrained list, but contains a second,
higher order title where appropriate, which in the case of a chapter is a Book
title, and in the case of a Conference Presentation is the Name of the
3. aux_citationContributor_roleType. Why SortOrd? Not sure what this ordering
4. Citation:communicationType. This will be an open list, probably maintained
in aux_communicationType. Examples include memo, letter, email
5. CitationAlternateIdentifier needs to have a field that is a FK back to
6. Aux_CitationAlternateIdentifier_system is missing. This is aa open list.
This could be any identifier system. The EML definition is “An additional,
secondary identifier for this entity. The primary identifier belongs in
the "id" attribute, but additional identifiers that are used to label this
entity, possibly from different data management systems, can be listed here.”
#11 Updated by Gabriel Farrell over 19 years ago
This work is complete.
The forms for filling in references need to be updated to capture the new data.
e.g. We have a field called authors that must be replaced with many fields.
The vegbranch plots loader doesn't do references, i.e. has never done them.