Databasemodels » History » Version 2

Alexander Blum, 02/07/2020 05:50 PM

1 2 Alexander Blum
{{toc}}
2 2 Alexander Blum
3 1 Alexander Blum
# Databasemodels
4 1 Alexander Blum
5 1 Alexander Blum
## Tryton
6 1 Alexander Blum
7 1 Alexander Blum
{{thumbnail(repertoire.png, size=600, title=Databasemodel)}}
8 1 Alexander Blum
9 1 Alexander Blum
To **export** this graph:
10 1 Alexander Blum
11 1 Alexander Blum
1. Connect to database with a tryton client
12 1 Alexander Blum
2. Navigate to ``Systemverwaltung / Modelle / Modelle``
13 1 Alexander Blum
3. Select all entries
14 1 Alexander Blum
4. In the symbol menue click on "Bericht erstellen / Diagramm
15 1 Alexander Blum
5. Enter the following data and click "Drucken"
16 1 Alexander Blum
17 1 Alexander Blum
**Ebene:** 1
18 1 Alexander Blum
19 1 Alexander Blum
**Filter:**
20 1 Alexander Blum
21 1 Alexander Blum
~~~
22 1 Alexander Blum
ir\..*
23 1 Alexander Blum
| res\..*
24 1 Alexander Blum
| account\..*
25 1 Alexander Blum
| product\..*
26 1 Alexander Blum
| oauth2\..*
27 1 Alexander Blum
| country\..*
28 1 Alexander Blum
| .*\.configuration
29 1 Alexander Blum
| .*\.start
30 1 Alexander Blum
| .*\.attempt
31 1 Alexander Blum
| .*\.no_result
32 1 Alexander Blum
| .*_mechanism
33 1 Alexander Blum
~~~
34 1 Alexander Blum
35 1 Alexander Blum
## Archiving
36 1 Alexander Blum
37 1 Alexander Blum
           Logical         .     Physical       .      Integrity
38 1 Alexander Blum
                           .                    .
39 1 Alexander Blum
                           .   --------------   .   ----------------
40 1 Alexander Blum
                           .   | Storehouse |   .   | HarddiskTest |
41 1 Alexander Blum
                           .   -------------    .   -------v--------
42 1 Alexander Blum
                           .         |          .          |
43 1 Alexander Blum
                           .         |          .          |
44 1 Alexander Blum
                           .         |    ------------------
45 1 Alexander Blum
                           .         |    |     .
46 1 Alexander Blum
                           .         |    |     .
47 1 Alexander Blum
      -------------------  .   ------^-------   .   
48 1 Alexander Blum
      |  HarddiskLabel  |-----<|  Harddisk  |---------------
49 1 Alexander Blum
      -------------------  .   --------------   .          |
50 1 Alexander Blum
                           .         |          .          |
51 1 Alexander Blum
                           .         |          .          |
52 1 Alexander Blum
                           .         |          .          |
53 1 Alexander Blum
                           .         |          .          |
54 1 Alexander Blum
                           .         |          .          |
55 1 Alexander Blum
      -------------------  .   ------^-------   .   -------^--------
56 1 Alexander Blum
      | FilesystemLabel |-----<| Filesystem |------<|   Checksum   |
57 1 Alexander Blum
      -------------------  .   -------------    .   -------v--------
58 1 Alexander Blum
              |            .                    .          |
59 1 Alexander Blum
              |            .                    .          |
60 1 Alexander Blum
              |            .                    .          |
61 1 Alexander Blum
              |            .                    .          |
62 1 Alexander Blum
              |            .                    .          |
63 1 Alexander Blum
              |            .    -------------   .          |
64 1 Alexander Blum
              -----------------<|  Content  |---------------
65 1 Alexander Blum
                           .    -------------   .
66 1 Alexander Blum
                           .                    .
67 1 Alexander Blum
68 1 Alexander Blum
## ACL
69 1 Alexander Blum
70 1 Alexander Blum
                                           ------------------------
71 1 Alexander Blum
                                           |       WebUser        |
72 1 Alexander Blum
                                           ------------------------
73 1 Alexander Blum
                                                      |
74 1 Alexander Blum
                                                      |
75 1 Alexander Blum
      ------------------------------       ------------------------
76 1 Alexander Blum
      |  Model(AccessControlList)  |------<|  AccessControlEntry  |
