Do we need unique ids for columns?

nheeren / material_intensity_db

Material intensity database for research on infrastructure systems

20 stars 10 forks source link

Do we need unique ids for columns? #2

Closed nheeren closed 6 years ago

nheeren commented 6 years ago

In databases it is good practice to use a serial id column. Ideally this one is unique to a data entry. However, this database may change over time and values may be deleted. Also, it is just another overhead that data contributers need to carry out.

Any opinions? I think I will implement a serial id sid column for now in the codebook.

nheeren commented 6 years ago

Decided yes, because it may help to compare datasets between commits in the future. A voir.