digraph {
graph [pad="0.5", nodesep=".5", ranksep="3" fontname = "arial"];
node [shape=plain fontname = "arial" fontsize=14]
edge [arrowhead=crow fontname = "arial"]
rankdir=LR;
splines=polylines;
su [label=<
su |
id (int, PK) |
creator (text) |
site (text, gets values dynamically from sites.name) |
name (text, no dupl., id fld) |
type (text, closed vocabulary) |
description (text) |
>];
sites [label=<
sites |
id (int, PK) |
creator (text) |
name (text, no dupl., id fld) |
typology (text, closed vocabulary) |
chronology (text, closedvocabulary) |
description (text) |
>];
bibliography [label=<
bibliography |
id (int, PK) |
creator (text) |
short (text, no dupl., id fld) |
author (text) |
title (text) |
year (int|date) |
publishedin (text) |
>];
m_citations [label=<
m_citations |
id (int, PK) |
table_link (text, FK) |
id_link (text, FK) |
short (text, gets values dynamically from bibliography.short) |
pages (text) |
notes (text) |
>];
m_samples [label=<
m_samples |
id (int, PK) |
table_link (text, FK) |
id_link (text, FK) |
datetaken (text) |
analysis (text) |
notes (text) |
>];
sites:1 -> su:1;
sites:4 -> su:4 [ color=lightcoral arrowhead="none" ];
su:1 -> m_samples:1;
su:1 -> m_samples:3 [ color=lightcoral arrowhead="none" ];
su:2 -> m_samples:4 [ color=lightcoral arrowhead="none" ];
sites:1 -> m_citations:1;
sites:1 -> m_citations:3 [ color=lightcoral arrowhead="none" ];
sites:2 -> m_citations:4 [ color=lightcoral arrowhead="none" ];
su:1 -> m_citations:1;
su:1 -> m_citations:3 [ color=lightcoral arrowhead="none" ];
su:2 -> m_citations:4 [ color=lightcoral arrowhead="none" ];
bibliography:1 -> m_citations:1;
bibliography :4-> m_citations:5 [ color=lightcoral arrowhead="none" ];
}