replave bigint with int where possible; define referential actions on foreign keys in npg tables to allow for deletion of flowcell rows