---
config:
  theme: base
  look: handDrawn
---
erDiagram
direction TB
        environment {
    serial environment_id PK
    varchar site_visit_code FK
    smallint physiography_id FK
    smallint geomorphology_id FK
    smallint macrotopography_id FK
    smallint microtopography_id FK
    decimal microrelief_cm
    smallint drainage_id FK
    smallint moisture_id FK
    decimal depth_water_cm
    decimal depth_moss_duff_cm
    decimal depth_restrictive_layer_cm
    smallint restrictive_type_id FK
    smallint disturbance_id FK
    smallint disturbance_severity_id FK
    smallint disturbance_time_y
    boolean surface_water
    smallint soil_class_id FK
    boolean cryoturbation
    varchar dominant_texture_40_cm_code FK
    decimal depth_15_percent_coarse_fragments_cm
    }

    environment }o--|| site_visit : site_visit_code
    environment }o..|| physiography : physiography_id
    environment }o..|| geomorphology : geomorphology_id
    environment }o..|| macrotopography : macrotopography_id
    environment }o..|| microtopography : microtopography_id
    environment }o..|| drainage : drainage_id
    environment }o..|| moisture : moisture_id
    environment }o..|| restrictive_type : restrictive_type_id
    environment }o..|| disturbance : disturbance_id
    environment }o..|| disturbance_severity : disturbance_severity_id
    environment }o..|| soil_class : soil_class_id
    environment }o..|| soil_texture : dominant_texture_40_cm_code