Your company decided to use Cloud Spanner as a backend for its new e-commerce application. The application requires a relational database model with strong consistency and high availability. You've been assigned to create the database schema. How would you design the tables and indices to efficiently query orders based on user ID and status?