To add on, While exploring the repository, I noticed that the MTA_FIELD table (filtered with CLASSNAME = 'TableColumn') lists attributes along with their data types. However, I am unsure if this is the only way to retrieve an attribute’s data type because I do not see any direct relationship or common key between MTA_FIELD and MTA_ATTRIBUTE.
Could you please confirm:
Is MTA_FIELD the correct and only source for attribute data types? If so, what is the recommended approach to link MTA_FIELD with MTA_ATTRIBUTE for building a consolidated query?
Mounkarthick
Hello Team,
I’m currently building a dashboard that lists all entities along with their respective attributes. While preparing the query to retrieve this data, I was unable to locate the repository table that stores the data type information for attributes.
I need your assistance in identifying which Semarchy xDM repository table contains attribute data type details. Specifically:
1. Which repository table contains the data type details for attributes?
2. How can this table be linked to the MTA_ATTRIBUTE table, or what is the correct join key or relationship between these tables?
Please share:
The table name(s) that hold attribute data type metadata. The column(s) to use for joining with MTA_ATTRIBUTE. Any relevant documentation or ER diagram references.
Thank you for your assistance.