-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathjot-schema.er
53 lines (45 loc) · 1.35 KB
/
jot-schema.er
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
43
44
45
46
47
48
49
50
51
52
53
[organizer]
*id {label:"VARCHAR(80)"}
name {label:"VARCHAR(80)"}
[calendar]
*id {label:"VARCHAR(80)"}
name {label:"VARCHAR(80)"}
description {label:"VARCHAR(80)"}
color {label:"VARCHAR(80)"}
image {label:"VARCHAR(80)"}
url {label:"VARCHAR(80)"}
refresh-interval {label:"VARCHAR(80)"}
source {label:"VARCHAR(80)"}
categories {label:"VARCHAR(80)"}
timezone {label:"VARCHAR(80)"}
[journal_entry]
*id {label:"VARCHAR(80)"}
organizer_id {label:"VARCHAR(80)"}
[journal_revision]
*sequenceno {label:"VARCHAR(80)"}
*recurrenceid {label:"VARCHAR(80)"}
summary {label:"VARCHAR(80)"}
description {label:"VARCHAR(1024)"}
status {label:"INTEGER"}
classification {label:"VARCHAR(80)"}
categories {label:"VARCHAR(80)"}
[journal_attachment]
*id {label:"VARCHAR(80)"}
name {label:"VARCHAR(80)"}
[journal_comment]
*id {label:"VARCHAR(80)"}
name {label:"VARCHAR(80)"}
[journal_contact]
*id {label:"VARCHAR(80)"}
name {label:"VARCHAR(80)"}
[journal_related]
*id {label:"VARCHAR(80)"}
name {label:"VARCHAR(80)"}
organizer 1--+ journal_entry
organizer 1--* calendar
calendar ?--* journal_entry
journal_entry 1--+ journal_revision
journal_revision 1--* journal_attachment
journal_revision 1--* journal_comment
journal_revision 1--* journal_contact
journal_revision 1--* journal_related