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????
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
Roonerspism
12 years ago
It depends on the sorts of queries that you're trying to write. I have not bothered with heirarchy at all, you wouldnt unless you were using nested assets. Field definition however can help you find out what sorts of fields are where and allow you to search by text name of the field as opposed to the field type/id. Its a little messy but once you get your head around it reading it is okay.
Looking at the asset_field_definition table and its contents will help you figure out which tables relate to eachother etc.
Looking at the asset_field_definition table and its contents will help you figure out which tables relate to eachother etc.
Comments:
-
If you like throw me an email for some extra info. - Roonerspism 12 years ago
-
Thank you - jmarotto 12 years ago
