I'm setting up relationships between models and I'm wondering if there's any harm using a bridge table for a one-to-many relationship?
i.e. These are some of the models
Each User may or may-not have a Team or Group. Would it be better to have nullable FK's in the User model for team_id, group_id, or is using bridge tables team_user, group_user acceptable? (There is little chance this will ever be a many-to-many relationship)
Would there be any ill effects in using a bridge table for one-to-many?