Most E-commerce applications use a similar design with 4 basic tables. There may be other ancillary tables ... or capitalize on merged words (e.g. first_name or FirstName). Sample Database Diagram - ...

Along with the name property, the JPA @Column annotation can further customize the way a field maps to the database, through the use of the following properties: Notice the JPA column mapping example ...