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