Changes to infrastructure.cells table #6184
Labels
enhancement
New feature or request
FlowDB
Issues related to FlowDB
FlowMachine
Issues related to FlowMachine
refactoring
A few suggested additional columns for the
infrastructure.cells
table:date_added
(might need a better name): date that the cell was added to the cells table (not necessarily the same as the date that the cell was added to the network)date_modified
: Sometimes incorrect cell info may get corrected - it would be useful to be able to keep track of when this happens. Not sure whether we'd want to track changes to location separately from other changes.additional_metadata
: json field to capture additional information (cell info files from MNOs often include additional fields that don't fit into the existing columns in the cells table, which would be useful to have available in FlowDB)to_exclude
(or equivalentlyto_include
): boolean field to record whether CDR events at this cell should be included in mobility analysis. We'd want to change flowmachine'sJoinToLocation
accordingly, to exclude these cells from the join. This would be useful when we suspect a cell location is incorrect, for example. It would be good to be able keep track of these excluded cells in the cells table (especially when updating the cell info), rather than needing to record them elsewhere.Alternatively, instead of a
date_modified
column we could treat the cells table as append-only, and modify a cell record by adding a new row with incrementedversion
and marking the old record asto_exclude
. This would have the advantage of keeping a record of the history. We'd perhaps still want adate_excluded
column, which would make it possible to reconstruct the contents of the cells table as it was on a previous date.It would also be good to have an
EXCLUDE
constraint to ensure no two (non-excluded) rows with the same ID have overlappingdate_of_first_service
-date_of_last_service
ranges. This would be facilitated by replacing thedate_of_first_service
anddate_of_last_service
fields with a single date range (or timestamp range) field.The text was updated successfully, but these errors were encountered: