>>106140705 (OP)Come up with a scheme on pen and paper, and implement it while using AI as a recommendation bot to write queries.
Making AI do something always results in crap.
Letting AI help you do something is better.
>money making web appThe database scheme isn't something you can easily change. Even when you create migration scripts and whatever.
If you fuck it up and your most used queries are slow, you increase server costs and make your app slower. Having a good database scheme is very important.
Meanwhile front-end can be total slop and nothing matters, because you can fix it at any time.