Membership

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)