view for techschema