You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Is your feature request related to a problem? Please describe.
Each incident may have additional objects that are related to it. For example, an incident may involve a number of officers or a legal case. Since we will be compiling data from multiple sources, it is likely that these sources will make references to the same entities. For example, a report from fatal encounters and a data entry from CPDP may refer to the same officer. We need some way to relate those entities in our database.
Describe the solution you'd like
I propose that we include two tables for each object that can be related to multiple incidents. The first will contain objects that are directly related to an incident. The second table will contain master profiles for objects and will relate to objects in the first table. For example, the second table might indicate that a number of officers in the first table are actually the same officer.
Is your feature request related to a problem? Please describe.
Each incident may have additional objects that are related to it. For example, an incident may involve a number of officers or a legal case. Since we will be compiling data from multiple sources, it is likely that these sources will make references to the same entities. For example, a report from fatal encounters and a data entry from CPDP may refer to the same officer. We need some way to relate those entities in our database.
Describe the solution you'd like
I propose that we include two tables for each object that can be related to multiple incidents. The first will contain objects that are directly related to an incident. The second table will contain master profiles for objects and will relate to objects in the first table. For example, the second table might indicate that a number of officers in the first table are actually the same officer.
Additional context
National Police Data Coalition - Linking Like Objects.pdf
The text was updated successfully, but these errors were encountered: