Open sorenabell opened 3 years ago
cc @sabahfromlondon
I think it is important to have awards information in the contracts table. In some datasets, the number of suppliers per award is bounded (e.g. maximum 1 or 2). In such cases, it is fine to have the suppliers in the same table.
For datasets where there can be a large number of suppliers: In most cases, there is still only 1, with a small percentage having more than 1. In that case, we had discussed the possibility of filling in awards/suppliers/id, etc. if there is only 1 supplier. If there is more than 1, then leave it empty and add those suppliers to the separate suppliers table.
Related issue in Spoonbill library: https://github.com/open-contracting/spoonbill/issues/36
Based on the OCDS Lite spreadsheet, there are going to be only 4 tables for OCDS Lite: Tenders, Awards, Awards Suppliers, Contracts.
We want to make the Lite version of the data as easy to analyse by non-experienced data users as much as possible.