Add foreign key for location table

location.parentid => location.id