Change Paleo Context relationship type

[Grant]

Read this first:

Shared vs. Embedded Records & Configuration

For some database relationships in Specify, you can choose to either share or embed a related record between two tables. This is most commonly asked when configuring the following tables: Collecting Event Paleo Context Shared vs. Embedded Collecting Event A Collecting Event (CE) is a place and time that a collection is made. In some disciplines, a field number is used as the primary designation for place and time information, while in others, locality name and date are used to link specimens…

This is should only be done before working in your database. If you would like to change this relationship time after data has been entered, please contact support@specifysoftware.org for more information.

PaleoContext → Collection Object

If only 1 discipline:

UPDATE discipline SET PaleoContextChildTable='collectionobject', IsPaleoContextEmbedded=true;

Otherwise, replace the XX in disciplineid with the Discipline’s ID that you would like to change the PaleoContext.

UPDATE discipline SET PaleoContextChildTable='collectionobject', IsPaleoContextEmbedded=true WHERE disciplineid=XX;

PaleoContext → Collecting Event

If only 1 discipline:

UPDATE discipline SET PaleoContextChildTable='collectingevent', IsPaleoContextEmbedded=true;

Otherwise, replace the XX in disciplineid with the Discipline’s ID that you would like to change the PaleoContext.

UPDATE discipline SET PaleoContextChildTable='collectingevent', IsPaleoContextEmbedded=true WHERE disciplineid=XX;

PaleoContext → Locality

If only 1 discipline:

UPDATE discipline SET PaleoContextChildTable='locality', IsPaleoContextEmbedded=true;

Otherwise, replace the XX in disciplineid with the Discipline’s ID that you would like to change the PaleoContext.

UPDATE discipline SET PaleoContextChildTable='locality', IsPaleoContextEmbedded=true WHERE disciplineid=XX;

[mcruz]

Why would someone want to do this for their collection?
Can more information be provided as to the use-case and what it means if IsPaleoContextEmbedded is true and what it means if it is false?

Thank you

[Grant]

Why would someone want to do this for their collection?

Paleontology collections link paleo context information to the collection object, collecting event, or locality based on their data. It depends on how they conceptualize this relationship from each level.

Can more information be provided as to the use-case and what it means if IsPaleoContextEmbedded is true and what it means if it is false?

If isPaleoContextEmbedded is true, each Paleo Context record is unique to whichever record it is scoped to (CO/CE/Loc).

If isPaleoContextEmbedded is false, you can share a single Paleo Context level with any number of CO/CE/Loc records