Hey everyone, I'm fairly new to supabase and databases in general. I'm trying to build a simple news site where each article has multiple entities mentioned. For example "Google and snapchat sign an agreement" would have two entities Google and Snapchat.

I would normally create a pivot table called something like

articles_entities

and in there I would store a reference to articles and entities they are associated to

great, this helps, thanks