Build a PowerApps application with Database backend

We are looking for a PowerApps application, that
* has a user frontend, for users to query the database table (Dataverse possibly) for data
* has a manager frontend to put data into the database table
* has a moderator frontend to query and manage the data in the table (moderator view)

Details:
* The database part is only one table with rows that reference themselves. One can follow a trail of references to check which rows are connected. Simply speaking, this referencing trail builds a kind of graph
* The user frontend allows the user to enter a string and submit the data. Then, the application should query the DB-table for said trail of references and output that string to the user
* The manager frontend should allow the manager to enter new rows into the table,
* the moderator frontend should act in a similar way as the user frontend, with the difference that on the result page, the referenced rows should be changeable / deletable.

We currently anticipate the following columns in the database table:
* id : bigint, primary-key
* name : varchar(500)
* reference : bigint -> references id-column
* reference_type : varchar(1000)
* type : int
* comment : varchar(1000)