From 41e6dfcbf88a2deab02f944d35b0a6b76a0df74a Mon Sep 17 00:00:00 2001 From: Matthias Schiffer Date: Mon, 8 Sep 2008 23:19:38 +0200 Subject: Datenbank-Design angefangen --- Konzept/Datenbank.txt | 42 ++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 42 insertions(+) create mode 100644 Konzept/Datenbank.txt 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 -- cgit v1.2.3