currently, core allows for nullable primary keys which is a divergence from how mobile developers normally think about primary keys. Generally, primary keys are assumed to be implicitly required, SQLite has this requirement, along with just about every other database ever. I am not sure what the reasoning was behind allowing this in Core but we should aim to align with mobile developers expectations 

This artifact has created downstream effects in Sync