ERD for USDA Census and Survey Data

To view this diagram, open the Command Palette (Cmd+Shift+P on Mac or Ctrl+Shift+P on Windows/Linux) and run "Markdown: Open Preview to the Side".

erDiagram
CensusRecord {
    integer year
    CropEnum crop
    VariableEnum variable
    UnitEnum unit
    float value
    BearingStatusEnum bearing_status
    string class_desc
    string domain_desc
    string source
    string notes
}
Geography {
    string state_name
    string state_fips
    string county_name
    string county_fips
    string geoid
    string region_name
    string agg_level_desc
}
SurveyRecord {
    string period_desc
    string freq_desc
    string program_desc
    integer year
    CropEnum crop
    VariableEnum variable
    UnitEnum unit
    float value
    BearingStatusEnum bearing_status
    string class_desc
    string domain_desc
    string source
    string notes
}
UsdaRecord {
    integer year
    CropEnum crop
    VariableEnum variable
    UnitEnum unit
    float value
    BearingStatusEnum bearing_status
    string class_desc
    string domain_desc
    string source
    string notes
}

CensusRecord ||--|o Geography : "geography"
SurveyRecord ||--|o Geography : "geography"
UsdaRecord ||--|o Geography : "geography"