X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=rt%2Fdocs%2Frt3-schema-relationships.dot;h=e290f8bcfda41f7815b4e80a954f9af7f7199721;hb=b6dbe0f12dbbe4ea5209367f905f937789b5b607;hp=77ed35f01753300dd4758f817312c89363d05066;hpb=289340780927b5bac2c7604d7317c3063c6dd8cc;p=freeside.git

diff --git a/rt/docs/rt3-schema-relationships.dot b/rt/docs/rt3-schema-relationships.dot
index 77ed35f01..e290f8bcf 100644
--- a/rt/docs/rt3-schema-relationships.dot
+++ b/rt/docs/rt3-schema-relationships.dot
@@ -1,7 +1,7 @@
 digraph g {
 graph [
-rankdir = "LR",
-concentrate = true,
+rankdir = "RL",
+ concentrate = true,
 ratio = auto
 ];
 node [
@@ -11,40 +11,43 @@ shape = record, fontsize = 18
 edge [
 ];
 
+"Records" [shape = record, fontsize = 18, label = "(Any RT::Record)" ];
+"Records" -> "Principals" [label = "Creator -> id"];
 "ACL" [shape = record, fontsize = 18, label = "<col0> \N " ];
-"ACL" -> "Principals" [label="PrincipalId -> Id"];
-"ACL" -> "Principals" [label="DelegatedBy -> Id"];
-"ACL" -> "ACL" [label="DelegatedFrom -> Id"];
+"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" -> "Groups" [label="GroupId -> id", weight=2];
+"CachedGroupMemers" -> "Principals" [label="MemberId -> id"];
 "CachedGroupMemers" -> "CachedGroupMemers" [label="Via -> id"];
-"CachedGroupMemers" -> "Groups" [label="ImmediateParentId -> Groups.id"];
+"CachedGroupMemers" -> "Groups" [label="ImmediateParentId -> 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"];
+"GroupMembers" -> "Groups" [label="GroupId -> id", weight=2];
+"GroupMembers" -> "Principals" [label="MemberId -> id", weight = 2];
 
 "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)"];
+"Links" -> "Tickets" [label="LocalBase => id (usually)", style="dotted"];
+"Links" -> "Tickets" [label="LocalTarget => id (usually)", style="dotted"];
 
 "Principals" [shape = record, fontsize = 18, label = "<col0> \N " ];
 
+"Attributes" [shape = record, fontsize = 18, label = "<col0> \N " ];
+"Attributes" -> "Records" [label="ObjectId -> id"];
 
 "Queues" [shape = record, fontsize = 18, label = "<col0> \N " ];
 
@@ -61,17 +64,22 @@ edge [
 "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"];
+"ObjectCustomFields" [shape = record, fontsize = 18, label = "<col0> \N " ];
+"ObjectCustomFields" -> "CustomFields" [label="CustomField -> id"];
+"ObjectCustomFields" -> "Records" [label="ObjectId -> id"];
+
+"ObjectCustomFieldValues" [shape = record, fontsize = 18, label = "<col0> \N " ];
+"ObjectCustomFieldValues" -> "CustomFields" [label="CustomField -> id"];
+"ObjectCustomFieldValues" -> "Records" [label="ObjectId -> id"];
 
 "Tickets" [shape = record, fontsize = 18, label = "<col0> \N " ];
 "Tickets" -> "Tickets" [label="EffectiveId -> id"];
-"Tickets" -> "Queues" [label="Queue -> id"];
 "Tickets" -> "Principals" [label="Owner -> id"];
+"Queues" -> "Tickets" [style="invis"];
+"Tickets" -> "Queues" [label="Queue -> id"];
 
 "Transactions" [shape = record, fontsize = 18, label = "<col0> \N " ];
-"Transactions" -> "Tickets" [label="Ticket -> Id"];
+"Transactions" -> "Records" [label="ObjectId -> id"];
 
 "Users" [shape = record, fontsize = 18, label = "<col0> \N " ];