Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[FEATURE] Tables for Linking Like Objects #32

Closed
DMalone87 opened this issue Apr 28, 2021 · 0 comments
Closed

[FEATURE] Tables for Linking Like Objects #32

DMalone87 opened this issue Apr 28, 2021 · 0 comments

Comments

@DMalone87
Copy link
Collaborator

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

1 participant