GitLab database schema gitlab_dotcom diagram

General
1

Hey all,

Do you know where could I find db documentation for gitlab_dotcom schema, including:

  • primary keys and foreign keys;
  • relations between tables (so I see how the tables one table can be joined to);
  • relation types (1 to 1, 1 to many, etc).

Especially the last 2 topics I am missing, the first I’ve found it in structure.sql provided by GitLab.

Thank you,
Dragos

1 Like
2

Want to raise up this question, cuz I’m looking for ERD too.

3

Unfortunately I was unable to find it. They provide a solution, it’s a ruby script that generates a pdf, but unfortunately (due to the very large number of objects) it’s unreadable.

What I did was to search in structure.sql the tables I was interested in and find their foreign and primary key constraints (they are also defined in structure.sql) and draw them manually in draw.io or smth similar, very tedious work.

4

Thank you @RaduDr for the answer! It’s a really pity that GitLab doesn’t provide full ERD or at least most useful tables relationships. Hope they at least thinking of this in the nearest future :slight_smile: