change url pattern to map eid in.
log any errors explicitly
fix name of column
add unique constraint index
fix path so it's unique