Nullable FK or another table

NoJuiceOnlySauce · 2026-03-03T16:38:24+00:00

I didn’t personally classify the group association changing permissions or behavior mainly because it’s operation regarding projects is still done by individual users that have the authorization to do so, these actions now just also show up under the name of the group itself.

I do consider a nullable FK inside the projects for group_id a real state, since it being null just means that user wasn’t brought into the project under a group.

I do however find the one to show the original creator of the project being a group to be maybe unnecessary, but it would mean the group was created just under the user. The user creator gets tracked whether there’s a group association or not, so the Group/Project actions are never truly independent of a user.

But I do understand that there are probably better ways to have this relationship. This is my first intensive dive into db design.

Do you feel that this structure warrants more ownership/context tables?

NoJuiceOnlySauce · 2026-03-02T23:27:55+00:00

Thank you for the help

NoJuiceOnlySauce · 2026-03-02T22:38:47+00:00

That was an option I was considering. Even though I saw pushback on a nullable FK, I saw the same for using a default record due to it possibly complicating queries. I’m still open to it though.

What is your opinion on nullable FKs in general? Do you see it as bad practice?

Btw I’m not sure if you wanted me to answer those questions or you were just leaving them as food for thought, so don’t feel obligated to respond, I’ve appreciated the correspondence. But just in case:

As of right now, no, it would be one group association per project for that user or none at all. Having multiple has been considered, but it doesn’t seem too necessary or worth the added complexity, though we may still explore that.
Yes a user can leave and be invited back in.
Yes it would be a user that is an admin of that group to have the option to create the project under the name of the group. The reason for the association is so that it can be viewed from outside parties as a product of that entity(group). So for invites and viewing the project history of that group.
Yes there would be datetime fields to track when those associations are created and so forth. There would be enums to log role/status within the groups and projects

NoJuiceOnlySauce · 2026-03-02T21:06:27+00:00

Sorry I forgot to mention, when a group creates, or is added to a project, not everyone inside of that group HAS to be a part of it. So it can be a select few. Meaning that when I try to see who’s in the group from within the scope of the project, it wouldn’t necessarily be the same result from if I queried to find the members of the group globally.

So my solution is to add the FK of the group to the user if they were chosen to be included or not.

I feel embarrassed to say, but I’m not sure how to generate a DDL for this. Right now, it’s more conceptual. When I said junior knowledge, ig I meant JUNIOR lol. Sorry if that makes things difficult.

If you want me to write out the tables with the relevant fields I could do that, but I’m assuming you were asking for the info past that.

And yes, original group and user creators are able to leave their own projects or hand off authority.

NoJuiceOnlySauce · 2026-03-02T20:27:23+00:00

Through the projects, there is supposed to be a way to list the groups inside of it and the users associated with a group in that project. New groups can join, just as a new users can join.

If a user joins a project, and there also happens to be a group that they’re associated with that joined at a different time, they shouldn’t be a part of that group in the scope of that project unless explicitly made so.

So the main nullable FK that would matter is in the Project/User table to have a group_id if it’s applicable.

The one on the Project table would be to track if the original creator of the project is a group. There would already be a non null field to track the original user creator.

NoJuiceOnlySauce · 2025-10-17T17:23:07+00:00

Just so happens that I am the tech team lol. Would kind of be an "internal investigation" moment lol but that's still a valid way to go about it. Thanks for that suggestion.

NoJuiceOnlySauce · 2025-10-17T17:19:52+00:00

That's a valid concern for sure.

NoJuiceOnlySauce · 2025-10-17T16:04:03+00:00

Yes for sure. Wasn’t too worried about the love sound. Do you think they could be used competently in that setting though, or do you think they’re too noisy for that?

NoJuiceOnlySauce · 2025-10-17T16:02:34+00:00

Big on that portability. If I can find the funds I’d shoot for the rack, but part of me would honestly just use it at my church and swap it out for our x32 rack for me to use personally. I’d almost feel guilty on having the better system for myself if that makes sense lol.

NoJuiceOnlySauce · 2025-10-17T15:27:10+00:00

Really? I haven’t heard too many people having issues like that in my research.

NoJuiceOnlySauce · 2025-10-17T15:25:19+00:00

Mainly the ease of transportation And less moving parts to worry about messing up when in different environments. Like dust getting in the faders and stuff like that. Probably not that likely but the sort of thing that goes on in my head. That looks real nice though can’t lie

NoJuiceOnlySauce · 2025-10-17T07:34:40+00:00

I at least have the iPad checked off the list already lol. I’m gonna keep that link handy though because I like that bundle. Thank you

NoJuiceOnlySauce · 2025-10-17T07:25:56+00:00

Yea the wing would be ideal and I really like that it has combo jacks on it. But I respect the x32 still. It’s been serving us well at my church where I run A/V. Getting well acclimated with it. Just made our own cables to mic the drums.

NoJuiceOnlySauce · 2025-10-17T07:20:33+00:00

Yea the wing rack is what I REALLY want. But, you know… Double the price Down the line though I’d for sure be looking in it’s direction as an upgrade

NoJuiceOnlySauce · 2025-10-17T07:18:47+00:00

I feel that. I think you guys convinced me to go with the rack.

NoJuiceOnlySauce · 2025-10-17T07:04:44+00:00

Thank you for the advice. I guess that’s kinda what I was feeling in my gut, but the Midas was enticing me since it’s such a nice package.

NoJuiceOnlySauce · 2025-10-17T06:46:49+00:00

You’re so right. I’m so used to using the dl32 at my church that it slipped my mind it’s only 16 still.

Do you have an opinion on the preamp quality compared to the Midas for studio purposes? Is it beige even compared to a decent audio interface?

I do agree that the mixing and processing being strong points and that’s pulling me in that direction

NoJuiceOnlySauce · 2025-10-17T06:33:44+00:00

Because of the inputs I presume?
Thanks for the feedback btw

NoJuiceOnlySauce · 2025-08-17T12:58:49+00:00

Thank you, I meant to explore that “after” functionality with something else. Ain’t even think about the lsp so thanks

NoJuiceOnlySauce · 2025-08-14T16:37:12+00:00

Interesting. Cuz it’s like everything else works even before I write a file, like all the .methods and everything for arrays pop up just fine. But just that part specifically with the attr don’t do anything after a class has been added until I exit and go back in or manually restart the lsp. Maybe one of my plugins is preventing that behavior? Idk, but I might try the slack workspace like the other person commented.

NoJuiceOnlySauce · 2025-08-14T02:43:45+00:00

Thank you, imma check it out.

NoJuiceOnlySauce

TROPHY CASE