ktroutner / football-data-manager

Application to manage results and stats of football games

MIT License

0 stars 0 forks source link

Add detailed team info #16

Closed ktroutner closed 2 years ago

ktroutner commented 2 years ago

What

Add detailed team info

Players/staff

Why

Player data is needed to add roster information to team/match pages
Player data is needed to keep track of individual stats/records

How

New tables
- player
  - name
  - name_en
  - name_kana
  - country
  - prefecture
  - position
  - date_of_birth
  - height
  - footedness
  - status
- team_player
  - player_id
  - team_id
  - position
  - number
  - joined_on
  - left_on
  - acquisition_type
  - is_on_loan
- staff
  - name
  - name_en
  - country
  - prefecture
  - date_of_birth
  - player_id
    - if staff member is a former player
- team_staff
  - staff_id
  - team_id
  - position
  - joined_on
  - left_on