I have a jdbc:maria db setup and running, I have a nice flow of data getting in there. But there’s a little confusion to me how to set the relation in individual item and items table. I hav tested rebuild and to have tableUseRealItemNames=true, but rebuild fails and my real Item name isn’t really what I will show as visible name i database, I would much more preferd to have Item description added also Instead of as I do add a itemsecription column to table items. I will just visualize this data in power bi.
Or is the best way to create a routine for setting visible name on update of itemxxx table or just simply adding item number in a column in itemxxxx table. Lets say in Item0003 table add a column that’s called itemid and that column always updates on any updates?