search

openspending / openspending-migrate

0 stars 1 forks source link

Modify primary key for date dimensions #6

Closed akariv closed 8 years ago

akariv commented 8 years ago

Hey @danfowler , I think that for date fields we'd want the primary keys to consist of the actual values for (year,month,day), as it would make it easier to use on queries (e.g. cut on year=X).

wdyt?

danfowler commented 8 years ago

Yes, that makes sense. I'll change the script as well.