Hi,
What I have understood is here venues will get listed with your portal and people(couple as you have said) can just find them by different searching parameters. I am not going in detail with those parameters as those are not an issue. But I would like to make sure how you want to make sure that once a customer inquires something over the portal and get real time result .. As some venues can also be booked by someone else earlier. I know any so called booking is not there on the portal but when a customer choose a date , time then certainly an already booked venue should not come in the listing right?
If you have API to integrate in your partners site then only you can fetch real time availability . people will search venues and you will get live data from those partner website/application.
Regarding the challenges we were discussing about, the platform will fetch hotels, apartments on selected criteria based. When those partners are get listed into the portal then they have to put their chair, tables, liquor , car parking , catering etc availability . Customer comes to your portal and selects his/her desired criteria and based on that we will fetch those relevant venues from Database. MYSQL will be the database as you have asked.
It would have a massive database stuffs and yes you are right the challenges lie in the different offers that are provided by the venue owners.
Look forward to discuss further,
Best Regards,
Prasun