Changes between Version 12 and Version 13 of ERModel


Ignore:
Timestamp:
09/21/26 15:26:45 (6 days ago)
Author:
236024
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ERModel

    v12 v13  
    5555==== !MembershipStages ====
    5656
    57 !MembershipStages stores the possible membership stages used in membership history, such as observer, young member, full member, and alumni. It is modeled separately even though the member subtypes exist because the has_stage relationship needs to store historical periods with valid_from and valid_to.
     57!MembershipStages stores the possible membership stages used in membership history, such as observer, young member, full member, and alumni. It is modeled separately even though the member subtypes exist because !MembershipStageRecords store historical periods with valid_from and valid_to.
    5858
    5959 * '''Candidate keys:''' ms_id and ms_name. ms_id is chosen as the primary key because membership stage names are text labels. ms_name is unique.
    … …  
    218218==== Members Membership-Type Specialization ====
    219219
    220 This disjoint specialization separates Members into Observers, !YoungMembers, !FullMembers, and Alumni. It is needed to show the main membership stadiums clearly in the conceptual ER model. The historical periods of these stages are still stored through has_stage.
     220This disjoint specialization separates Members into Observers, !YoungMembers, !FullMembers, and Alumni. It is needed to show the main membership stages clearly in the conceptual ER model. The historical periods of these stages are stored in !MembershipStageRecords.
    221221
    222222==== !OrganizationalFunctions Board/!NonBoard Specialization ====