Handle non nullable columns

[adsharma]

My coding agent says:

• SQLite is more flexible with schema. Allows nullable primary key columns
• Allows nullable columns in other places where it shouldn't be

Post migration:

• review the null values and tighten schema constraints