---
config:
  theme: base
  look: handDrawn
---
erDiagram
direction TB
        site {
        varchar site_code PK
        varchar establishing_project_code FK
        smallint perspective_id FK
        smallint cover_method_id FK
        smallint plot_dimensions_id FK
        integer h_datum_epsg FK
        decimal latitude_dd
        decimal longitude_dd
        decimal h_error_m
        smallint positional_accuracy_id FK
        smallint location_type_id FK
    }
    site }o--|| project : establishing_project_code
    site }o--|| perspective : perspective_id
    site }o--|| cover_method : cover_method_id
    site }o--|| plot_dimensions : plot_dimensions_id
    site }o--|| h_datum : h_datum_epsg
    site }o--|| positional_accuracy : positional_accuracy_id
    site }o--|| location_type : location_type_id