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
|