Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

New Beatmap relationships #586

Open
15 tasks
Tracked by #582
hburn7 opened this issue Jan 19, 2025 · 0 comments
Open
15 tasks
Tracked by #582

New Beatmap relationships #586

hburn7 opened this issue Jan 19, 2025 · 0 comments
Labels
area:beatmaps database:schema-change Items that contain or propose schema changes to the database project:Database Items related to the Database project project:OsuApiClient Items related to the OsuApiClient project type:feature

Comments

@hburn7
Copy link
Collaborator

hburn7 commented Jan 19, 2025 •
edited
Loading

New Beatmap relationships & entities

Overview

Altering beatmap relationships such that storage of BeatmapSet data is possible.

Dependencies

None.

Tasks

Note: See osu! API schemas here

  • New entity BeatmapSet. Has relationship of 1 BeatmapSet to 1 Player. Has schema as defined in link above.
  • New entity BeatmapAttributes. Has relationship of 1 Beatmap to many BeatmapAttributes. Has schema as defined in link above.
  • Update entity Beatmap
    • Add BeatmapSet field & link in OtrContext
    • Add BeatmapAttributes[] & link in OtrContext
    • Add PlayerId field & link in OtrContext. Relationship is Many Beatmaps to many Players
    • Remove fields
      • MapperId
      • MapperName
      • Artist
      • Title
    • Rename
      • Length to TotalLength
    • Add
      • DrainLength: int
@hburn7 hburn7 mentioned this issue Jan 19, 2025
Open
6 tasks
@hburn7 hburn7 changed the title Add / update database entities New Beatmap relationships Jan 19, 2025
@hburn7 hburn7 added type:feature area:beatmaps project:Database Items related to the Database project project:OsuApiClient Items related to the OsuApiClient project database:schema-change Items that contain or propose schema changes to the database labels Jan 19, 2025
@github-project-automation github-project-automation bot moved this to Backlog in otr-beta-v2 Jan 19, 2025
@hburn7 hburn7 moved this from Backlog to Ready in otr-beta-v2 Jan 19, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
area:beatmaps database:schema-change Items that contain or propose schema changes to the database project:Database Items related to the Database project project:OsuApiClient Items related to the OsuApiClient project type:feature
Projects
otr-beta-v2
Status: Ready
Milestone
No milestone
Development

No branches or pull requests
1 participant
@hburn7