The annotations must be created with autoincrement column.
We manually create all the foreign-key related indices and name them consistently.