Family Office Person
The family office person table shows the association between a person and a family office, which is an organization formed for the management of wealth and financial affairs of affluent families. A person may be a member of more than one family office.
Data Field | Key Type | Data Field Type | Recommended Character Limit |
|---|---|---|---|
family_office_person_id | Primary Key | String | |
person_id | Foreign Key | String | |
organization_id | Foreign Key | String | |
primary_contact_role_id | | String | |
primary_contact_person_id | | String | |
Family Office Person Field Descriptions
family_office_person_id (PK)
This is the primary key for the table, i.e., it uniquely identifies each record in the table.
person_id (FK)
The ID helps identify and reference a specific record (person) within the system.
organization_id (FK) The ID helps identify and reference a specific record (organization) within the system. The organizations in this table are family offices.
primary_contact_role_id
primary_contact_person_id