summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-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