I need to create a database schema for storing user information (id, name, p/w, email address ...etc). I have always picked arbitrary amounts when sizing these fields. With this said, I have two questions:1) What are good sizes for these fields? I am sure there is a maximum email address length for example...etc. 2) I now need to store user mailing addresses for credit card purchases, including international mailing addresses. This is an area I do not want to pick arbitrary sizes. Does anyone know of a good schema for either? Is there a project for this maybe?Thanks!
User schema for website
- Thread starter necrom
- Start date