When needing to represent True / False or Yes / No which of the following examples is better from a geodatabase design point of view?
Our database architect hates the option on the right but when looking at the data using a non-esri tool using letters makes it easy to understand without needing to do a database join.
Store an integer or Store a string and use the first letter
0 - 'No' or 'N' - 'No'
1 - 'Yes' or 'Y' - 'Yes'
0 - 'False' or 'F' - 'False'
1 - 'True' or 'T' - 'True'
أكثر...
Our database architect hates the option on the right but when looking at the data using a non-esri tool using letters makes it easy to understand without needing to do a database join.
Store an integer or Store a string and use the first letter
0 - 'No' or 'N' - 'No'
1 - 'Yes' or 'Y' - 'Yes'
0 - 'False' or 'F' - 'False'
1 - 'True' or 'T' - 'True'
أكثر...