iarp/sportsnet

sportsnet's Issues

Evaluation tables

• EvaluationGoalie
• EvaluationPlayer
• EvaluationStaff

can we combine these into one somehow?

Setup core tables

• Season
  • AgeDecidedByMM?
  • AgeDecidedByDD?
• League
• Division
  • PlayerRatingFactor?
  • AssignFirstSlotAsGoalie?
• SubDivision
  • SubDivisionRef?
  • PlayerRatingFactor?
  • DefaultNumTeams?
  • Inactive?
• Team
  • Contact* fields? Isn't that just head coach? YES just head coach details.
  • Active?
  • DraftStartPosition?
• TeamSeason (i dont see this as being necessary, merging into Team)
  • RegStatus?
  • ApprovalReq?
  • DraftStartPosition
  • Submitted?
  • Comments (RosterNotes and PlayerNotes are stored in TeamNotes with type assigned)
• TeamStaff
• TeamStaffType
  • Need to come up with permission assignments
  • Flag for bench staff status or how to maintain that?
  • Required (field, not a question)
  • TeamStaffStatusId
• TeamStaffStatus
  • IncludeInExportRoster (whats the export?)
• TeamStaffStatusReason
• TeamStaffStatusLog to log changes made by people
• TeamStatus
  • IncludeInExportRoster (whats the export?)
  • considered_approved, will this work as we want for flagging as HCR approved?
• TeamStatusReason
• TeamStatusLog

Are the following necessary?

• TeamStaffTypeQual (looks to have been abandoned in season 14 (2018)

Qualifications tracking

• TeamStaffTypeQual (looks to have been abandoned in season 14 (2018)

Setup membership tables

• 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.