Page MenuHomePhorge

Database tables documentation?
OpenPublic

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 33 Days Ago

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

avivey
Updated 31 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 26 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