that is not something any of us can answer from the info you provided. What are all these tables for? What is the relationship between them? Have you read any books on database design? Thought about hiring someone to do your design work?
100,000 tables seems a bit extreme. I have worked on numerous large scale applications and They average 200 - 600 tables for an app. Rows ranging from 1 in a table to billions.