There are three states of approval which does not fit the current column type. They are:
pending - newly submitted/updated facilities
approved - facilities that should be displayed
rejected - facilities that were submitted but decided to be filtered out from displayable locations
Task:
Add new column approval_status with ENUM pending, approved, rejected
Backfill the approval_status="approved" for locations with approved = 1
Backfill the approval_status="pending" for locations with approved = 0
There is only very few facilities now that we don't have to worry about the rejected case, but once we have the moderation process in place, this change will streamline that process.
domcho
commented
4 years ago
There are three states of approval which does not fit the current column type. They are:
Task:
approval_statuswith ENUMpending,approved,rejectedapproval_status="approved"for locations withapproved = 1approval_status="pending"for locations withapproved = 0There is only very few facilities now that we don't have to worry about the
rejectedcase, but once we have the moderation process in place, this change will streamline that process.