We would like to have a published data structure diagram with relationships - similar to what was available with version v8i.

This would provide an easier way to look up component codes to exclude from a query. For example, we might want an equipment list that includes all equipment except gates (which include sluice gates, slide gates, and stop log gates). It can be done by joining META.ECCLASSDEF. However, it is not real straightforward and usually involves some trial and error to figure it out.