77 1 Alexander Blum
      ------------------------------       ------------------------
78 1 Alexander Blum
                                                      |
79 1 Alexander Blum
                                                      |
80 1 Alexander Blum
                                           -----------^------------
81 1 Alexander Blum
                                           |      AccessRole      |
82 1 Alexander Blum
                                           ------------------------
83 1 Alexander Blum
                                                      |
84 1 Alexander Blum
                                                      |
85 1 Alexander Blum
                                           -----------^------------
86 1 Alexander Blum
                                           |   AccessPermission   |
87 1 Alexander Blum
                                           ------------------------
88 2 Alexander Blum
89 2 Alexander Blum
## Invoicing
90 2 Alexander Blum
91 2 Alexander Blum
    -----------------             -----------------
92 2 Alexander Blum
    |    INVOICE    |-------------|  ALLOCATION   |
93 2 Alexander Blum
    -----------------             -----------------
94 2 Alexander Blum
                                         |
95 2 Alexander Blum
                                         ^
96 2 Alexander Blum
    -----------------             -----------------
97 2 Alexander Blum
    |  DECLARATION  |------------<|  UTILISATION  |---
98 2 Alexander Blum
    -----------------             -----------------  |
99 2 Alexander Blum
                                  /      |           |
100 2 Alexander Blum
                                 /       |           |
101 2 Alexander Blum
    -----------------           /  --------------    |     -----------------
102 2 Alexander Blum
    |   <CONTEXT>   |-----------   |   TARIFF   |>---------| TARIFF_SYSTEM |················
103 2 Alexander Blum
    |  e.g. Event   |              --------------    |     -----------------               :
104 2 Alexander Blum
    -----------------                    :           |             :                       :
105 2 Alexander Blum
            |                         formula        |          formula           administration_share
106 2 Alexander Blum
            |      ----------------      :    -----------------    :                       :
107 2 Alexander Blum
            |      |  INDICATORS  |      :    |  INDICATORS   |    :                       : ,···> distribution_amount
108 2 Alexander Blum
            ------<|  <CONTEXT>   |······o···>|  UTILISATION  |····o···> invoice_amount ···o·
109 2 Alexander Blum
                   |--------------|           |---------------|                              `···> administration_fee
110 2 Alexander Blum
                   | e.g          |           | - base        |
111 2 Alexander Blum
                   | - attendants |           | - relevance   |
112 2 Alexander Blum
                   | - turnover   |           | - adjustments |
113 2 Alexander Blum
                   | - ...        |           | - ...         |
114 2 Alexander Blum
                   ----------------           -----------------
115 2 Alexander Blum
                    (+ evtl. other
116 2 Alexander Blum
                       indicators)
117 2 Alexander Blum
118 2 Alexander Blum
## Distribution
119 2 Alexander Blum
120 2 Alexander Blum
    -----------------
121 2 Alexander Blum
    | DISTRIBUTION  |
122 2 Alexander Blum
    -----------------
123 2 Alexander Blum
           |
124 2 Alexander Blum
           ^
125 2 Alexander Blum
    -----------------
126 2 Alexander Blum
    |  ALLOCATION   |
127 2 Alexander Blum
    -----------------
128 2 Alexander Blum
           |
129 2 Alexander Blum
           ^ 
130 2 Alexander Blum
    -----------------          ---------------------
131 2 Alexander Blum
    |  UTILISATION  |----------| DISTRIBUTION_PLAN |
132 2 Alexander Blum
    -----------------          ---------------------
133 2 Alexander Blum
           |                            :
134 2 Alexander Blum
           |                         formular
135 2 Alexander Blum
           |                            :            .··> licencer1
136 2 Alexander Blum
           |     distribution_amount ···o···············> licencer2
137 2 Alexander Blum
           |                            :            `··> ...
138 2 Alexander Blum
           |                            :
139 2 Alexander Blum
           |               -----------------------------
140 2 Alexander Blum
           ----------------| UTILISATION_CREATION_LIST |
141 2 Alexander Blum
                           -----------------------------
142 2 Alexander Blum
143 1 Alexander Blum
144 1 Alexander Blum
## Echoprint
145 1 Alexander Blum
146 1 Alexander Blum
see https://redmine.c3s.cc/projects/repertoire/wiki/VM-Echoprint