Changes to database tables and fields

[cmrRose]

(Priority 1) Could the HandSampleCatalogNumber be added to the thin sections table? This would allow me to link a thin section in the gallery to its corresponding sample page without having to do an additional esri query.

Added "HandSampleNumber" to ThinSection table.

[cmrRose]

(ALREADY THERE) In the thin sections table, I would also like to be able to see the "photo" field (a boolean indicating whether we have a photo of the thin section). Then I can determine whether to try to display a photo of a particular thin section.

[cmrRose]

(Priority 3) ~~In the Samples table, could be have a field that indicates "thin section photo availability" ? That seems to be what's important to filter for... So, this would be translating the 'photos' field from the thin sections table into the samples table~~

Added "ThinSectionPhotoCount" to Sample table.

[cmrRose]

(Priority 2) Add Title, Author, Year and UwdcURL fields (from the Ledgers table) to the Lithology Table.

Added “Title”, “Author”, and “UwdcUrl” to Lithology table.

(Priority 6- wait until I'm done changing the code after fields are added to the Lithology table) You can then take away the Ledgers table.

Can also remove BookId from Lithology

[cmrRose]

(Priority 7) (This can wait until later or never if needed) Add a Maps table with the following fields:

• MapID
• Title
• Scale
• UWDC URL

You will also have to add the MapID field to the Samples table.

[cmrRose]

(Priority 4) Please send me a list of all field name changes (such as 'LocNote' --> 'LocationNote'). Then let me know when you change the field names. (This will break the current functionality, so we will need to push a change to all active branches when it happens.)

Proposed changes...

• Sample.LocNote to "LocationNote"
• Sample.HandSampleCatalogNumber to "HandSampleNumber"
• Sample.NotebookNum to "NotebookNumber"
• ThinSection.CatalogNumber to "ThinSectionNumber"

All changes have been made to update references to field names

[cmrRose]

(Priority 5) You can take away the Hand Samples table. Please let me know if this changes the URL for the other tables.

[schoep]

@cmrRose Priority 1-3 changes have been made.

[schoep]

@cmrRose Priority 4 changes made.