Sparx Systems Forum

Discussion => General Board => Topic started by: Martin Trneny on December 21, 2012, 10:45:30 pm

Title: Documentations of database schema (EA repository)
Post by: Martin Trneny on December 21, 2012, 10:45:30 pm

Hi,
I was searching for some documentation to EA database schema (t_object, t_diagrams, etc.) but it seems there is no such thing.

Why Sparx didn't publish any? It could be very useful to have such document.

Because of that I have to by trial and error search for result of each my problem regarding DB queries.
 
Now I want to find a way how is an element "Hyperlink" stored in tables (to make an query base on which a hyperlink element gives me related (linked) element)? I know the hyperlink element itself is stored in t_object table but how I find the associated element (if a column Name doesn't contain $diagram://{GUID})?

Sorry for my English :)

Kind regards,
Martin

Title: Re:  Documentations of database schema (EA reposit
Post by: qwerty on December 22, 2012, 12:29:30 am

The only thing is my book Inside EA (see below). To answer your question: PDATA1 contains the DiagramID of the according diagram.

q.

Title: Re:  Documentations of database schema (EA reposit
Post by: Martin Trneny on December 22, 2012, 12:57:25 am

Thanks for your answer.

Martin