sportsnet's People
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)
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.
Qualifications tracking
- TeamStaffTypeQual (looks to have been abandoned in season 14 (2018)
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. ๐๐๐
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google โค๏ธ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.