added code for bridge table into various files