kurs:relationen
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
kurs:relationen [2022/03/07 13:02] admin |
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 | ||
| + | |||
| + | 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> | <code> | ||
| Person | Person | ||
| - | id name | + | id name familienstand_id |
| - | 1 Eva | + | 1 Eva 6 |
| - | 2 Max | + | 2 Max 8 |
| + | |||
| + | Familienstand | ||
| + | id name | ||
| + | 6 Verheiratet | ||
| + | 7 Geschieden | ||
| + | 8 Ledig | ||
| + | |||
| id person_id email | id person_id email | ||
| Line 27: | Line 57: | ||
| 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> | </code> | ||
kurs/relationen.txt · Last modified: 2022/03/07 13:22 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
