resolved database strucure