Made all id's use GenerationType.IDENTITY; Replaced wildcard imports with specifics.
Formally named unique and foreign keys.
Fixed typo in query