CA data

WIP CA schema diagram

Not fully complete nor (likely) correct

erDiagram

    RAPlots{
        string AdjAlliance1
        string AdjAlliance2
        string AdjAlliance3
        string Alternative_ID
        int Aspect_actual
        string Aspect_gen
        int AspectNum
        float Bare_fines
        float BasalStem
        string BaseID
        float Bedrock
        float Bioturbation_current
        string Bioturbation_past
        float Boulders
        float Cobbles
        string CodeGeology
        string Confidence_Explain
        string Confidence_ID
        int ConfidentialityStatus
        float Conif_cover
        int Conif_ht
        string Conif_ht2
        string DesertRip
        int Elevation
        datetime Entry_date
        string Entry_name "**Required**"
        datetime Entry_time
        float ErrorMeasurement
        string ErrorUnits
        string Field_alliance
        string Field_assocn
        string FireEvidence
        string ft_mElevation
        string GPS_datum
        boolean GPS_in_stand
        string GPS_name
        int GPSshiftDeg
        int GPSshiftInclination
        float GPSshiftM
        float Gravels
        float Hdwd_cover
        int Hdwd_ht
        string Hdwd_ht2
        float Herb_cover
        int Herb_ht
        string Herb_ht2
        string Herbaceous
        float Hoof_punch
        string ID_or_mapping_info
        float Litter
        string Location_name
        int MacroNum
        string MacroTopo
        int MicroNum
        string MicroTopo
        float NonVasc_Veg_cover
        string PalmJoshua
        string Phen_Gr
        string Phen_Sh
        string Phen_Tr
        string Photos_Ordinals
        string Photos_Other
        string PlotArea
        string PlotOther1
        string PlotOther2
        string PlotOther3
        string PlotOther4
        string PlotOther5
        string PlotOther6
        float PlotOther7
        int PlotOther8
        string PlotShape
        string ProjectCode FK
        boolean QC
        datetime QC_date
        float RegenTree_cover
        int RegenTree_ht
        string RegenTree_ht2
        string Shrub
        float Shrub_cover
        int Shrub_ht
        string Shrub_ht2
        string Site_history
        int Slope_actual
        string Slope_gen
        int SlopeNum
        string Soil
        string Soil_text
        int SoilNum
        string Stand_ID "**Required**"
        string Stand_Size
        int StandSizeNum
        float Stones
        string Substrate
        int SubstrateNum
        string Survey_Type
        datetime SurveyDate
        string SurveyDimensions
        string SurveyID PK "**Required**"
        string Surveyors
        string TrackingNotes
        string Tree
        float UnderTree_cover
        int UnderTree_ht
        string UnderTree_ht2
        string Unusual_spp
        datetime Update_date
        string Update_name
        string Upl_Wet_text
        int Upl_Wetland
        string UTM_zone
        int UTME
        int UTME_final
        int UTMN
        int UTMN_final
        float Veg_cover
        int ViewRadius
        int W_Axis_Bearing
        string W_Axis_Size
        float Water
        string Waypoint
    }

    RAPlants{
        boolean Changed
        string CodeSpecies
        string Collection
        string CurrPlantsSymbol
        string Notes
        int RAPlantsID PK "**Required**"
        Single Species_cover
        string Species_name
        string SpeciesName
        string Stratum
        string SurveyID FK "**Required**"
    }
    RAPlots ||--|| RAPlants : SurveyID

    SurveyPlants{
        boolean Changed
        string CodeSpecies
        string Collection
        string CurrPlantsSymbol
        string Notes
        Single Species_cover
        string Species_name
        string SpeciesName
        string Stratum
        string SurveyID FK "**Required**"
    }
    RAPlots ||--|| SurveyPlants : SurveyID

    RAImpacts{
        string SurveyID FK
        int CodeImpact
        int Intensity "**Required**"
        string Other
        int RAImpactsID PK "**Required**"
    }
    RAPlots ||--|| RAImpacts : SurveyID

    RAProjects{
        string ProjectCode PK "**Required**"
        string ProjectName
        string ProjectDescription
        datetime ProjectStartDate
        datetime ProjectEndDate
        string Type of protocols
        string DataContactName
        string DataContactOrganization
        string DataContactEmail
        string DataContactPhone
        string DataContactRole
        string DataContactName2
        string DataContactOrganization2
        string DataContactEmail2
        string DataContactPhone2
        string DataContactRole2
        string DataContactName3
        string DataContactOrganization3
        string DataContactEmail3
        string DataContactPhone3
        string DataContactRole3
        string ClassificationTool
        string ClassificationDescription
        string ClassificationContents
        string Additional_IDdesc
        string PlotOther1desc
        string PlotOther2desc
        string PlotOther3desc
        string PlotOther4desc
        string PlotOther5desc
        string PlotOther6desc
        string PlotOther7desc
        string PlotOther8desc
        string LinkToDocumentation
        string LinkToDocumentation2
        string LinkToDocumentation3
        string PlantStrataDescription
        string PlantClassDescription
        string StrataDescription
        string StrataClassDescription
    }
    RAPlots }|--o| RAProjects : ProjectCode

    RAClassification{
        string Alliance
        string AnalysisID
        string Association
        string CaCode
        string ClassificationLevel
        string ClassificationMethod
        string NVCAboveAlliance
        string ProjectCode FK "(Classification Code)"
        int RAClassificationID PK "**Required**"
        string ReportAlliance
        string ReportAssociation
        string ReportOtherName
        string SurveyID FK "**Required**"
    }
    RAPlots }|--o| RAClassification : SurveyID
    RAClassification }|--o| RAProjects : ProjectCode

    SurveyPoints{
        int Aspect_actual
        string BaseID "**Required**"
        int Bearing "**Required**"
        string CaCode "**Required**"
        string ClassCode "**Required**"
        string ClassificationMethod "**Required**"
        float ConCov
        string Conif_ht_txt
        int Distance "**Required**"
        int Elevation_m
        float ErrorMeasurement
        string ErrorUnits
        text ExoticLevel
        Integer Exotics
        string FieldAlliance "**Required**"
        string FieldAssociation
        int FieldMapCode
        string GPS_Name
        string Hdwd_ht_txt
        float HdwdCov
        string Herb_ht_txt
        string Herbaceous
        float HerbCov
        string Hierarchy
        string ID_Loc_ckd
        int Inclination "**Required**"
        string Location_name "**Required**"
        string MacroTopo
        string MCVAlliance
        string MCVGroup
        string MCVLevel "**Required**"
        string MCVMacrogroup
        string MCVName "**Required**"
        string MicroTopo
        string Notes
        int OBJECTID
        string PermissionQCer "**Required**"
        string PermissionSource "**Required**"
        string Phen_He
        string Phen_Sh
        string Phen_Tr
        string PHOTO
        string PhotoDesc
        string PlotOther1
        float PlotOther7
        int PlotOther8
        string ProjectCode FK "**Required** Is this an FK?"
        string Projected "**Required**"
        string PubStatus "**Required**"
        string RegenTr_ht_txt
        float RegenTreeCov
        object Shape
        string Shrub
        string Shrub_ht_txt
        float ShrubCov
        string Site_history
        int Slope_actual
        string Soil_text
        string Stand_Size
        int StandSizeNum
        string Substrate
        datetime SurveyDate "**Required**"
        string SurveyDimensions
        string SurveyID FK "**Required** Is this an FK?"
        string Surveyors
        string SurveyType "**Required**"
        float TotalVegCov
        string Tree
        string Tree_ht_txt
        float TreeCov
        string UID PK "Is this actually the PK??"
        string Upl_Wet_text
        int UTM_E
        int UTM_N
        int UTM_zone
        int ViewPercent
        int ViewRadius
    }
    SurveyPoints }|--o| RAPlots : SurveyID
    SurveyPoints }|--o| RAProjects : ProjectCode

Loading