Gabriel Sánchez Martínez
Gabriel Sánchez Martínez
In a database, the best practice would be to leave the field null, and not require it, indicating that the information is not available or known. I would suggest allowing...
Wouldn't the JSON equivalent of `null` in a database be simply that the field isn't listed in the JSON object?
Another option to consider is separately listing the required files and fields in a file that defines a TIDES "profile". This could take the form of a JSON or CSV...
@jlstpaul Yes, very similar. I suggested a 3-column table instead of a single column table, but that's just a formatting difference and either would work. My third column with notes...
I see and agree with the issue. Without knowing much about frictionless (I hadn't heard of it before this repo), it appears from your description of it that it is...
> > 2. The concept of a loose and unchecked foreign key does come up in other cases, and it would be useful for many use cases, not just TIDES,...
> 4. Perhaps instead of calling it a foreign key, we should call it a foreign reference? Yes, it's really not a foreign key, at least not as commonly meant...
My initial vote would have been for alternative 1 (for its simplicity and coverage of most but not all use cases), but the suggestion from @botanize would also work if...
I support the proposed changes, but I would make `service_date` optional.