kurs:relationen
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
kurs:relationen [2022/03/07 13:01] admin created |
kurs:relationen [2022/03/07 13:22] (current) admin |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| * Name | * Name | ||
| * Geburtsdatum | * Geburtsdatum | ||
| + | (* Familienstand (pseudo enum) (V, W, L, ...) => Normalisiert) | ||
| + | * familienstand_id | ||
| + | (* Status (K G L)) | ||
| 1 (Person) : n (email) | 1 (Person) : n (email) | ||
| Line 15: | Line 18: | ||
| * person_id | * person_id | ||
| - | |||
| - | Person | ||
| - | * id name | ||
| - | * 1 Eva | ||
| - | * 2 Max | ||
| + | 1 (Familienstand) : n (Person) | ||
| + | |||
| + | * Familienstand | ||
| + | * id | ||
| + | * name | ||
| + | |||
| + | * Projekt | ||
| + | * id | ||
| + | * name | ||
| + | |||
| + | * Projekt_X_Person (Projekt_Person_Int) | ||
| + | * (id) | ||
| + | * person_id | ||
| + | * projekt_id | ||
| + | |||
| + | 1 Person kann an mehreren Projekten mitarbeiten (1:n) | ||
| + | 1 Projekt kann mehrere MitarbeiterInnen haben (1:n) | ||
| + | |||
| + | many to many (m : n) | ||
| + | |||
| + | |||
| + | <code> | ||
| + | Person | ||
| + | id name familienstand_id | ||
| + | 1 Eva 6 | ||
| + | 2 Max 8 | ||
| + | |||
| + | Familienstand | ||
| + | id name | ||
| + | 6 Verheiratet | ||
| + | 7 Geschieden | ||
| + | 8 Ledig | ||
| + | |||
| - | * id person_id email | + | id person_id email |
| - | * 3 1 eva@gmx.at | + | 3 1 eva@gmx.at |
| - | * 4 1 eva@gmail.com | + | 4 1 eva@gmail.com |
| - | * 5 2 max@ms.com | + | 5 2 max@ms.com |
| + | |||
| + | Projekt | ||
| + | id name | ||
| + | 12 Web | ||
| + | 13 Security | ||
| + | |||
| + | Projekt_X_Person | ||
| + | id person_id projekt_id anteil_pct | ||
| + | 14 1 12 20 | ||
| + | 15 1 13 80 | ||
| + | 16 2 12 100 | ||
| + | |||
| + | </code> | ||
kurs/relationen.1646654491.txt.gz · Last modified: 2022/03/07 13:01 by admin
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
