Editable tables/dbs, linked together and with pages

[ad_1]

Hello!
I’m currently testing different possibilities for a tool for a non-profit group I work with.
We are around 100 people, so Notion ends up figuring quite expensive, so I was considering WP or even developing something myself from scratch, although WP would be ideal for simplicity if it was possible.

So the **functionality** is pretty much the one achieved by Notion Table Views, essential relational databases.

* We have 4 tables, let’s say People, Projects, Interests and Cities.
* Projects are associated with People and Interests
* People have a list of the projects their in, have cities and interests too
* Interests and Cities just refer back to the Projects and People that are linked to them, *technically these don’t need to be tables and could just be properties, but ideally I would also want to look into People and Projects associated with them*
* Ideally I could associate a page to each Project and Person
* I should be able to filter by any of the columns

Is there a way of achieving this simply?
So far I looked into Ninja Tables, but it doesn’t seem to be able to connect between tables.
If I could use with a proper database behind it. Something that just reads from the database and allows to add to it.

I’m a software engineer so I can do this in a webapp, although currently quite busy and I would like to be able to reduce overhead on my side and ease future maintenance. Further more the ability to manage logins quite easily was ideal.

Maybe I could even attempt to develop some extension myself, if this is needed could you give me some pointers on what to look for though?

My usage of WordPress has been pretty basic so far so I’m sure I’m missing some easy way to achieve this. Sorry if this is out of scope

[ad_2]