Database model

[keveri]

Any comments about this kind of database model? If it's not clear check this.

Player
  name T.Text

Course
  name T.Text

Hole
  courseId CourseId
  number Int
  par Int

Throw
  playerId PlayerId
  scorecardId ScorecardId
  holeId HoleId
  score Int

PlayerScorecard
  playerId PlayerId
  scorecardId ScorecardId
  UniquePlayerScorecard playerId scorecardId

Scorecard
  name T.Text
  courseId CourseId
  createdAt UTCTime default=CURRENT_TIME
  updatedAt UTCTim

Later we can add also location, status and some other extra info.

[visav]

Course should probably have something about version? To track the changes over time. This could be implemented later though.

[keveri]

Yes good idea. We should think more about the course stuff after we get a simple version working.

[visav]

Agreed.
What is the UniquePlayerScorecardfor?

[keveri]

Something library related for many to many relations.

[thevangelist]

Seems alright for MVP