change foreign key to bts_alias; update import flows