search

secretGeek / csvz

The hot new standard in open databases
Creative Commons Zero v1.0 Universal
30 stars 2 forks source link

csvz-meta-relations composite keys #13

Closed MarkPflug closed 4 years ago

MarkPflug commented 4 years ago

Sometimes (not often) keys are defined as a combination of two columns. In the columns.csv data it would be possible to identify two columns as being "primary-key". Should this mean that the combination of those two columns constitutes a primary key?

Likewise, how would a foreign key relationship in the relations.csv data targeting that primary key be represented?

MarkPflug commented 4 years ago

Derp. If I read the spec... I would have seen that this is covered.