Entity Relationship Diagram (ERD)

This interactive diagram shows all tables and their relationships in datEAUbase schema.

Interactive ERD

The interactive version allows you to: - 🖱️ Drag tables to rearrange layout - 🔍 Zoom in/out for better visibility - 📐 Auto-layout to reorganize tables automatically - 💾 Export diagram as PNG

Open in new window{: target="_blank" .md-button .md-button--primary}

Legend

Field Markers

• PK badge: Primary Key - Unique identifier for each record
• FK badge: Foreign Key - Reference to another table's primary key
• * Required field (NOT NULL)

Relationship Notation

Relationships use standard crow's foot notation: - Single line (|): "One" side of relationship - Crow's foot (⟨): "Many" side of relationship

Relationship Types: - One-to-One: Single line on both ends (e.g., watershed ↔ hydrological_characteristics) - One-to-Many: Crow's foot on child side, single line on parent (e.g., site ↔ sampling_points) - Many-to-Many: Crow's foot on both ends (via junction tables like project_has_contact)

Table Count

The current schema contains 23 tables with 27 relationships.