Insight tables within Jira SQL

Sanja Vukovic

I created object schema in Insight and now would like to acess tables that are created in SQL. I have read acess to whole Jira DB, but after careful observation, I can't find them. How can I find my tables that are created when I created my object schema and started importing objects? In which schema and what is naming convention?

Thank you

Alexander Sundström_x0imga

Hi Sanja,

All tables in Insight are prefixed with AO_8542F1_IFJ, we are using more than one to store the values for the objects, but perhaps what would be most interesting is

• AO_8542F1_IFJ_OBJ_SCHEMA
• AO_8542F1_IFJ_OBJ
• AO_8542F1_IFJ_OBJ_ATTR_VAL

Best Regards
Alexander