Explain the design of a search feature, such as for IRCTC, focusing on database schema and high-level architecture.
