This PR adds constraints to most columns in both the script to initialize the database and during the import process for new cases. Though I did update scripts/initialize_db.sql, we'll have to manually add the constraints to the deployed database.
Connects #44
Notes
Ideally, court_case.hash should not be null (and be unique) for any row but since there are already some cases without a hash, I held off on adding that constraint for now. But all new cases should have hashes.
Overview
This PR adds constraints to most columns in both the script to initialize the database and during the import process for new cases. Though I did update
scripts/initialize_db.sql, we'll have to manually add the constraints to the deployed database.Connects #44
Notes
Ideally,
court_case.hashshould not be null (and be unique) for any row but since there are already some cases without a hash, I held off on adding that constraint for now. But all new cases should have hashes.