Proposed Changes to UISIC Database

These are my proposed changes to the physical table structures for the various database subsystems which make use of the draft standard UIS fields.
Differences between this proposal and the existing UISIC draft are marked with a "-JR" on the right and highlighted.

Proposal for Exchange (new) Fields list (new) Field definitions (new) Field value codes (new)

Table Structures

The above table has been prepared as a suggestion for UISIC and UIS Mineralogy Commission discussions and has not been confirmed. All comments are welcome!

Discussion

The reasons for adding the Mineral and Specimen tables is because work is starting on them.
The reasons for adding the other tables (although no hyperlinks are given) is because they are listed in the UISIC exchprop.html - see Proposal for Exchange (original). It may encourage others to start working on the tables.

For a view of the latest official UISIC version of this information, please see the UIS Informatics Commission pages at: http://www.uisic.uis-speleo.org/exchange/tables.html.

Initial content 29th July 2001. Updated 27th January 2006