leomedina / considered_collectively Goto Github PK

Allow for users to discuss the bill

Indexing all table columns in the server will greatly improve speed - may require additional space... TBD.

More info: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview?view=sql-server-ver15

Overview: Implement the ability to follow a representative, such as House member or Senator.

Technical Details: Currently the server includes several tables such as "representatives" and "representative-users" that give you many-to-many database capabilities to follow representatives.

Currently, any 404 errors will not be routed to a custom 404 page.

find a way to save the user's follow in a separate state, that would prevent any catastrophic failures if the user saves a bill when the database is not accessible.

Give the user ability to follow legislation publicly. This is designed to make the application more social (think Venmo's public tab)

Have the ability to create super users and users that are "verified" representative. This will allow representatives to answer any questions set forth by users in the comment sections of the bills.