Design a database schema for a railway booking system, detailing the tables, primary keys, and foreign key relationships.
