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 favorites table #18

Open
dwaring87 opened this issue Dec 14, 2020 · 0 comments
Open

Refactor favorites table #18

dwaring87 opened this issue Dec 14, 2020 · 0 comments
Labels
db Changes to the MySQL Database enhancement New feature or request

Comments

@dwaring87
Copy link
Member

Refactor the favorites table to use MySQL's native JSON format

Store the favorites as 1 row per user / agency.

id, user_id, agency, favorites

where favorite is a JSON array of favorite objects:

{
  type: ...,
  sequence: ...,
  ...parameters...
  options: {
     ...
  }
}
@dwaring87 dwaring87 added enhancement New feature or request db Changes to the MySQL Database labels Dec 14, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
db Changes to the MySQL Database enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant