Open Issues Need Help
View All on GitHub `trial` table does not have a `SEQUENCE` attached to its `id` field about 2 months ago
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).
Complexity:
4/5
help wanted