Transferred cases pose a problem for our current database schema. When a case is transferred from one division to another, the new case retains the old case's number. Currently, our database uses case numbers as the primary key.

We'll switch to a composite key that combines case number with the court column.

SQLite Docs