Trying to understand the relationship of the ASSET tables?
When viewing the system DB I find multiple ASSET tables and have yet been able to determine the key relationships between ASSET/ASSET_ASSOCIATION/the many ASSET_DATA_X and so on. What are the 'key' fields required or to use when building queries that will tie them together? Should I be concerned with ASSET_HIERARCHY or ASSET_FIELD_DEFINITION????