Membership system with payment integration (Wordpress?) and the possibility for subscribers to edit own rows in existing database tables. No custom code, just configurations. Ideally Wordpress + Plugins.

We are looking for a: - Wordpress based membership system with - payment integration and - the possibility subscribers to edit own rows in existing tables The system should be based on Wordpress and on plugins. Neither Wordpress, nore the used plugins should use custom code. This allows both Wordpress and the plugins to be updated normally when updates arrive. The functionality that allows the subscribers to edit their own rows should be implemented as a configuration of the used plugins. The tables that subscribers should be able to edit reside on a different database as the wordpress database. A table contains data for multiple subscribers. One subscriber should however only be able to add new data and modify data corresponding to his “user id”, which is a table field used as an unique identifier for a subscriber. For example, I have an existing MariaDB database X with a table A inside it that has: - 1 column for the user identifier (user id) - 1 column containing integers (product id) linked to a second table B (also in database X) that matches the integers to a string (product name). In MariaDB one can select both using LEFT JOIN. I would like to have WP front end users that are able to add, view and edit their own rows in the table A which is on a different database than the WP database (database X and the WP database are on the same server, just different databases) When users edit their rows in table A I want them to see the the "product name" from table B (e.g. via LEFT JOIN) instead of the product id existing in table A. This is just what the users see. When they save a row, the "product id" should get updated to the corresponding "product name" that the user selected. Please find attached examples of 2 tables in database X that require subscribers to edit their "rows" based on "customer_id" or "bot_customer_id", both of which are the subscriber's unique identifier. Also, the "bot_template_id" needs to be mapped to a 3rd table that contains the field "bot_name" based on the "bot_id". When a customer edits the "bot_template_id" of one his own records, what he actually sees is a select box with strings containing values of "bot_name". I believe this feature is called "foreign key" in the wpDataTables plugin. As a suggestion, the described functionality could be achieved by using Wordpress and the plugins “Paid Memberships Pro” for the memberships and payment integration as well as “wpDataTables” to edit existing tables. This is just a suggestion, nothing more. It is crucial that there’s no custom code which would prevent updates for Wordpress and the used plugins. If you have an alternative to Wordpress+Plugins which is free and possibly open source that gets the same job done, I’m opened to discussing this.