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