Skip to content

Instantly share code, notes, and snippets.

@omad
Last active November 18, 2022 05:39
Show Gist options
  • Save omad/2acc9d2e2139b4351442c2debf525158 to your computer and use it in GitHub Desktop.
Save omad/2acc9d2e2139b4351442c2debf525158 to your computer and use it in GitHub Desktop.
Open Data Cube PostgreSQL Database Schema

Run SchemaSpy to generate database table diagrams

Using Docker

docker run -it --rm -v "$PWD:/output" --network="host" schemaspy/schemaspy -u dra547 -host localhost -port 15432 -db datacube -t pgsql -schemas agdc,cubedash -norows -noviews -pfp -imageformat svg

If SchemaSpy is downloaded Locally

java -jar schemaspy-6.1.0.jar -o . -u dra547 -host localhost -port 15432 -db datacube -t pgsql -dp postgresql-42.5.0.jar -s agdc -norows -noviews

Grab the relationship diagram from ./diagrams/summary/relationships.real.large.svg

digraph "largeRelationshipsDiagram" {
graph [
rankdir="RL"
bgcolor="#ffffff"
label="\nGenerated by SchemaSpy"
labeljust="l"
nodesep="0.18"
ranksep="0.46"
fontname="Helvetica"
fontsize="11"
ration="compress"
];
node [
fontname="Helvetica"
fontsize="11"
shape="plaintext"
];
edge [
arrowsize="0.8"
];
"dataset" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>dataset</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">id</TD></TR></TABLE></TD></TR>
<TR><TD PORT="metadata_type_ref" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">metadata_type_ref</TD></TR></TABLE></TD></TR>
<TR><TD PORT="dataset_type_ref" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">dataset_type_ref</TD></TR></TABLE></TD></TR>
<TR><TD PORT="metadata" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">metadata</TD></TR></TABLE></TD></TR>
<TR><TD PORT="archived" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">archived</TD></TR></TABLE></TD></TR>
<TR><TD PORT="added" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">added</TD></TR></TABLE></TD></TR>
<TR><TD PORT="added_by" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">added_by</TD></TR></TABLE></TD></TR>
<TR><TD PORT="updated" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">updated</TD></TR></TABLE></TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff"> </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">3 &gt;</TD></TR>
</TABLE>>
URL="../../tables/dataset.html"
target="_top"
tooltip="dataset"
];
"dataset_location" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>dataset_location</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="99" HEIGHT="16">id</TD></TR></TABLE></TD></TR>
<TR><TD PORT="dataset_ref" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="99" HEIGHT="16">dataset_ref</TD></TR></TABLE></TD></TR>
<TR><TD PORT="uri_scheme" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="99" HEIGHT="16">uri_scheme</TD></TR></TABLE></TD></TR>
<TR><TD PORT="uri_body" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="99" HEIGHT="16">uri_body</TD></TR></TABLE></TD></TR>
<TR><TD PORT="added" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="99" HEIGHT="16">added</TD></TR></TABLE></TD></TR>
<TR><TD PORT="added_by" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="99" HEIGHT="16">added_by</TD></TR></TABLE></TD></TR>
<TR><TD PORT="archived" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="99" HEIGHT="16">archived</TD></TR></TABLE></TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff"> </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff"> </TD></TR>
</TABLE>>
URL="../../tables/dataset_location.html"
target="_top"
tooltip="dataset_location"
];
"dataset_source" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>dataset_source</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="dataset_ref" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">dataset_ref</TD></TR></TABLE></TD></TR>
<TR><TD PORT="classifier" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">classifier</TD></TR></TABLE></TD></TR>
<TR><TD PORT="source_dataset_ref" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">source_dataset_ref</TD></TR></TABLE></TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff"> </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff"> </TD></TR>
</TABLE>>
URL="../../tables/dataset_source.html"
target="_top"
tooltip="dataset_source"
];
"dataset_type" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>dataset_type</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">id</TD></TR></TABLE></TD></TR>
<TR><TD PORT="name" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">name</TD></TR></TABLE></TD></TR>
<TR><TD PORT="metadata" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">metadata</TD></TR></TABLE></TD></TR>
<TR><TD PORT="metadata_type_ref" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/foreignKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">metadata_type_ref</TD></TR></TABLE></TD></TR>
<TR><TD PORT="definition" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">definition</TD></TR></TABLE></TD></TR>
<TR><TD PORT="added" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">added</TD></TR></TABLE></TD></TR>
<TR><TD PORT="added_by" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">added_by</TD></TR></TABLE></TD></TR>
<TR><TD PORT="updated" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="112" HEIGHT="16">updated</TD></TR></TABLE></TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff"> </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">1 &gt;</TD></TR>
</TABLE>>
URL="../../tables/dataset_type.html"
target="_top"
tooltip="dataset_type"
];
"metadata_type" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#f5f5f5"><TABLE BORDER="0" CELLSPACING="0"><TR><TD ALIGN="LEFT"><B>metadata_type</B></TD><TD ALIGN="RIGHT">[table]</TD></TR></TABLE></TD></TR>
<TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"><IMG SRC="../../images/primaryKeys.png"/></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="90" HEIGHT="16">id</TD></TR></TABLE></TD></TR>
<TR><TD PORT="name" COLSPAN="3" BGCOLOR="#ffffff" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="90" HEIGHT="16">name</TD></TR></TABLE></TD></TR>
<TR><TD PORT="definition" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="90" HEIGHT="16">definition</TD></TR></TABLE></TD></TR>
<TR><TD PORT="added" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="90" HEIGHT="16">added</TD></TR></TABLE></TD></TR>
<TR><TD PORT="added_by" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="90" HEIGHT="16">added_by</TD></TR></TABLE></TD></TR>
<TR><TD PORT="updated" COLSPAN="3" ALIGN="LEFT"><TABLE BORDER="0" CELLSPACING="0" ALIGN="LEFT"><TR ALIGN="LEFT"><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="15" HEIGHT="16"></TD><TD ALIGN="LEFT" FIXEDSIZE="TRUE" WIDTH="90" HEIGHT="16">updated</TD></TR></TABLE></TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#ffffff"> </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff"> </TD><TD ALIGN="RIGHT" BGCOLOR="#ffffff">2 &gt;</TD></TR>
</TABLE>>
URL="../../tables/metadata_type.html"
target="_top"
tooltip="metadata_type"
];
"dataset":"dataset_type_ref":w -> "dataset_type":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"dataset":"metadata_type_ref":w -> "metadata_type":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"dataset_location":"dataset_ref":w -> "dataset":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"dataset_source":"dataset_ref":w -> "dataset":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"dataset_source":"source_dataset_ref":w -> "dataset":"id":e [arrowhead=none dir=back arrowtail=crowodot];
"dataset_type":"metadata_type_ref":w -> "metadata_type":"id":e [arrowhead=none dir=back arrowtail=crowodot];
}
Display the source blob
Display the rendered blob
Raw
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
"http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
<!-- Generated by graphviz version 2.38.0 (20140413.2041)
-->
<!-- Title: largeRelationshipsDiagram Pages: 1 -->
<svg width="716pt" height="541pt"
viewBox="0.00 0.00 716.00 541.00" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
<g id="graph0" class="graph" transform="scale(1 1) rotate(0) translate(4 537)">
<title>largeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="none" points="-4,4 -4,-537 712,-537 712,4 -4,4"/>
<text text-anchor="middle" x="74.5" y="-7.2" font-family="Helvetica,sans-Serif" font-size="11.00">Generated by SchemaSpy</text>
<!-- dataset -->
<g id="node1" class="node"><title>dataset</title>
<g id="a_node1"><a xlink:href="../../tables/dataset.html" xlink:title="dataset" target="_top">
<polygon fill="#ffffff" stroke="none" points="375,-98 375,-314 508,-314 508,-98 375,-98"/>
<polygon fill="#f5f5f5" stroke="none" points="375.5,-292 375.5,-314 508.5,-314 508.5,-292 375.5,-292"/>
<polygon fill="none" stroke="black" points="375.5,-292 375.5,-314 508.5,-314 508.5,-292 375.5,-292"/>
<text text-anchor="start" x="380.5" y="-301.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">dataset</text>
<text text-anchor="start" x="469.5" y="-300.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="375.5,-270 375.5,-292 508.5,-292 508.5,-270 375.5,-270"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="380.5" y="-287"/>
<text text-anchor="start" x="395.5" y="-278.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="375.5,-248 375.5,-270 508.5,-270 508.5,-248 375.5,-248"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="380.5" y="-265"/>
<text text-anchor="start" x="395.5" y="-256.2" font-family="Helvetica,sans-Serif" font-size="11.00">metadata_type_ref</text>
<polygon fill="#ffffff" stroke="none" points="375.5,-226 375.5,-248 508.5,-248 508.5,-226 375.5,-226"/>
<polygon fill="none" stroke="black" points="375.5,-226 375.5,-248 508.5,-248 508.5,-226 375.5,-226"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="380.5" y="-243"/>
<text text-anchor="start" x="395.5" y="-234.2" font-family="Helvetica,sans-Serif" font-size="11.00">dataset_type_ref</text>
<polygon fill="none" stroke="black" points="375.5,-204 375.5,-226 508.5,-226 508.5,-204 375.5,-204"/>
<text text-anchor="start" x="395.5" y="-212.2" font-family="Helvetica,sans-Serif" font-size="11.00">metadata</text>
<polygon fill="none" stroke="black" points="375.5,-182 375.5,-204 508.5,-204 508.5,-182 375.5,-182"/>
<text text-anchor="start" x="395.5" y="-190.2" font-family="Helvetica,sans-Serif" font-size="11.00">archived</text>
<polygon fill="#ffffff" stroke="none" points="375.5,-160 375.5,-182 508.5,-182 508.5,-160 375.5,-160"/>
<polygon fill="none" stroke="black" points="375.5,-160 375.5,-182 508.5,-182 508.5,-160 375.5,-160"/>
<text text-anchor="start" x="395.5" y="-168.2" font-family="Helvetica,sans-Serif" font-size="11.00">added</text>
<polygon fill="none" stroke="black" points="375.5,-138 375.5,-160 508.5,-160 508.5,-138 375.5,-138"/>
<text text-anchor="start" x="395.5" y="-146.2" font-family="Helvetica,sans-Serif" font-size="11.00">added_by</text>
<polygon fill="none" stroke="black" points="375.5,-116 375.5,-138 508.5,-138 508.5,-116 375.5,-116"/>
<text text-anchor="start" x="395.5" y="-124.2" font-family="Helvetica,sans-Serif" font-size="11.00">updated</text>
<polygon fill="#ffffff" stroke="none" points="375.5,-98 375.5,-116 435.5,-116 435.5,-98 375.5,-98"/>
<polygon fill="none" stroke="black" points="375.5,-98 375.5,-116 435.5,-116 435.5,-98 375.5,-98"/>
<text text-anchor="start" x="378.5" y="-104.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="none" points="435.5,-98 435.5,-116 466.5,-116 466.5,-98 435.5,-98"/>
<polygon fill="none" stroke="black" points="435.5,-98 435.5,-116 466.5,-116 466.5,-98 435.5,-98"/>
<text text-anchor="start" x="456.5" y="-104.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="none" points="466.5,-98 466.5,-116 508.5,-116 508.5,-98 466.5,-98"/>
<polygon fill="none" stroke="black" points="466.5,-98 466.5,-116 508.5,-116 508.5,-98 466.5,-98"/>
<text text-anchor="start" x="488.5" y="-104.2" font-family="Helvetica,sans-Serif" font-size="11.00">3 &gt;</text>
</a>
</g>
</g>
<!-- dataset_type -->
<g id="node4" class="node"><title>dataset_type</title>
<g id="a_node4"><a xlink:href="../../tables/dataset_type.html" xlink:title="dataset_type" target="_top">
<polygon fill="#ffffff" stroke="none" points="193,-37 193,-253 326,-253 326,-37 193,-37"/>
<polygon fill="#f5f5f5" stroke="none" points="193.5,-231 193.5,-253 326.5,-253 326.5,-231 193.5,-231"/>
<polygon fill="none" stroke="black" points="193.5,-231 193.5,-253 326.5,-253 326.5,-231 193.5,-231"/>
<text text-anchor="start" x="198.5" y="-240.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">dataset_type</text>
<text text-anchor="start" x="287.5" y="-239.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="193.5,-209 193.5,-231 326.5,-231 326.5,-209 193.5,-209"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="198.5" y="-226"/>
<text text-anchor="start" x="213.5" y="-217.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="none" points="193.5,-187 193.5,-209 326.5,-209 326.5,-187 193.5,-187"/>
<polygon fill="none" stroke="black" points="193.5,-187 193.5,-209 326.5,-209 326.5,-187 193.5,-187"/>
<text text-anchor="start" x="213.5" y="-195.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="none" stroke="black" points="193.5,-165 193.5,-187 326.5,-187 326.5,-165 193.5,-165"/>
<text text-anchor="start" x="213.5" y="-173.2" font-family="Helvetica,sans-Serif" font-size="11.00">metadata</text>
<polygon fill="none" stroke="black" points="193.5,-143 193.5,-165 326.5,-165 326.5,-143 193.5,-143"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="198.5" y="-160"/>
<text text-anchor="start" x="213.5" y="-151.2" font-family="Helvetica,sans-Serif" font-size="11.00">metadata_type_ref</text>
<polygon fill="none" stroke="black" points="193.5,-121 193.5,-143 326.5,-143 326.5,-121 193.5,-121"/>
<text text-anchor="start" x="213.5" y="-129.2" font-family="Helvetica,sans-Serif" font-size="11.00">definition</text>
<polygon fill="none" stroke="black" points="193.5,-99 193.5,-121 326.5,-121 326.5,-99 193.5,-99"/>
<text text-anchor="start" x="213.5" y="-107.2" font-family="Helvetica,sans-Serif" font-size="11.00">added</text>
<polygon fill="none" stroke="black" points="193.5,-77 193.5,-99 326.5,-99 326.5,-77 193.5,-77"/>
<text text-anchor="start" x="213.5" y="-85.2" font-family="Helvetica,sans-Serif" font-size="11.00">added_by</text>
<polygon fill="none" stroke="black" points="193.5,-55 193.5,-77 326.5,-77 326.5,-55 193.5,-55"/>
<text text-anchor="start" x="213.5" y="-63.2" font-family="Helvetica,sans-Serif" font-size="11.00">updated</text>
<polygon fill="#ffffff" stroke="none" points="193.5,-37 193.5,-55 253.5,-55 253.5,-37 193.5,-37"/>
<polygon fill="none" stroke="black" points="193.5,-37 193.5,-55 253.5,-55 253.5,-37 193.5,-37"/>
<text text-anchor="start" x="196.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="none" points="253.5,-37 253.5,-55 284.5,-55 284.5,-37 253.5,-37"/>
<polygon fill="none" stroke="black" points="253.5,-37 253.5,-55 284.5,-55 284.5,-37 253.5,-37"/>
<text text-anchor="start" x="274.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="none" points="284.5,-37 284.5,-55 326.5,-55 326.5,-37 284.5,-37"/>
<polygon fill="none" stroke="black" points="284.5,-37 284.5,-55 326.5,-55 326.5,-37 284.5,-37"/>
<text text-anchor="start" x="306.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- dataset&#45;&gt;dataset_type -->
<g id="edge1" class="edge"><title>dataset:dataset_type_ref:w&#45;&gt;dataset_type:id:e</title>
<path fill="none" stroke="black" d="M360.22,-234.039C349.534,-229.168 343.813,-220 327.5,-220"/>
<polygon fill="black" stroke="black" points="366.667,-235.376 373.769,-240.525 370.583,-236.188 374.5,-237 374.5,-237 374.5,-237 370.583,-236.188 375.231,-233.475 366.667,-235.376 366.667,-235.376"/>
<ellipse fill="none" stroke="black" cx="363.533" cy="-234.726" rx="3.2" ry="3.2"/>
</g>
<!-- metadata_type -->
<g id="node5" class="node"><title>metadata_type</title>
<g id="a_node5"><a xlink:href="../../tables/metadata_type.html" xlink:title="metadata_type" target="_top">
<polygon fill="#ffffff" stroke="none" points="8,-76 8,-248 144,-248 144,-76 8,-76"/>
<polygon fill="#f5f5f5" stroke="none" points="8,-226 8,-248 144,-248 144,-226 8,-226"/>
<polygon fill="none" stroke="black" points="8,-226 8,-248 144,-248 144,-226 8,-226"/>
<text text-anchor="start" x="13" y="-235.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">metadata_type</text>
<text text-anchor="start" x="105" y="-234.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-204 8,-226 144,-226 144,-204 8,-204"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-221"/>
<text text-anchor="start" x="41" y="-212.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="none" points="8,-182 8,-204 144,-204 144,-182 8,-182"/>
<polygon fill="none" stroke="black" points="8,-182 8,-204 144,-204 144,-182 8,-182"/>
<text text-anchor="start" x="41" y="-190.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="none" stroke="black" points="8,-160 8,-182 144,-182 144,-160 8,-160"/>
<text text-anchor="start" x="41" y="-168.2" font-family="Helvetica,sans-Serif" font-size="11.00">definition</text>
<polygon fill="none" stroke="black" points="8,-138 8,-160 144,-160 144,-138 8,-138"/>
<text text-anchor="start" x="41" y="-146.2" font-family="Helvetica,sans-Serif" font-size="11.00">added</text>
<polygon fill="none" stroke="black" points="8,-116 8,-138 144,-138 144,-116 8,-116"/>
<text text-anchor="start" x="41" y="-124.2" font-family="Helvetica,sans-Serif" font-size="11.00">added_by</text>
<polygon fill="none" stroke="black" points="8,-94 8,-116 144,-116 144,-94 8,-94"/>
<text text-anchor="start" x="41" y="-102.2" font-family="Helvetica,sans-Serif" font-size="11.00">updated</text>
<polygon fill="#ffffff" stroke="none" points="8,-76 8,-94 64,-94 64,-76 8,-76"/>
<polygon fill="none" stroke="black" points="8,-76 8,-94 64,-94 64,-76 8,-76"/>
<text text-anchor="start" x="11" y="-82.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="none" points="64,-76 64,-94 99,-94 99,-76 64,-76"/>
<polygon fill="none" stroke="black" points="64,-76 64,-94 99,-94 99,-76 64,-76"/>
<text text-anchor="start" x="89" y="-82.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="none" points="99,-76 99,-94 144,-94 144,-76 99,-76"/>
<polygon fill="none" stroke="black" points="99,-76 99,-94 144,-94 144,-76 99,-76"/>
<text text-anchor="start" x="124" y="-82.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 &gt;</text>
</a>
</g>
</g>
<!-- dataset&#45;&gt;metadata_type -->
<g id="edge2" class="edge"><title>dataset:metadata_type_ref:w&#45;&gt;metadata_type:id:e</title>
<path fill="none" stroke="black" d="M359.869,-260.063C351.938,-261.298 346.021,-263.261 334,-264 267.903,-268.065 244.827,-292.392 185,-264 159.602,-251.947 173.113,-215 145,-215"/>
<polygon fill="black" stroke="black" points="366.521,-259.58 374.761,-262.591 370.511,-259.29 374.5,-259 374.5,-259 374.5,-259 370.511,-259.29 374.239,-255.409 366.521,-259.58 366.521,-259.58"/>
<ellipse fill="none" stroke="black" cx="363.329" cy="-259.812" rx="3.2" ry="3.2"/>
</g>
<!-- dataset_location -->
<g id="node2" class="node"><title>dataset_location</title>
<g id="a_node2"><a xlink:href="../../tables/dataset_location.html" xlink:title="dataset_location" target="_top">
<polygon fill="#ffffff" stroke="none" points="557,-335 557,-529 700,-529 700,-335 557,-335"/>
<polygon fill="#f5f5f5" stroke="none" points="557.5,-507 557.5,-529 700.5,-529 700.5,-507 557.5,-507"/>
<polygon fill="none" stroke="black" points="557.5,-507 557.5,-529 700.5,-529 700.5,-507 557.5,-507"/>
<text text-anchor="start" x="562.5" y="-516.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">dataset_location</text>
<text text-anchor="start" x="661.5" y="-515.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="557.5,-485 557.5,-507 700.5,-507 700.5,-485 557.5,-485"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="562.5" y="-502"/>
<text text-anchor="start" x="589.5" y="-493.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="none" points="557.5,-463 557.5,-485 700.5,-485 700.5,-463 557.5,-463"/>
<polygon fill="none" stroke="black" points="557.5,-463 557.5,-485 700.5,-485 700.5,-463 557.5,-463"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="562.5" y="-480"/>
<text text-anchor="start" x="589.5" y="-471.2" font-family="Helvetica,sans-Serif" font-size="11.00">dataset_ref</text>
<polygon fill="#ffffff" stroke="none" points="557.5,-441 557.5,-463 700.5,-463 700.5,-441 557.5,-441"/>
<polygon fill="none" stroke="black" points="557.5,-441 557.5,-463 700.5,-463 700.5,-441 557.5,-441"/>
<text text-anchor="start" x="589.5" y="-449.2" font-family="Helvetica,sans-Serif" font-size="11.00">uri_scheme</text>
<polygon fill="#ffffff" stroke="none" points="557.5,-419 557.5,-441 700.5,-441 700.5,-419 557.5,-419"/>
<polygon fill="none" stroke="black" points="557.5,-419 557.5,-441 700.5,-441 700.5,-419 557.5,-419"/>
<text text-anchor="start" x="589.5" y="-427.2" font-family="Helvetica,sans-Serif" font-size="11.00">uri_body</text>
<polygon fill="none" stroke="black" points="557.5,-397 557.5,-419 700.5,-419 700.5,-397 557.5,-397"/>
<text text-anchor="start" x="589.5" y="-405.2" font-family="Helvetica,sans-Serif" font-size="11.00">added</text>
<polygon fill="none" stroke="black" points="557.5,-375 557.5,-397 700.5,-397 700.5,-375 557.5,-375"/>
<text text-anchor="start" x="589.5" y="-383.2" font-family="Helvetica,sans-Serif" font-size="11.00">added_by</text>
<polygon fill="none" stroke="black" points="557.5,-353 557.5,-375 700.5,-375 700.5,-353 557.5,-353"/>
<text text-anchor="start" x="589.5" y="-361.2" font-family="Helvetica,sans-Serif" font-size="11.00">archived</text>
<polygon fill="#ffffff" stroke="none" points="557.5,-335 557.5,-353 627.5,-353 627.5,-335 557.5,-335"/>
<polygon fill="none" stroke="black" points="557.5,-335 557.5,-353 627.5,-353 627.5,-335 557.5,-335"/>
<text text-anchor="start" x="560.5" y="-341.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="none" points="627.5,-335 627.5,-353 663.5,-353 663.5,-335 627.5,-335"/>
<polygon fill="none" stroke="black" points="627.5,-335 627.5,-353 663.5,-353 663.5,-335 627.5,-335"/>
<text text-anchor="start" x="653.5" y="-341.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="none" points="663.5,-335 663.5,-353 700.5,-353 700.5,-335 663.5,-335"/>
<polygon fill="none" stroke="black" points="663.5,-335 663.5,-353 700.5,-353 700.5,-335 663.5,-335"/>
<text text-anchor="start" x="690.5" y="-341.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- dataset_location&#45;&gt;dataset -->
<g id="edge3" class="edge"><title>dataset_location:dataset_ref:w&#45;&gt;dataset:id:e</title>
<path fill="none" stroke="black" d="M542.028,-471.698C484.013,-449.923 592.094,-281 509.5,-281"/>
<polygon fill="black" stroke="black" points="548.599,-472.743 555.934,-477.555 552.55,-473.372 556.5,-474 556.5,-474 556.5,-474 552.55,-473.372 557.066,-470.445 548.599,-472.743 548.599,-472.743"/>
<ellipse fill="none" stroke="black" cx="545.439" cy="-472.241" rx="3.2" ry="3.2"/>
</g>
<!-- dataset_source -->
<g id="node3" class="node"><title>dataset_source</title>
<g id="a_node3"><a xlink:href="../../tables/dataset_source.html" xlink:title="dataset_source" target="_top">
<polygon fill="#ffffff" stroke="none" points="561.5,-208 561.5,-314 695.5,-314 695.5,-208 561.5,-208"/>
<polygon fill="#f5f5f5" stroke="none" points="561.5,-292 561.5,-314 695.5,-314 695.5,-292 561.5,-292"/>
<polygon fill="none" stroke="black" points="561.5,-292 561.5,-314 695.5,-314 695.5,-292 561.5,-292"/>
<text text-anchor="start" x="566.5" y="-301.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">dataset_source</text>
<text text-anchor="start" x="656.5" y="-300.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="561.5,-270 561.5,-292 695.5,-292 695.5,-270 561.5,-270"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="566.5" y="-287"/>
<text text-anchor="start" x="582.5" y="-278.2" font-family="Helvetica,sans-Serif" font-size="11.00">dataset_ref</text>
<polygon fill="none" stroke="black" points="561.5,-248 561.5,-270 695.5,-270 695.5,-248 561.5,-248"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="566.5" y="-265"/>
<text text-anchor="start" x="582.5" y="-256.2" font-family="Helvetica,sans-Serif" font-size="11.00">classifier</text>
<polygon fill="#ffffff" stroke="none" points="561.5,-226 561.5,-248 695.5,-248 695.5,-226 561.5,-226"/>
<polygon fill="none" stroke="black" points="561.5,-226 561.5,-248 695.5,-248 695.5,-226 561.5,-226"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="566.5" y="-243"/>
<text text-anchor="start" x="582.5" y="-234.2" font-family="Helvetica,sans-Serif" font-size="11.00">source_dataset_ref</text>
<polygon fill="#ffffff" stroke="none" points="561.5,-208 561.5,-226 626.5,-226 626.5,-208 561.5,-208"/>
<polygon fill="none" stroke="black" points="561.5,-208 561.5,-226 626.5,-226 626.5,-208 561.5,-208"/>
<text text-anchor="start" x="564.5" y="-214.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="none" points="626.5,-208 626.5,-226 660.5,-226 660.5,-208 626.5,-208"/>
<polygon fill="none" stroke="black" points="626.5,-208 626.5,-226 660.5,-226 660.5,-208 626.5,-208"/>
<text text-anchor="start" x="650.5" y="-214.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="none" points="660.5,-208 660.5,-226 695.5,-226 695.5,-208 660.5,-208"/>
<polygon fill="none" stroke="black" points="660.5,-208 660.5,-226 695.5,-226 695.5,-208 660.5,-208"/>
<text text-anchor="start" x="685.5" y="-214.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- dataset_source&#45;&gt;dataset -->
<g id="edge4" class="edge"><title>dataset_source:dataset_ref:w&#45;&gt;dataset:id:e</title>
<path fill="none" stroke="black" d="M545.776,-281C533.782,-281 526.323,-281 509.5,-281"/>
<polygon fill="black" stroke="black" points="552.5,-281 560.5,-284.6 556.5,-281 560.5,-281 560.5,-281 560.5,-281 556.5,-281 560.5,-277.4 552.5,-281 552.5,-281"/>
<ellipse fill="none" stroke="black" cx="549.3" cy="-281" rx="3.2" ry="3.2"/>
</g>
<!-- dataset_source&#45;&gt;dataset -->
<g id="edge5" class="edge"><title>dataset_source:source_dataset_ref:w&#45;&gt;dataset:id:e</title>
<path fill="none" stroke="black" d="M546.411,-241.709C532.567,-253.06 533.356,-281 509.5,-281"/>
<polygon fill="black" stroke="black" points="552.913,-239.536 561.641,-240.414 556.706,-238.268 560.5,-237 560.5,-237 560.5,-237 556.706,-238.268 559.359,-233.586 552.913,-239.536 552.913,-239.536"/>
<ellipse fill="none" stroke="black" cx="549.878" cy="-240.55" rx="3.20001" ry="3.20001"/>
</g>
<!-- dataset_type&#45;&gt;metadata_type -->
<g id="edge6" class="edge"><title>dataset_type:metadata_type_ref:w&#45;&gt;metadata_type:id:e</title>
<path fill="none" stroke="black" d="M178.716,-159.201C163.971,-173.952 173.187,-215 145,-215"/>
<polygon fill="black" stroke="black" points="185.015,-156.824 193.771,-157.368 188.758,-155.412 192.5,-154 192.5,-154 192.5,-154 188.758,-155.412 191.229,-150.632 185.015,-156.824 185.015,-156.824"/>
<ellipse fill="none" stroke="black" cx="182.021" cy="-157.954" rx="3.20001" ry="3.20001"/>
</g>
</g>
</svg>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment