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

Use tables for repeated bill information #89

Open
JustZack opened this issue Jun 8, 2024 · 0 comments
Open

Use tables for repeated bill information #89

JustZack opened this issue Jun 8, 2024 · 0 comments

Comments

@JustZack
Copy link
Owner

JustZack commented Jun 8, 2024

I.E. create a subjects table which has an id and text so that billsubjects simply has an id for the subject is references.

This essentially exists for the congresses table already, because the congress column implictly maps to congress text.

Apply this logic anywhere that it would be beneficial.
Possibly in:

  • Related Bills, the reason & identifier column
  • Bill Actions, the actionType column
  • Text Versions, the versionType column
  • Bill Committees, the action column
  • Maybe for committees aswell, instead of using thomasId as a key
  • ALL Bill tables, the type column (in related bills, relatedType too) - This one might be rather involved to fix

Goal is to:

  1. Avoid data duplication
  2. Have tables the frontend can easily use to present data filtering options
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant