collecting_society

{{toc}}

# Databasemodels

## Tryton

{thumbnail(repertoire.png, {{thumbnail(repertoire.png, size=600, title=Databasemodel)} title=Databasemodel)}}

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

----------------- -----------------
| 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

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

## Echoprint

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