diff --git a/sql/clusters.dot b/sql/clusters.dot index 8e8408f..9bda3bc 100644 --- a/sql/clusters.dot +++ b/sql/clusters.dot @@ -1,81 +1,85 @@ subgraph "logical_grouping" { style = rounded; bgcolor = gray95; color = gray; subgraph cluster_meta { label = <schema versioning
version: @@VERSION@@>; dbversion; } subgraph cluster_content { label = <content>; content; skipped_content; } subgraph cluster_directory { label = <directories>; directory; directory_entry_dir; directory_entry_file; directory_entry_rev; } subgraph cluster_revision { label = <revisions>; revision; revision_history; person; } subgraph cluster_release { label = <releases>; release; } subgraph cluster_snapshots { label = <snapshots>; snapshot; snapshot_branch; snapshot_branches; } subgraph cluster_origins { label = <origins>; origin; fetch_history; origin_visit; } subgraph cluster_metadata { label = <metadata>; metadata_provider; origin_metadata; tool; } subgraph cluster_statistics { label = <statistics>; object_counts; object_counts_bucketed; } { edge [style = dashed]; # "rtcolN" identifies the N-th row in a table, as a source # "ltcolN" identifies the N-th row in a table, as a destination + "snapshot_branch":rtcol3 -> "release":ltcol1; + "snapshot_branch":rtcol3 -> "revision":ltcol1; + "snapshot_branch":rtcol3 -> "directory":ltcol1; + "snapshot_branch":rtcol3 -> "content":ltcol2; "directory_entry_dir":rtcol2 -> "directory":ltcol1; "directory_entry_file":rtcol2 -> "content":ltcol2; "directory_entry_file":rtcol2 -> "skipped_content":ltcol2; "directory_entry_rev":rtcol2 -> "revision":ltcol1; "directory":rtcol2 -> "directory_entry_dir":ltcol1; "directory":rtcol3 -> "directory_entry_file":ltcol1; "directory":rtcol4 -> "directory_entry_rev":ltcol1; "release":rtcol2 -> "revision":ltcol1; "revision":rtcol7 -> "directory":ltcol1; "revision_history":rtcol2 -> "revision":ltcol1; } }