Bubble Database setup

Hello all,

I have been playing about with Bubble for a while now as wanted to learn something new.

I have an idea which I’m currently working on but need help with the setup of the database.

I am building a sports attendance tracker so have the following tables -

User
Team
Players
Fixture
Attendance

What is the best way to link the tables for optimisation?

Would it be -

User - Team
Team - players
Team - Fixtures
Fixtures - Attendance

Or would this be all wrong?

Any help would be great for a newish user

I’m assuming based on your explanation (linked fields only):

USER table

  • Team (or List of Teams)

TEAM table

  • List of Users (Admin)
  • List of Players
  • List of Fixtures

PLAYERS table

  • Team
  • User (if applicable)

FIXTURE table

  • List of Teams (or Team 1 and Team 2)
  • Attendance

ATTENDANCE table

  • Fixture