Personal Relationship
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.