summaryrefslogtreecommitdiff
path: root/rt/docs/rt3-schema-relationships.dot
blob: 77ed35f01753300dd4758f817312c89363d05066 (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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
digraph g {
graph [
rankdir = "LR",
concentrate = true,
ratio = auto
];
node [
fontsize = "18",
shape = record, fontsize = 18
];
edge [
];

"ACL" [shape = record, fontsize = 18, label = "<col0> \N " ];
"ACL" -> "Principals" [label="PrincipalId -> Id"];
"ACL" -> "Principals" [label="DelegatedBy -> Id"];
"ACL" -> "ACL" [label="DelegatedFrom -> Id"];

"Attachments" [shape = record, fontsize = 18, label = "<col0> \N " ];
"Attachments" -> "Transactions" [label="TransactionId -> id"];
"Attachments" -> "Attachments" [label="Parent -> id"];

"CachedGroupMemers" [shape = record, fontsize = 18, label = "<col0> \N " ];
"CachedGroupMemers" -> "Groups" [label="GroupId -> Groups.id"];
"CachedGroupMemers" -> "Principals" [label="MemberId -> Id"];
"CachedGroupMemers" -> "CachedGroupMemers" [label="Via -> id"];
"CachedGroupMemers" -> "Groups" [label="ImmediateParentId -> Groups.id"];

"CustomFields" [shape = record, fontsize = 18, label = "<col0> \N " ];
"CustomFields" -> "Queues" [label="Queue -> id"];

"CustomFieldValues" [shape = record, fontsize = 18, label = "<col0> \N " ];
"CustomFieldValues" -> "CustomFields" [label="CustomField -> id"];

"GroupMembers" [shape = record, fontsize = 18, label = "<col0> \N " ];
"GroupMembers" -> "Groups" [label="GroupId => Groups.Id"];
"GroupMembers" -> "Principals" [label="MemberId => Id"];

"Groups" [shape = record, fontsize = 18, label = "<col0> \N " ];
"Groups" -> "Principals" [label="Groups.id -> id"];

"Links" [shape = record, fontsize = 18, label = "<col0> \N " ];
"Links" -> "Tickets" [label="LocalBase => id (usually)"];
"Links" -> "Tickets" [label="LocalTarget => id (usually)"];

"Principals" [shape = record, fontsize = 18, label = "<col0> \N " ];


"Queues" [shape = record, fontsize = 18, label = "<col0> \N " ];

"ScripActions" [shape = record, fontsize = 18, label = "<col0> \N " ];

"ScripConditions" [shape = record, fontsize = 18, label = "<col0> \N " ];

"Scrips" [shape = record, fontsize = 18, label = "<col0> \N " ];
"Scrips" -> "ScripConditions" [label="ScripCondition -> id"];
"Scrips" -> "ScripActions" [label="ScripAction -> id"];
"Scrips" -> "Templates" [label="Template -> id"];
"Scrips" -> "Queues" [label="Queue -> id"];

"Templates" [shape = record, fontsize = 18, label = "<col0> \N " ];
"Templates" -> "Queues" [label ="Queue -> id" ];

"TicketCustomFieldValues" [shape = record, fontsize = 18, label = "<col0> \N " ];
"TicketCustomFieldValues" -> "Tickets" [label="Ticket -> id"];
"TicketCustomFieldValues" -> "CustomFields" [label="CustomField -> id"];

"Tickets" [shape = record, fontsize = 18, label = "<col0> \N " ];
"Tickets" -> "Tickets" [label="EffectiveId -> id"];
"Tickets" -> "Queues" [label="Queue -> id"];
"Tickets" -> "Principals" [label="Owner -> id"];

"Transactions" [shape = record, fontsize = 18, label = "<col0> \N " ];
"Transactions" -> "Tickets" [label="Ticket -> Id"];

"Users" [shape = record, fontsize = 18, label = "<col0> \N " ];

"Users" -> "Principals" [label="id -> id"];


}