---
config:
  theme: base
  look: handDrawn
---
erDiagram
direction TB
          soil_horizons {
        serial soil_horizon_id PK
        varchar site_visit_code FK
        smallint horizon_order
        decimal thickness_cm
        decimal depth_upper_cm
        decimal depth_lower_cm
        boolean depth_extend
        varchar horizon_primary_code FK
        varchar horizon_suffix_1_code FK
        varchar horizon_suffix_2_code FK
        varchar horizon_secondary_code FK
        varchar horizon_suffix_3_code FK
        varchar horizon_suffix_4_code FK
        varchar texture_code FK
        decimal clay_percent
        decimal total_coarse_fragment_percent
        decimal gravel_percent
        decimal cobble_percent
        decimal stone_percent
        decimal boulder_percent
        varchar structure_code FK
        varchar matrix_hue_code FK
        decimal matrix_value
        smallint matrix_chroma
        varchar nonmatrix_feature_code FK
        varchar nonmatrix_hue_code FK
        decimal nonmatrix_value
        smallint nonmatrix_chroma
    }

    soil_horizons }o--|| site_visit : site_visit_code
    soil_horizons }o..|| soil_horizon_type : horizon_primary_code
    soil_horizons }o..|| soil_horizon_suffix : horizon_suffix_1_code
    soil_horizons }o..|| soil_horizon_suffix : horizon_suffix_2_code
    soil_horizons }o..|| soil_horizon_type : horizon_secondary_code
    soil_horizons }o..|| soil_horizon_suffix : horizon_suffix_3_code
    soil_horizons }o..|| soil_horizon_suffix : horizon_suffix_4_code
    soil_horizons }o..|| soil_texture : texture_code
    soil_horizons }o..|| soil_structure : structure_code
    soil_horizons }o..|| soil_hue : matrix_hue_code
    soil_horizons }o..|| soil_nonmatrix_features : nonmatrix_feature_code
    soil_horizons }o..|| soil_hue : nonmatrix_hue_code