diff options
| author | Matthias Schiffer <matthias@gamezock.de> | 2008-09-08 23:19:38 +0200 |
|---|---|---|
| committer | Matthias Schiffer <matthias@gamezock.de> | 2008-09-08 23:19:38 +0200 |
| commit | 41e6dfcbf88a2deab02f944d35b0a6b76a0df74a (patch) | |
| tree | 8a3047899811a720dd9a78299414cdc080340868 /Konzept | |
| parent | d378415ecf01fcae27fa6f9b1c303c806b69cc52 (diff) | |
| download | dataserver-master.tar dataserver-master.zip | |
Diffstat (limited to 'Konzept')
| -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 |