PNG of database relationships is out of date

[McEileen]

The database schema is out of date, for example, the department model doesn't include the field unique_internal_identifier_label.

[redshiftzero]

In staging, prod or in develop? It's on develop (and thus should be on staging since the deployment is automated): https://github.com/lucyparsons/OpenOversight/blob/cd4dbb75d910d761907718ce7ea4885808392055/OpenOversight/app/models.py#L35

This migration won't be on master (and thus production) yet since we haven't done a merge to master in a while.

[McEileen]

I thought the schema represented the relationships established in the develop branch. I think what you're saying is that it actually represents the relationships in master, which means I was mistaken in saying that the schema was out of date.

[redshiftzero]

After offline discussion, the problem @McEileen is raising here is that https://github.com/lucyparsons/OpenOversight/blob/develop/database/relationships.real.large.png is out of date

[michplunkett]

This is definitely noted, @McEileen! It will be addressed after we make some general modifications to the DB, specifically these four tickets:

• https://github.com/lucyparsons/OpenOversight/issues/930
• https://github.com/lucyparsons/OpenOversight/issues/427
• https://github.com/lucyparsons/OpenOversight/issues/928
• https://github.com/lucyparsons/OpenOversight/issues/323

Ideally, this issue should be addressed in the next two weeks. So you're in the know!

[michplunkett]

Once this PR is figured out, I'll update the PNG:

• https://github.com/lucyparsons/OpenOversight/pull/992
• https://github.com/lucyparsons/OpenOversight/issues/1008