~launchpad-pqm/launchpad/devel

1339 by Canonical.com Patch Queue Manager
Add generated database diagrams (initial cut)
1
digraph g {
2
graph [
1776 by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams
3
    /* A4 */
3322.1.13 by Stuart Bishop
Update database diagrams
4
    /*page="8.27,11.69",*/
5
    /*size="7.27,10.69!",*/
1776 by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams
6
    fontsize=22,
3322.1.13 by Stuart Bishop
Update database diagrams
7
8
    /* Don't let edges cross nodes */
9
    overlap="999:portho",
10
    splines=true,
11
    sep=0.05,
12
13
    /* Try to get a good layout */
14
    maxiter=50000,
15
    K=0.2,
1363 by Canonical.com Patch Queue Manager
Refactored VSourcePackageReleasePublishing for Keybuk
16
    pack=true,
3322.1.13 by Stuart Bishop
Update database diagrams
17
    packmode="node",
1339 by Canonical.com Patch Queue Manager
Add generated database diagrams (initial cut)
18
];
19
node [
3322.1.13 by Stuart Bishop
Update database diagrams
20
    shape = plaintext,
21
    fontsize=8,
1339 by Canonical.com Patch Queue Manager
Add generated database diagrams (initial cut)
22
];
23
edge [
3322.1.13 by Stuart Bishop
Update database diagrams
24
    fontsize=8,
25
    len=0.15
1339 by Canonical.com Patch Queue Manager
Add generated database diagrams (initial cut)
26
];
27
<TMPL_LOOP name="schemas">
28
    <TMPL_LOOP name="tables">
29
        <TMPL_UNLESS name="view_definition">
30
"<TMPL_IF name="number_of_schemas"><TMPL_VAR name="schema_dot">.</TMPL_IF name="number_of_schemas"><TMPL_VAR name="table_dot">" [shape = plaintext, label = <
31
<TABLE BGCOLOR="azure3" BORDER="1" ALIGN="LEFT" PORT="col1">
32
<TR BORDER="1"><TD BGCOLOR="white" COLSPAN="3" ALIGN="CENTER">\N</TD></TR>
33
<TMPL_LOOP name="columns">
34
    <TR BORDER="0" PORT="<TMPL_VAR name="column_dot">">
35
        <TD ALIGN="LEFT" BORDER="0"><TMPL_VAR name="column_dot"></TD>
36
        <TD ALIGN="LEFT" BORDER="0"><TMPL_VAR name="column_type"></TD>
37
        <TD ALIGN="LEFT" BORDER="0"><TMPL_LOOP name="column_constraints">
38
<TMPL_IF name="column_unique"> UNIQUE</TMPL_IF><TMPL_IF name="column_notnull"> NOT NULL</TMPL_IF><TMPL_IF name="column_primary_key"> PRIMARY KEY</TMPL_IF><TMPL_IF name="column_fk"> REFERENCES <TMPL_VAR name="column_fk_table"></TMPL_IF>
39
</TMPL_LOOP></TD>
40
    </TR>
41
</TMPL_LOOP name="columns"></TABLE>> ];
42
        </TMPL_UNLESS name="view_definition">
43
    </TMPL_LOOP name="tables">
44
</TMPL_LOOP name="schemas">
45
46
<TMPL_LOOP name="fk_links">
47
"<TMPL_IF name="number_of_schemas"><TMPL_VAR name="handle0_schema">.</TMPL_IF name="number_of_schemas"><TMPL_VAR name="handle0_name">" -> "<TMPL_IF name="number_of_schemas"><TMPL_VAR name="handle1_schema">.</TMPL_IF name="number_of_schemas"><TMPL_VAR name="handle1_name">" [label=""];</TMPL_LOOP name="fk_links">
48
}