summaryrefslogtreecommitdiffstats
path: root/Konzept
diff options
context:
space:
mode:
authorMatthias Schiffer <matthias@gamezock.de>2008-09-08 23:19:38 +0200
committerMatthias Schiffer <matthias@gamezock.de>2008-09-08 23:19:38 +0200
commit41e6dfcbf88a2deab02f944d35b0a6b76a0df74a (patch)
tree8a3047899811a720dd9a78299414cdc080340868 /Konzept
parentd378415ecf01fcae27fa6f9b1c303c806b69cc52 (diff)
downloaddataserver-master.tar
dataserver-master.zip
Datenbank-Design angefangenHEADmaster
Diffstat (limited to 'Konzept')
-rw-r--r--Konzept/Datenbank.txt42
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