On Mar 19, 2011, at 11:33 PM, David E Jones wrote:
>
> I'm writing this to start a thread to discuss:
>
> If you could change ANYTHING in the OFBiz data model, what would it be?
>
> To kick this off here are some ideas I've compiled that have come up over the
> years (many based on feedback from people on this mailing list), or that I
> thought of recently will working on this topic. You can see them below...
>
> -David
>
> ========================================================
>
>
> - Move most *Type entities to Enumeration values (update seed data, referring
> entities, remove *Type) (after this remove all remaining hasTable fields)
Related to this:
- Add the enumTypeId to the entity definition for the field
<field name="locationTypeEnumId" enum-type="FACLOC_TYPE" ...
Also,
- Make userLoginId an ID that isn't changed, add a field for "name" that can be
updated
- Condense credit card name fields (first, middle, last, prefix, suffix, etc.)
into a single "nameOnCard"