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