NewcastleRSE/data-warehouse-client

AI Summary: Investigate the design decision of using a composite primary key `(id, study)` for the `trial` table in the e-Science Central Data Warehouse Client, and evaluate the feasibility and implications of replacing it with a single `SEQUENCE`-based `id` primary key. This involves considering potential data integrity issues, performance impacts, and the overall design principles of the data warehouse (scalability, schema flexibility, query performance).