flattened user schema