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

refactor: replace dh10application with a dynamic form builder schema #190

Open
fvcci opened this issue Sep 24, 2024 · 2 comments
Open

refactor: replace dh10application with a dynamic form builder schema #190

fvcci opened this issue Sep 24, 2024 · 2 comments

Comments

@fvcci
Copy link
Contributor

fvcci commented Sep 24, 2024

There are several issues with the current database:

  1. The dh10application table is not the application table for change ironically. What happens if a new form field is added? Or an old form field removed? There is no way to make the change without modifying the architecture of the database.
  2. Form UI is hard coded. Some assumptions were made: the form's fields and its restrictions.

The proposed schema is as follows:
image

Some tasks to accomplish:

  • implement the new schema
  • refactor dh10application table queries to use the new schema
    • queries include submit, update, and application data retrieval

future roadmap:

  1. reroute dh10application table to auto fill the current database OR migrate dh10application data to new schema
  2. Remove codebase assumptions on the question's restrictions/conditions. database will indicate the restrictions on questions.
  3. Remove codebase assumptions on the form's questions. All displayable question info will be provided by the database.
  4. Cleanup legacy dh10application table
@fvcci fvcci linked a pull request Oct 1, 2024 that will close this issue
@fvcci
Copy link
Contributor Author

fvcci commented Oct 1, 2024

Updating the schema. Removed the answers relation between Answer and FormSubmission tables and created a new relation between Answer and Users:
image

@fvcci
Copy link
Contributor Author

fvcci commented Oct 6, 2024

Updating the schema. We want to have unique questions and answers for every form
image

AnswerType will be punted to a later issue.

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

Successfully merging a pull request may close this issue.

1 participant