# Change Paleo Context relationship type

**URL:** <https://speciforum.org/t/change-paleo-context-relationship-type/1151>\
**Category:** Configuration & Installation\
**Tags:** Specify-7, Specify-6, Members-only\
**Created:** [April 28, 2023, 4:34pm UTC](https://speciforum.org/t/change-paleo-context-relationship-type/1151 "2023-04-28T16:34:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Grant](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/grant/32/4255_2.png) [@Grant](https://speciforum.org/u/Grant)\
**Post date:** [April 28, 2023, 4:34pm UTC](https://speciforum.org/t/change-paleo-context-relationship-type/1151/1 "2023-04-28T16:34:26Z")

</div>

> 📖 This guide explains how to link paleo context to the collection object, collecting event, or locality.

**Read this first:**

> [@Shared vs. Embedded Records & Configuration](https://speciforum.org/t/shared-vs-embedded-records-configuration/1712):
>
> book This guide describes the difference between shared and embedded records, what tables it can be configured for, and how to configure each. 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, …

> [!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](mailto:support@specifysoftware.org) for more information.

# PaleoContext → Collection Object

If only 1 discipline:

```sql
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.

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

```

# PaleoContext → Collecting Event

If only 1 discipline:

```sql
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.

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

```

# PaleoContext → Locality

If only 1 discipline:

```sql
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.

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

```

---

<div class="post-metadata">

**Author:** ![mcruz](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/mcruz/32/451_2.png) [@mcruz](https://speciforum.org/u/mcruz)\
**Post date:** [June 5, 2023, 7:48pm UTC](https://speciforum.org/t/change-paleo-context-relationship-type/1151/2 "2023-06-05T19:48:20Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Grant](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/grant/32/4255_2.png) [@Grant](https://speciforum.org/u/Grant)\
**Post date:** [July 25, 2023, 7:08pm UTC](https://speciforum.org/t/change-paleo-context-relationship-type/1151/3 "2023-07-25T19:08:58Z")

</div>

> 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