search

devinit / datahub-cms

A better organised version of https://github.com/devinit/digital-platform to act as a CMS for the Data Hub
0 stars 5 forks source link

Proposal on how to represent 'No data' value in details column in the data revolution tables #16

Closed epicallan closed 7 years ago

epicallan commented 7 years ago

In the data revolution tables we have a column named details that has years represented as integers. For rows where there is no year , a value of no data is used. How about we use -1 or 0 to represent no data so that the detail column is purely of type Integer

dw8547 commented 7 years ago

@epicallan, may it be NULL?

epicallan commented 7 years ago

@dw8547 NULL is fine.

dw8547 commented 7 years ago

@epicallan, this won't work due to entries like:

1) 2010 (planned for 2016) 2) 2014-2015

etc.

Leaving column data type as CHARACTER VARYING in all data_revolution tables.