Change Paleo Context relationship type

Documentation Configuration & Installation
, ,
1

:warning: 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;
2

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

3

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