Setup membership tables

[iarp]

• Person contains all people entries

  • SMId ? garbage, sports manager

• PersonMapping (looks to be import system id mapping)

• PersonMappingLog

• PersonDocument

• DocumentCatg

• DocumentEquiv

• DocumentEquivDtl

• DocumentLevel

• DocumentType

• Adult - This is where parents are stored.

• AdultType - Adult1, Adult2, Guardian

• Player - the actual players themselves, linked to teams via PlayerSeason

  • RegPositionId ? where is this from?
  • PositionPlayedId - necessary to have the extra table? Do positions ever change?
  • BodyChecking - is this a Person thing?
  • Lefty?
  • PlayerStartDate - all dates null
  • RegCount
  • RegLastDate - all dates null
  • PlayerComments - where does this come from?

• PlayerSeason

  • Can this be merged into Player?
  • BodyChecking - is this a Person thing?
  • PlayerTypeId - again?
  • PlayerClass ? Seems to be one of: -, Major, Minor
  • Category?
  • Group?
  • SignupDate
  • SignupStatus - Pending/Approved
  • PlayerAvailable - true/false
  • Package
  • Comments (all empty)

• PlayerType

  • AlternatePool
  • PlayerPool
  • SparePool
  • Offense
  • Defense
  • Goaltender

• PlayerPositionType

  • LeftWing
  • Centre
  • RightWing
  • LeftDefence
  • RightDefence
  • GoalTender
  • Forward
  • Defence
  • Active

• GenderType

PersonDocument looks to be qualifications, there is a Qualications table but I'm unsure of how its currently used (see TeamStaffTypeQual table)

PersonMapping looks to be a map between duplicated hcid 's from report imported in the past.