There are also some limitations if using something like rails / activerecord which doesn't support composite primary keys natively