Location Comments is of the wrong datatype within the database

[colinkelleher]

Within each location, it is possible to add a comment about the location, however, location is of the wrong datatype within the database.

Context

As there are many different locations, you have the ability to add a comment about each location. For example, how to get to the location etc... Currently within the location database, the comments field is of datatype integer, which will, therefore, cause errors when adding to the database and querying the database

Process

[ordered list the process to finding and recreating the issue, example below]

1. User goes to delete a dataset (to save space or whatever)
2. User gets popup modal warning
3. User deletes and it's lost forever

Expected result

The database can accept comments in text format

Current result

The database will only accept integers as comments in the comments field

Possible Fix

• Update the comments datatype to text within the database

Screenshots

Current Database

Solution