Upgrade to 4.0.8 with mod of ExternalAuth + absolute paths to ticket-menu.
[usit-rt.git] / docs / schema.dot
CommitLineData
84fb5b46
MKG
1digraph g {
2graph [
3rankdir = "RL",
4 concentrate = true,
5ratio = auto
6];
7node [
8fontsize = "18",
9shape = record, fontsize = 18
10];
11edge [
12];
13
14"Records" [shape = record, fontsize = 18, label = "(Any RT::Record)" ];
15"Records" -> "Principals" [label = "Creator → id"];
16"ACL" [shape = record, fontsize = 18, label = "<col0> \N " ];
17"ACL" -> "Principals" [label="PrincipalId → id"];
18"ACL" -> "Records" [label="ObjectId → id"];
19
20"Attachments" [shape = record, fontsize = 18, label = "<col0> \N " ];
21"Attachments" -> "Transactions" [label="TransactionId → id"];
22"Attachments" -> "Attachments" [label="Parent → id"];
23
24"CachedGroupMembers" [shape = record, fontsize = 18, label = "<col0> \N " ];
25"CachedGroupMembers" -> "Groups" [label="GroupId → id", weight=2];
26"CachedGroupMembers" -> "Principals" [label="MemberId → id"];
27"CachedGroupMembers" -> "CachedGroupMembers" [label="Via → id"];
28"CachedGroupMembers" -> "Groups" [label="ImmediateParentId → id"];
29
30"CustomFields" [shape = record, fontsize = 18, label = "<col0> \N " ];
31
32"CustomFieldValues" [shape = record, fontsize = 18, label = "<col0> \N " ];
33"CustomFieldValues" -> "CustomFields" [label="CustomField → id"];
34
35"GroupMembers" [shape = record, fontsize = 18, label = "<col0> \N " ];
36"GroupMembers" -> "Groups" [label="GroupId → id", weight=2];
37"GroupMembers" -> "Principals" [label="MemberId → id", weight = 2];
38
39"Groups" [shape = record, fontsize = 18, label = "<col0> \N " ];
40"Groups" -> "Principals" [label="id → id"];
41
42"Links" [shape = record, fontsize = 18, label = "<col0> \N " ];
43"Links" -> "Tickets" [label="LocalBase ⇢ id (usually)", style="dotted"];
44"Links" -> "Tickets" [label="LocalTarget ⇢ id (usually)", style="dotted"];
45
46"Principals" [shape = record, fontsize = 18, label = "<col0> \N " ];
47
48"Attributes" [shape = record, fontsize = 18, label = "<col0> \N " ];
49"Attributes" -> "Records" [label="ObjectId → id"];
50
51"Queues" [shape = record, fontsize = 18, label = "<col0> \N " ];
52
53"ScripActions" [shape = record, fontsize = 18, label = "<col0> \N " ];
54
55"ScripConditions" [shape = record, fontsize = 18, label = "<col0> \N " ];
56
57"Scrips" [shape = record, fontsize = 18, label = "<col0> \N " ];
58"Scrips" -> "ScripConditions" [label="ScripCondition → id"];
59"Scrips" -> "ScripActions" [label="ScripAction → id"];
60"Scrips" -> "Templates" [label="Template → id"];
61"Scrips" -> "Queues" [label="Queue → id"];
62
63"Templates" [shape = record, fontsize = 18, label = "<col0> \N " ];
64"Templates" -> "Queues" [label ="Queue → id" ];
65
66"ObjectCustomFields" [shape = record, fontsize = 18, label = "<col0> \N " ];
67"ObjectCustomFields" -> "CustomFields" [label="CustomField → id"];
68"ObjectCustomFields" -> "Records" [label="ObjectId → id"];
69
70"ObjectCustomFieldValues" [shape = record, fontsize = 18, label = "<col0> \N " ];
71"ObjectCustomFieldValues" -> "CustomFields" [label="CustomField → id"];
72"ObjectCustomFieldValues" -> "Records" [label="ObjectId → id"];
73
74"Tickets" [shape = record, fontsize = 18, label = "<col0> \N " ];
75"Tickets" -> "Tickets" [label="EffectiveId → id"];
76"Tickets" -> "Principals" [label="Owner → id"];
77"Queues" -> "Tickets" [style="invis"];
78"Tickets" -> "Queues" [label="Queue → id"];
79
80"Transactions" [shape = record, fontsize = 18, label = "<col0> \N " ];
81"Transactions" -> "Records" [label="ObjectId → id"];
82
83"Users" [shape = record, fontsize = 18, label = "<col0> \N " ];
84
85"Users" -> "Principals" [label="id → id"];
86
87// "Classes" [shape = record, fontsize = 18 label = "<col0> \N " ];
88// "Articles" [shape = record, fontsize = 18 label = "<col0> \N " ];
89// "Articles" -> "Classes" [ label="Class → id"];
90// "Articles" -> "Articles" [ label="Parent → id"];
91// "ObjectClasses" [shape = record, fontsize = 18 label = "<col0> \N " ];
92// "ObjectClasses" -> "Records" [label="ObjectId → id"];
93// "ObjectClasses" -> "Classes" [label="Class → id"];
94// "Topics" [shape = record, fontsize = 18 label = "<col0> \N " ];
95// "ObjectTopics" [shape = record, fontsize = 18 label = "<col0> \N " ];
96// "ObjectTopics" -> "Records" [label="ObjectId → id"];
97// "ObjectTopics" -> "Topics" [label="Topic → id"];
98
99}