Skip to content

Latest commit

 

History

History
19 lines (14 loc) · 1.19 KB

README.md

File metadata and controls

19 lines (14 loc) · 1.19 KB
Raw

BOSH Director Database Schema

Here is an ER diagram of the schema that the BOSH director uses for storing its state. The schema is accessed through a Ruby ORM called Sequel. The Ruby classes that this schema maps to are located in the director's Models module.

ER diagram of BOSH director schema

Warning: This diagram can become stale quickly; generate when necessary

The above PNG file was generated using RubyMine Database Plugin. There's also a searchable SVG version. Steps to generate:

  • Use RubyMine Database plugin (View » Tool Windows » Database) to connect to a BOSH database. Quick trick would be to connect to a database created by an integration test.
    • If you don't see the desired database, right click on the localhost postgres connection in the database pane -> Database Tools -> Manage Shown Schemas and select either All Schemas or Current Schema for the database you're interested in.
  • Right click database connection: Diagrams --> Show Visualizations . Make sure UML Support plugin is enabled.
  • Export the diagram.