search

frictionlessdata / datapackage

Data Package is a standard consisting of a set of simple yet extensible specifications to describe datasets, data files and tabular data. It is a data definition language (DDL) and data API that facilitates findability, accessibility, interoperability, and reusability (FAIR) of data.
https://datapackage.org
The Unlicense
481 stars 107 forks source link

Deprecate `primaryKey` in favour of `primaryKeys` #932

Open peterdesmet opened 1 month ago

peterdesmet commented 1 month ago

For consistency, I think we should deprecate primaryKey in favour of primaryKeys:

Screenshot 2024-05-15 at 17 06 00

I notice myself typing primaryKeys (plural), forgetting that is not a property of Table Schema.

khusmann commented 1 week ago

Hmmm isn't it more correct in the singular? Although the primary key for a table may be determined by multiple fields, there is only one primary key definition per table. Whereas many foreign key and unique key definitions can exist simultaneously in a given table, so the plural there makes sense.

I'm less familiar with DB design so maybe I'm missing something?