Databasemodels

Tryton

graph.jpeg

To export this graph:

  1. Connect to database with a tryton client
  2. Navigate to Systemverwaltung / Modelle / Modelle
  3. Select all entries
  4. In the symbol menue click on "Bericht erstellen / Diagramm
  5. Enter the following data and click "Drucken"

Ebene: 1

Filter:

ir\..*
| res\..*
| account\..*
| product\..*
| oauth2\..*
| country\..*
| .*\.configuration
| .*\.start
| .*\.attempt
| .*\.no_result
| .*_mechanism

Archiving

       Logical         .     Physical       .      Integrity
                       .                    .
                       .   --------------   .   ----------------
                       .   | Storehouse |   .   | HarddiskTest |
                       .   -------------    .   -------v--------
                       .         |          .          |
                       .         |          .          |
                       .         |    ------------------
                       .         |    |     .
                       .         |    |     .
  -------------------  .   ------^-------   .   
  |  HarddiskLabel  |-----<|  Harddisk  |---------------
  -------------------  .   --------------   .          |
                       .         |          .          |
                       .         |          .          |
                       .         |          .          |
                       .         |          .          |
                       .         |          .          |
  -------------------  .   ------^-------   .   -------^--------
  | FilesystemLabel |-----<| Filesystem |------<|   Checksum   |
  -------------------  .   -------------    .   -------v--------
          |            .                    .          |
          |            .                    .          |
          |            .                    .          |
          |            .                    .          |
          |            .                    .          |
          |            .    -------------   .          |
          -----------------<|  Content  |---------------
                       .    -------------   .
                       .                    .

ACL

                                       ------------------------
                                       |       WebUser        |
                                       ------------------------
                                                  |
                                                  |
  ------------------------------       ------------------------
  |  Model(AccessControlList)  |------<|  AccessControlEntry  |
  ------------------------------       ------------------------
                                                  |
                                                  |
                                       -----------^------------
                                       |      AccessRole      |
                                       ------------------------
                                                  |
                                                  |
                                       -----------^------------
                                       |   AccessPermission   |
                                       ------------------------

Invoicing

                              -----------------
                              |  COLLECTION   |
                              -----------------
                                     |
                                     ^ 
-----------------             -----------------
|    INVOICE    |-------------|  ALLOCATION   |
-----------------             -----------------
                                     |
                                     ^
-----------------             -----------------
|  DECLARATION  |------------<|  UTILISATION  |---
-----------------             -----------------  |
                              /      |           |
                             /       |           |
-----------------           /  --------------    |     -----------------
|   <CONTEXT>   |-----------   |   TARIFF   |>---------| TARIFF_SYSTEM |················
|  e.g. Event   |              --------------    |     -----------------               :
-----------------                    :           |             :                       :
        |                         formula        |          formula           administration_share
        |      ----------------      :    -----------------    :                       :
        |      |  INDICATORS  |      :    |  INDICATORS   |    :                       : ,···> distribution_amount
        ------<|  <CONTEXT>   |······o···>|  UTILISATION  |····o···> invoice_amount ···o·
               |--------------|           |---------------|                              `···> administration_fee
               | e.g          |           | - base        |
               | - attendants |           | - relevance   |
               | - turnover   |           | - adjustments |
               | - ...        |           | - ...         |
               ----------------           -----------------
                (+ evtl. other
                   indicators)

Distribution

-----------------
|  COLLECTION   |
-----------------
       |
       ^ 
-----------------          ---------------------
|  ALLOCATION   |>---------|   DISTRIBUTION    |
-----------------          ---------------------
       |
       ^ 
-----------------          ---------------------
|  UTILISATION  |----------| DISTRIBUTION_PLAN |
-----------------          ---------------------
       |                            :
       |                         formula
       |                            :            .··> licencer1
       |     distribution_amount ···o···············> licencer2
       |                            :            `··> ...
       |                            :
       |               -----------------------------
       ----------------| UTILISATION_CREATION_LIST |
                       -----------------------------

Echoprint

see https://redmine.c3s.cc/projects/collecting_society/wiki/VM-Echoprint

graph.jpeg - DB Graph (4.49 MB) Alexander Blum, 02/20/2020 07:49 PM