matching system - need pointers?
if i am creating a match system.. so if i like a user, and they like me back its a match.. then we can chat and if we like each other then propose some dates we can swap houses (its a home swap system not dating :p) how would i do it?
currently i have a likes table.. so if i like you, i will check if you have liked me before and then perhaps create a match/proposal table (status = initial).. which will link to chat table..
after either of us propose some dates i turn it into pending.. the other user can then accept/reject/propose new dates..
if accepted.. i then have to get people to pay.. (invoices, with one row for each person?)
proposal table = id, recipient_id, 'sender_id', status, start_date, end_date, guests
Please or to participate in this conversation.