summaryrefslogtreecommitdiffstats
path: root/Konzept/Datenbank.txt
blob: 8adba8f454a132fe5e7c32f4ede5be424fb36299 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
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