Difference between revisions of "User:Exor674/NewTable"

Latest revision as of 21:07, 15 September 2010

userpic2 -> userpicmap2 [label="on picid"]; userpicmap2 -> userkeywords [label="on userid, kwid"]

ec [label="Entries and Comments"; style="dotted"];

ec->userkeywords [label="by keyword"]; } </graphviz>

userpic2 -> userpicmap2 [label="on picid"]; userpicmap2 -> userkeywords [label="on userid, kwid"]

ec [label="Entries and Comments"; style="dotted"];

ec->userpicmap2 [label="by picmapid"]; } </graphviz>

userpicentrymap [label="userpicentrymap\nuserod,kwid,picid"; shape="doubleoctogon"];

userpic2 -> userpicmap2 [label="on picid"]; userpicmap2 -> userkeywords [label="on userid, kwid"]

ec [label="Entries and Comments"; style="dotted"];

ec->userpicmap2 [label="by picmapid"]; } </graphviz>

@@ Line 18: / Line 18: @@
 ==New==
+===Existing Table===
 <graphviz>
@@ Line 31: / Line 33: @@
 ec [label="Entries and Comments"; style="dotted"];
-ec->userkeywords [label="by picmapid"];
+ec->userpicmap2 [label="by picmapid"];
 }
 </graphviz>
-code mods needed:
-* leave rows around in userpicmap2 when the keyword goes away with picid of 0
+===New Table===
-* when renaming keywords, keep the same picmapid, change the kwid -- even if it creates duplicates
-* when moving a keyword to a different userpic, keep the same picmapid, change the picid
+<graphviz>
+digraph G {
+userpic2 [URL="http://wiki.dwscoalition.org/notes/Database_Table:_userpic2"];
+userpicmap2 [URL="http://wiki.dwscoalition.org/notes/Database_Table:_userpicmap2"; label="userpicmap2\nuserid, kwid, picid"; ];
+userkeywords [URL="http://wiki.dwscoalition.org/notes/Database_Table:_userkeywords"];
+userpicentrymap [label="userpicentrymap\nuserod,kwid,picid"; shape="doubleoctogon"];
+userpic2 -> userpicmap2 [label="on picid"];
+userpicmap2 -> userkeywords [label="on userid, kwid"]
+ec [label="Entries and Comments"; style="dotted"];
+ec->userpicmap2 [label="by picmapid"];
+}
+</graphviz>