enum "Continent": allow NULL or provide alternative value

13762
Reporter: ahahn
Assignee: trobertson
Type: Task
Summary: enum "Continent": allow NULL or provide alternative value
Priority: Blocker
Resolution: Fixed
Status: Closed
Created: 2013-09-02 16:15:58.394
Updated: 2013-12-16 17:50:25.552
Resolved: 2013-09-11 19:04:37.768
        
Description: In table "node, the attribute continent is not nullable. However, just as there are nodes that are not associated with a country, there are also some that cannot be meaningfully associated with a continent (e.g. WFCC or TDWG).

This may need a more general decision: when such a case is discovered, should a) the attribute be changed to nullable, or b) an escape value be provided (here: "N/A", "NOT APPLICABLE" or similar, in other cases "UNKNOWN")?]]>
    

Author: ahahn@gbif.org
Comment: Decision: make nullable, to stay consistent with node.country
Created: 2013-09-03 10:57:13.536
Updated: 2013-09-03 10:57:13.536

Author: mdoering@gbif.org
Comment: added null to migration scripts: https://code.google.com/p/gbif-labs/source/detail?r=540
Created: 2013-09-03 11:08:51.606
Updated: 2013-09-03 11:08:51.606

Author: trobertson@gbif.org
Comment: It is nullable I see
Created: 2013-09-11 19:04:37.799
Updated: 2013-09-11 19:04:37.799