Page MenuHomePhorge

Database tables documentation?
Closed, ResolvedPublic

Asked by Lectrician1 on Feb 13 2023, 15:56.

Details

Is there any way I can see the layout of the database for each Phabricator application and their tables and the columns of each of the tables? I don't want to have to install Phabricator myself just to view the tables.

Answers

valerio.bozzolan
Updated 565 Days Ago

Phorge has 60+ databases with lot of tables. If you know a nice tool to display such complex situation, thank you for sharing.

Since I do not know any tool, I asked a software recommendation:

https://softwarerecs.stackexchange.com/q/86648/78362

avivey
Updated 507 Days Ago

We don't maintain such a document, but you could build the schema by only following the "database" parts of the manual (getting the code and running ./bin/storage upgrade) and dumping the whole schema.
There's a "quickstart.sql" file that is sometimes created in this way - it's currently more-or-less up to date.

Then you can use any tool you have to view this schema...

Dylsss
Updated 595 Days Ago

I used MySQL Workbench to reverse engineer quickstart.sql and create diagrams for each DB, hopefully that's helpful. See my recent uploads for the SVGs.

New Answer

Answer

This question has been marked as closed, but you can still leave a new answer.