New Schema Attributes
|
View:
New views
2 Messages
—
Rating Filter:
Alert me
|
 |
New Schema Attributes
by Adam Tauno Williams
::
Rate this Message:
Recently we added new attributed to the DB schema and model -
To Contact: birthplace - This is intended to be just a free form string? family_status - This is a free form string or some enumeration>? citizenship - There was a comment about this being a CSV field? Is it a CSV of free-form country names or some enumeration? For country field in address we use ISO 3166-1 alpha3 codes. Could we perhaps 'standardize' on using that standard for representing countries? I could easily provide a table that contains all the country codes if that would be useful. To Address: district - This is a free form string or is some more specific meaning intended? -- OpenGroupware.org Developer developer@... http://mail.opengroupware.org/mailman/listinfo/developer |
|
|
Re: New Schema Attributes
by Helge Hess
::
Rate this Message:
On 14.09.2009, at 14:51, Adam Tauno Williams wrote:
> Recently we added new attributed to the DB schema and model - > > To Contact: > birthplace - This is intended to be just a free form string? Yes. Eg 'Berlin' or 'New York'. > family_status - This is a free form string or some enumeration>? Good question. In the application where I use it, its a popup. ('verheiratet' / 'nicht verheiratet'). I suppose it should be a proper enum. > citizenship - There was a comment about this being a CSV field? No. 'keywords' aka 'categories' is a CSV field. I currently use citizenship as a free form field. But it probably makes sense to use some code. (I'm not 100% sure whether thats possible. Is there always a 1:1 mapping between citizenship and country? Hm Hm. Probably) > Is it a CSV of free-form country names or some enumeration? For > country field > in address we use ISO 3166-1 alpha3 codes. Could we perhaps > 'standardize' on using that standard for representing countries? Makes sense, yes. > I could easily provide a table that contains all the country codes > if that > would be useful. I guess that would be nice. > To Address: > district - This is a free form string or is some more specific > meaning > intended? Free form. Sometimes cities in Germany are split and have a 'part' (not in the sense of suburbs, but more as a second village which belongs to a larger one but has a different location). We store that in the district field. Greets, Helge -- Helge Hess http://helgehess.eu/ -- OpenGroupware.org Developer developer@... http://mail.opengroupware.org/mailman/listinfo/developer |
| Free embeddable forum powered by Nabble | Forum Help |
