diff options
| -rw-r--r-- | Konzept/Datenbank.txt | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/Konzept/Datenbank.txt b/Konzept/Datenbank.txt new file mode 100644 index 0000000..8adba8f --- /dev/null +++ b/Konzept/Datenbank.txt @@ -0,0 +1,42 @@ +Datenbank: + +Auflistung der Tabellen: + +Tabelle 'persons': +INTEGER id (PRIMARY KEY) + +TEXT displayAs + +TEXT namePrefix +TEXT nameGiven +TEXT nameAdditional +TEXT nameFamily +TEXT nameSuffix + +INTEGER birthdayYear +INTEGER birthdayMonth +INTEGER birthdayDay + +NONE picture + +TEXT notes + + +Tabelle 'orgs': +INTEGER id (PRIMARY KEY) + +TEXT name + +INTEGER contactPerson (REF) + +NONE picture + +TEXT notes + + +Tabelle 'personOrgs': +INTEGER personId +INTEGER orgId + +TEXT title +TEXT unit |