converted parent and bounded area Id keys to use char(36)