Mercurial > gemma

annotate schema/dot.tmpl @ 1819:99cf6da4c8c0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Removed all unique geohash indexes as they prevent updates of data. What ever the intension of these indexes were, in the given form they are wrong and prevent updating of data in an area, where old data already exists.
author Sascha Wilde <wilde@intevation.de>
date Wed, 16 Jan 2019 10:36:22 +0100
parents 25b28fd0e256
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
61
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
1 digraph g {
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
2 graph [
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
3 rankdir = "LR",
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
4 concentrate = true,
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
5 ratio = auto
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
6 ];
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
7 node [
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
8 fontsize = "10",
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
9 shape = record
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
10 ];
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
11 edge [
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
12 ];
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
13 <TMPL_LOOP name="schemas"><TMPL_LOOP name="tables"><TMPL_UNLESS name="view_definition">
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
14 "<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 = <<TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"><TR><TD PORT="ltcol0"></TD><TD border="1" COLSPAN="2"> \N </TD><TD PORT="rtcol0"></TD></TR><TMPL_LOOP name="columns"><TR><TD PORT="ltcol<TMPL_VAR name="column_number">"></TD><TD align="left"><TMPL_VAR name="column_dot"></TD><TD align="left"><TMPL_VAR name="column_type"></TD><TD align="left" PORT="rtcol<TMPL_VAR name="column_number">"></TD></TR></TMPL_LOOP name="columns"></TABLE>> ];
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
15 </TMPL_UNLESS name="view_definition"></TMPL_LOOP name="tables"></TMPL_LOOP name="schemas">
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
16
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
17 <TMPL_LOOP name="fk_links">
63
c18f1db22077 Omit rather useless labels of relations.
Tom Gottfried <tom@intevation.de>
parents: 61
diff changeset
18 "<TMPL_IF name="number_of_schemas"><TMPL_VAR name="handle0_schema">.</TMPL_IF name="number_of_schemas"><TMPL_VAR name="handle0_name">":rtcol<TMPL_VAR name="handle0_connection"> -> "<TMPL_IF name="number_of_schemas"><TMPL_VAR name="handle1_schema">.</TMPL_IF name="number_of_schemas"><TMPL_VAR name="handle1_name">":ltcol<TMPL_VAR name="handle1_connection"> [];</TMPL_LOOP name="fk_links">
61
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
19 }