diff --git a/sql/clusters.dot b/sql/clusters.dot index 9bda3bc7..2fb7eb7c 100644 --- a/sql/clusters.dot +++ b/sql/clusters.dot @@ -1,85 +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 + # "rtcolN" identifies the N-th row (1-based) in a table, as a source + # "ltcolN" identifies the N-th row (1-based) 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_dir":ltcol2 -> "directory":rtcol1; "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":ltcol7 -> "directory":rtcol1; "revision_history":rtcol2 -> "revision":ltcol1; } }