Entity relationship diagrams
****************************

The bframe `entity relationship diagram <https://en.wikipedia.org/wiki/Entity-relationship_model>`_ (ERD) spans all tables and views that are accessible through the library. Given the sheer size of the diagram it is formatted as an SVG to allow for zooming and paning in high definition.

Entities are connected based on the `pseudo foreign keys </business_modeling/metadata/foreign_keys.html#why-not-use-foreign-keys>`_ within the presented columns. ``branch``, ``environment`` and ``organization`` entities and relationships are excluded to reduce clutter in diagrams. Although their ERDs can be found at the individual level.

.. figure:: /_static/images/erd/all_erd.svg
    :width: 1000px

.. toctree::
    :hidden:    

    customers
    products
    pricebooks
    list_prices
    contracts
    contract_prices
    events
    prices
    price_spans
    processed_events
    matched_events
    rated_events
    line_items
    invoices
    organizations
    environments
    branches