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 capital project category from enum to check constraint #392

Open
6 tasks
TangoYankee opened this issue Nov 13, 2024 · 0 comments
Open
6 tasks

Refactor capital project category from enum to check constraint #392

TangoYankee opened this issue Nov 13, 2024 · 0 comments

Comments

@TangoYankee
Copy link
Member

Description

The capital project category enum has an extra wrinkle- there is typo. The ITT, Vehicles and Equipment option should have an oxford comma. This ticket will also resolve this typo. The migration will require dropping the columns that hold that data before re-adding it with the updated option. There will be two migrations as part of this ticket

Acceptance criteria

  • The capitalProjectCategoryEnum is removed
  • The category field is removed from the capitalProject table
  • A migration is generated that drops the enum and the column
  • The category field is returned but now with a text type
  • A check constraint is added to the category field, placing a comma after "Vehicles"
  • A second migration is generated

Related

Depends on: #386

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