schema: remove redundant and unneeded data