---
title: Membership
slug: membership
createdAt: 2025-06-11T22:32:08.055Z
---

The **membership** table provides affiliations of people with professional, club, sports, and other associations.

| **Data Field**                     | **Key Type** | **Data Field Type** | **Recommended Character Limit** |
| ---------------------------------- | ------------ | ------------------- | ------------------------------- |
| membership\_id                     | Primary Key  | String              |                                 |
| person\_id                         | Foreign Key  | String              |                                 |
| organization\_id                   | Foreign Key  | String              |                                 |
| membership\_title                  |              | String              |                                 |
| membership\_start\_date            |              | Date                | 10                              |
| membership\_end\_date              |              | Date                | 10                              |
| membership\_current\_prior\_status |              | String              |                                 |

### Membership Field Descriptions

**membership\_id (PK)**
Unique ID associated to memberships held by the person. Example: 1-cmb-1245

**person\_id (FK)**
Unique ID associated to each Altrata Person. These IDs enable mapping to other tables or other entity IDs within Altrata. Example: 1-per-8690

**organization\_id (FK)**
Unique ID associated to each Altrata Organization. These IDs enable mapping to other tables or other entity IDs within Altrata. Example: 1-org-14994

**membership\_title**
The title associated to the person’s membership affiliation.

**membership\_start\_date**
Date year, month, and day when the person’s membership began. Example: 2023-01-01

**membership\_end\_date**
Date year, month, and day when the person’s membership ended. Example: 2023-12-01

**membership\_current\_prior\_status**
Indicates if the membership is current or prior (historic).
