diff --git a/sql/clusters.dot b/sql/clusters.dot index ecc1b7189..e8f75e48e 100644 --- a/sql/clusters.dot +++ b/sql/clusters.dot @@ -1,99 +1,95 @@ 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>; occurrence; occurrence_history; + snapshot; + snapshot_branch; + snapshot_branches; } subgraph cluster_origins { label = <origins>; origin; fetch_history; origin_visit; } subgraph cluster_entity { label = <entities>; entity; entity_history; entity_equivalence; listable_entity; list_history; } - subgraph cluster_provenance { - label = <provenance>; - cache_revision_origin; - cache_content_revision; - cache_content_revision_processed; + subgraph cluster_metadata { + label = <metadata>; + metadata_provider; + origin_metadata; + tool; + } + + subgraph cluster_statistics { + label = <statistics>; + object_counts; } { 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 "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; "occurrence":rtcol3 -> "revision":ltcol1; "occurrence_history":rtcol3 -> "revision":ltcol1; "release":rtcol2 -> "revision":ltcol1; "revision":rtcol9 -> "directory":ltcol1; "revision_history":rtcol2 -> "revision":ltcol1; "entity_history":rtcol3 -> "entity_history":ltcol2; "entity_history":rtcol10 -> "listable_entity":ltcol1; } - - subgraph cluster_metadata { - label = <metadata>; - content_metadata; - revision_metadata; - } - - subgraph cluster_statistics { - label = <statistics>; - object_counts; - } - }