I have an app that has an address field on the customer and the users. The address information on the users is informational and it is not used anyplace. The address used by the customer has only one purpose. It is one of the ways for the application administrator to determine that when they get a new customer that the customer doesn’t already exist in the application. My question is:
Should the address be stored as one long field or its component fields? I’m not even sure if the app is going to validate the address beyond not allowing nulls. That’s how little importance the address is.
Thanks