[Libreoffice-bugs] [Bug 98150] Allow saving a relationship model as a separate file

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=98150

--- Comment #3 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(In reply to Gisbert from comment #2)
> Dear Maintainer, I wonder if anybody knows WHERE and in which FORMAT the
> Relationship Diagram is stored. 
> After renaming my .odb-file to .zip and extracting it, I cound not find
> anything like the definition of a diagram...

In the case of an embedded HSQL base file there are two places that hold
information. First the description of the relationships can be found in the
file (inside the odb) database/script the information is the foreign key
declarations. That is the set of DDL commands to recreate the user schema.

To find the associated real indexs created from that statement in the system
generated index names are found, along with all the other information, in the
system schema tables in the binary data file. (also in the backup file, so
three places I suppose ;)

Anyway, just grabbing the database/script file for these type odb files and
there are schema tools where importing (with a little edit here and there)
works successfully.

There may be a setting in content.xml also, IIRC there is, but that is only to
override the default behavior and to show tables without an FKs in the display.
(So you used the add table dialog but then didn't actually use it yet). In the
more powerful external tools the default (that I'm use to) would be to show you
all the tables in the schema anyway. 

Honestly though I'm surprised no one has published an extension which doesn't
either let you grab that as an image or maybe create a draw file with layout
similar to the relationship window. 

Also, there is a tool coming out from a community member 'any time now' ;)
soon, I think, that might do some of (and more) of what you want. So keep eye
out for something called, 'Database Documenter' I think that is the name.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180814/b201835e/attachment.html>