I am currently learning database modelling and struggling to model the following requirement. I have a user
and sports_club
table. User can only join a sports_club
if three existing users of the club approve his request. If the number of members in club are less than three then all the existing members (whatever 2, 1 ) need to approve his request. My table looks something like this:
I am struggling to model this approval process in my database? Could anyone help me here? Sports club can have any number of users.