Author Topic: Documentations of database schema (EA repository)  (Read 603 times)

Martin Trneny

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Documentations of database schema (EA repository)
« 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

qwerty

  • EA Guru
  • *****
  • Posts: 8952
  • Karma: +136/-123
  • I'm no guru at all
    • View Profile
Re:  Documentations of database schema (EA reposit
« Reply #1 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.

Martin Trneny

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re:  Documentations of database schema (EA reposit
« Reply #2 on: December 22, 2012, 12:57:25 am »
Thanks for your answer.

Martin