---
title: Personal Relationship
slug: personal-relationship
docTags: 
createdAt: 2025-11-13T17:06:38.021Z
---

The **personal relationship** table captures the family details data.

| **Data Field**                       | **Key Type** | **Data Field Type** | **Recommended Character Limit** |
| ------------------------------------ | ------------ | ------------------- | ------------------------------- |
| person\_id                           | Primary Key  | String              |                                 |
| relationship\_person\_id             | Primary Key  | String              |                                 |
| relationship\_type                   | Primary Key  | String              |                                 |
| relationship\_start\_date            |              | String              |                                 |
| relationship\_end\_date              |              | String              |                                 |
| relationship\_current\_prior\_status |              | String              |                                 |

### Person Charitable Donation Field Descriptions:

**person\_id    (PK)**
The ID helps identify and reference a specific record (person) within the system.

**relationship\_person\_id (PK)**
The ID of a person involved in a personal relationship.

**relationship\_type (PK)
**
The type of personal relationship between individuals, returned as a text value.

**relationship\_start\_date
**
Retrieves the start date for when the relationship began.

**relationship\_end\_date
**
Retrieves the end date for when the relationship ended.

**relationship\_current\_prior\_status
**
Retrieves the status of a personal relationship, showing whether it is current or from the past.