[Resolved] Db structure suggestion

[Author]

Posts

[nicolaS-3]

I'd like to create a db where anonymous user A invites another anonymous user B for dating. If B accepts the invitation he can see the profile of user A. The WP user table already exists and I thought to create a Many-to-Many Relationship with itself but I am not sure it can work. Your M-to-M user guide describes post relationship, not user relationships. Any suggestion about how to structure the db with Types? I am open to any solution.
Thank you.

[Luo Yang]

Hi,

As you can see, the Toolset many-to-many relationship works only for two post types, it does not work for wordpress users.

But I think there is a workaround for your case, for example:
1) you can setup a custom post type "Invitation", with two custom fields:
a) Numeric field (inviting user ID)
b) checkbox field(Accept)

2) Create a view to list all wordpress users, when click the link, pass the user's ID as an URL parameter "inviting-user-id" to the target page

3) In the target page, create a CRED form with field (inviting user ID) for creating "Invitation" post, the value of field "inviting user ID" is preset by URL parameter "inviting-user-id":
https://toolset.com/documentation/user-guides/cred-shortcodes/#cred_field
value: Preset value

4) Create another page "My invitations", in this page, create a view list "Invitation" posts, filter by the field (inviting user ID) equal to current user's ID:
https://toolset.com/documentation/user-guides/filtering-views-by-custom-fields/#source-for-compare-value
Shortcode attribute: The value for the filter comes from an attribute in the View shortcode
https://toolset.com/documentation/user-guides/views-shortcodes/#wpv-current-user
This shortcode outputs the information about the current, logged-in user.

And display a CRED form edit link of below CRED form:
https://toolset.com/documentation/user-guides/displaying-cred-editing-forms/

5) Create a CRED form for editing "Invitation" post, with checkbox field(Accept), user can accept the invitation.

6) Create a page "Accepted invitations", in this page, create a view, list "Invitation" posts, filter by post author is current user, and field(Accept) is enabled, so users will be able to see all "Accepted invitations"
https://toolset.com/documentation/user-guides/filtering-views-query-by-author/

For your reference.

[nicolaS-3]

Hi Luo Yang
thank you very much for the above indications, this was exactly what I was liikong for to start the project. I will go through every step carefully and let you know. Kind regards
Nicola