schema_erd.dot

digraph ERD {
  graph [rankdir=LR, splines=ortho];
  node [shape=record, fontname="Helvetica"];
  edge [fontname="Helvetica"];

  "NMA_Chemistry_SampleInfo" [label="{NMA_Chemistry_SampleInfo|* SamplePtID: UUID (not null)\lWCLab_ID: VARCHAR(18) (nullable)\lSamplePointID: VARCHAR(10) (not null)\lCollectionDate: DATETIME (nullable)\lCollectionMethod: VARCHAR(50) (nullable)\lCollectedBy: VARCHAR(5) (nullable)\lAnalysesAgency: VARCHAR(50) (nullable)\lSampleType: VARCHAR(50) (nullable)\lSampleMaterialNotH2O: VARCHAR(100) (nullable)\lWaterType: VARCHAR(50) (nullable)\lStudySample: TEXT (nullable)\lDataSource: VARCHAR(100) (nullable)\lDataQuality: BOOLEAN (nullable)\lPublicRelease: BOOLEAN (nullable)\lAddedDaytoDate: BOOLEAN (nullable)\lAddedMonthDaytoDate: BOOLEAN (nullable)\lSampleNotes: TEXT (nullable)\lOBJECTID: INTEGER (nullable)\lLocationId: UUID (nullable)\l}"];
  "NMA_SurfaceWaterData" [label="{NMA_SurfaceWaterData|SurfaceID: UUID (not null)\lPointID: VARCHAR(10) (not null)\l* OBJECTID: INTEGER (not null)\lDischarge: VARCHAR(50) (nullable)\lDischargeMethod: VARCHAR(50) (nullable)\lDischargeRate: FLOAT (nullable)\lDischargeUnits: VARCHAR(3) (nullable)\lDateMeasured: DATETIME (nullable)\lDischargeSource: VARCHAR(50) (nullable)\lSiteNotes: VARCHAR(200) (nullable)\lFieldMethodNotes: VARCHAR(200) (nullable)\lFormationZone: VARCHAR(15) (nullable)\lAqClass: VARCHAR(50) (nullable)\lSourceNotes: VARCHAR(200) (nullable)\lDataSource: VARCHAR(255) (nullable)\l}"];
  "NMA_WaterLevelsContinuous_Pressure_Daily" [label="{NMA_WaterLevelsContinuous_Pressure_Daily|* GlobalID: VARCHAR(40) (not null)\lOBJECTID: INTEGER (nullable)\lWellID: VARCHAR(40) (nullable)\lPointID: VARCHAR(50) (nullable)\lDateMeasured: DATETIME (not null)\lTemperatureWater: FLOAT (nullable)\lWaterHead: FLOAT (nullable)\lWaterHeadAdjusted: FLOAT (nullable)\lDepthToWaterBGS: FLOAT (nullable)\lMeasurementMethod: VARCHAR(2) (nullable)\lDataSource: VARCHAR(5) (nullable)\lMeasuringAgency: VARCHAR(50) (nullable)\lQCed: BOOLEAN (nullable)\lNotes: VARCHAR(100) (nullable)\lCreated: DATETIME (not null)\lUpdated: DATETIME (not null)\lProcessedBy: VARCHAR(4) (nullable)\lCheckedBy: VARCHAR(4) (nullable)\lCONDDL (mS/cm): FLOAT (nullable)\l}"];
  "NMA_WeatherData" [label="{NMA_WeatherData|LocationId: UUID (nullable)\lPointID: VARCHAR(10) (not null)\lWeatherID: UUID (nullable)\l* OBJECTID: INTEGER (not null)\l}"];
  "NMA_view_NGWMN_Lithology" [label="{NMA_view_NGWMN_Lithology|* OBJECTID: INTEGER (not null)\lPointID: VARCHAR(50) (not null)\lLithology: VARCHAR(50) (nullable)\lTERM: VARCHAR(100) (nullable)\lStratSource: VARCHAR(100) (nullable)\lStratTop: FLOAT (nullable)\lStratTopUnit: VARCHAR(20) (nullable)\lStratBottom: FLOAT (nullable)\lStratBottomUnit: VARCHAR(20) (nullable)\l}"];
  "NMA_view_NGWMN_WaterLevels" [label="{NMA_view_NGWMN_WaterLevels|* PointID: VARCHAR(50) (not null)\l* DateMeasured: DATE (not null)\lDepthToWaterBGS: FLOAT (nullable)\lWLUnits: VARCHAR(10) (nullable)\lMeasurementMethod: VARCHAR(50) (nullable)\lWLAccuracy: FLOAT (nullable)\lPublicRelease: BOOLEAN (nullable)\l}"];
  "NMA_view_NGWMN_WellConstruction" [label="{NMA_view_NGWMN_WellConstruction|* id: INTEGER (not null)\lPointID: VARCHAR(50) (not null)\lCasingTop: FLOAT (nullable)\lCasingBottom: FLOAT (nullable)\lCasingDepthUnits: VARCHAR(20) (nullable)\lScreenTop: FLOAT (nullable)\lScreenBottom: FLOAT (nullable)\lScreenBottomUnit: VARCHAR(20) (nullable)\lScreenDescription: VARCHAR(250) (nullable)\lCasingDescription: VARCHAR(250) (nullable)\l}"];
  "address" [label="{address|+ contact_id: INTEGER (not null)\laddress_line_1: VARCHAR(255) (not null)\laddress_line_2: VARCHAR(255) (nullable)\lcity: VARCHAR(100) (not null)\lstate: VARCHAR(50) (not null)\lpostal_code: VARCHAR(20) (not null)\lcountry: VARCHAR(50) (not null)\l+ address_type: VARCHAR(100) (not null)\lsearch_vector: TSVECTOR (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "analysis_method" [label="{analysis_method|analysis_method_code: VARCHAR (nullable)\lanalysis_method_name: VARCHAR (not null)\l+ analysis_method_type: VARCHAR(100) (nullable)\l+ source_organization: VARCHAR(100) (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "aquifer_system" [label="{aquifer_system|name: VARCHAR (not null)\ldescription: TEXT (nullable)\l+ primary_aquifer_type: VARCHAR(100) (not null)\l+ geographic_scale: VARCHAR(100) (nullable)\lboundary: geometry(MULTIPOLYGON,4326) (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "aquifer_system_version" [label="{aquifer_system_version|name: VARCHAR (nullable)\ldescription: TEXT (nullable)\lprimary_aquifer_type: VARCHAR(100) (nullable)\lgeographic_scale: VARCHAR(100) (nullable)\lboundary: geometry(MULTIPOLYGON,4326) (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (nullable) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\lrelease_status: VARCHAR(100) (nullable)\l* transaction_id: BIGINT (not null)\lend_transaction_id: BIGINT (nullable)\loperation_type: SMALLINT (not null)\l}"];
  "aquifer_type" [label="{aquifer_type|+ thing_aquifer_association_id: INTEGER (not null)\l+ aquifer_type: VARCHAR(100) (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "asset" [label="{asset|name: VARCHAR (not null)\llabel: VARCHAR (nullable)\lstorage_service: VARCHAR (not null)\lstorage_path: VARCHAR (not null)\lmime_type: VARCHAR (not null)\lsize: INTEGER (not null)\luri: VARCHAR (not null)\lsearch_vector: TSVECTOR (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "asset_thing_association" [label="{asset_thing_association|+ asset_id: INTEGER (not null)\l+ thing_id: INTEGER (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l}"];
  "collaborative_network_well" [label="{collaborative_network_well|actively_monitored: BOOLEAN (not null)\l+ thing_id: INTEGER (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l}"];
  "contact" [label="{contact|name: VARCHAR(100) (nullable)\l+ organization: VARCHAR(100) (nullable)\l+ role: VARCHAR(100) (not null)\l+ contact_type: VARCHAR(100) (not null)\lnma_pk_owners: VARCHAR(100) (nullable)\lnma_pk_waterlevels: VARCHAR(100) (nullable)\lsearch_vector: TSVECTOR (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "data_provenance" [label="{data_provenance|target_id: INTEGER (not null)\ltarget_table: VARCHAR (not null)\lfield_name: VARCHAR (nullable)\l+ origin_type: VARCHAR(100) (nullable)\lorigin_source: VARCHAR (nullable)\l+ collection_method: VARCHAR(100) (nullable)\laccuracy_value: FLOAT (nullable)\l+ accuracy_unit: VARCHAR(100) (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "deployment" [label="{deployment|+ thing_id: INTEGER (not null)\l+ sensor_id: INTEGER (not null)\linstallation_date: DATE (not null)\lremoval_date: DATE (nullable)\lrecording_interval: INTEGER (nullable)\l+ recording_interval_units: VARCHAR(100) (nullable)\lhanging_cable_length: NUMERIC (nullable)\lhanging_point_height: NUMERIC (nullable)\lhanging_point_description: TEXT (nullable)\lnotes: TEXT (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "email" [label="{email|+ contact_id: INTEGER (not null)\lemail: VARCHAR(100) (not null)\l+ email_type: VARCHAR(100) (not null)\lsearch_vector: TSVECTOR (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "field_activity" [label="{field_activity|+ field_event_id: INTEGER (not null)\l+ activity_type: VARCHAR(100) (not null)\lnotes: VARCHAR (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "field_event" [label="{field_event|+ thing_id: INTEGER (not null)\levent_date: DATETIME (not null)\lnotes: VARCHAR (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "field_event_participant" [label="{field_event_participant|+ field_event_id: INTEGER (not null)\l+ contact_id: INTEGER (not null)\l+ participant_role: VARCHAR(100) (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "geochronology_age" [label="{geochronology_age|location_id: INTEGER (not null)\lage: FLOAT (not null)\lage_error: FLOAT (nullable)\l+ method: VARCHAR(100) (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l}"];
  "geologic_formation" [label="{geologic_formation|+ formation_code: VARCHAR(100) (nullable)\ldescription: TEXT (nullable)\l+ lithology: VARCHAR(100) (nullable)\lboundary: geometry(MULTIPOLYGON,4326) (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "geologic_formation_version" [label="{geologic_formation_version|formation_code: VARCHAR(100) (nullable)\ldescription: TEXT (nullable)\llithology: VARCHAR(100) (nullable)\lboundary: geometry(MULTIPOLYGON,4326) (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (nullable) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\lrelease_status: VARCHAR(100) (nullable)\l* transaction_id: BIGINT (not null)\lend_transaction_id: BIGINT (nullable)\loperation_type: SMALLINT (not null)\l}"];
  "group" [label="{group|name: VARCHAR(100) (not null)\ldescription: VARCHAR(255) (nullable)\lproject_area: geometry(MULTIPOLYGON,4326) (nullable)\l+ group_type: VARCHAR(100) (nullable)\l+ parent_group_id: INTEGER (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "group_thing_association" [label="{group_thing_association|+ group_id: INTEGER (not null)\l+ thing_id: INTEGER (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l}"];
  "incomplete_nma_phone" [label="{incomplete_nma_phone|+ contact_id: INTEGER (not null)\lphone_number: VARCHAR(20) (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l}"];
  "lexicon_category" [label="{lexicon_category|name: VARCHAR(100) (not null)\ldescription: VARCHAR(255) (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l}"];
  "lexicon_term" [label="{lexicon_term|term: VARCHAR (not null)\ldefinition: VARCHAR (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l}"];
  "lexicon_term_category_association" [label="{lexicon_term_category_association|+ term_id: INTEGER (not null)\l+ category_id: INTEGER (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l}"];
  "lexicon_triple" [label="{lexicon_triple|+ subject: VARCHAR(100) (not null)\lpredicate: VARCHAR(100) (not null)\l+ object_: VARCHAR(100) (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l}"];
  "location" [label="{location|nma_pk_location: VARCHAR(36) (nullable)\ldescription: VARCHAR (nullable)\lpoint: geometry(POINT,4326) (not null)\lelevation: FLOAT (not null)\lcounty: VARCHAR(100) (nullable)\lstate: VARCHAR(100) (nullable)\lquad_name: VARCHAR(100) (nullable)\lnma_notes_location: TEXT (nullable)\lnma_coordinate_notes: TEXT (nullable)\lnma_date_created: DATE (nullable)\lnma_site_date: DATE (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "location_thing_association" [label="{location_thing_association|* + location_id: INTEGER (not null)\l* + thing_id: INTEGER (not null)\leffective_start: DATETIME (not null) default=timezone(:timezone_1, now())\leffective_end: DATETIME (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l}"];
  "location_version" [label="{location_version|nma_pk_location: VARCHAR(36) (nullable)\ldescription: VARCHAR (nullable)\lpoint: geometry(POINT,4326) (not null)\lelevation: FLOAT (nullable)\lcounty: VARCHAR(100) (nullable)\lstate: VARCHAR(100) (nullable)\lquad_name: VARCHAR(100) (nullable)\lnma_notes_location: TEXT (nullable)\lnma_coordinate_notes: TEXT (nullable)\lnma_date_created: DATE (nullable)\lnma_site_date: DATE (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (nullable) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\lrelease_status: VARCHAR(100) (nullable)\l* transaction_id: BIGINT (not null)\lend_transaction_id: BIGINT (nullable)\loperation_type: SMALLINT (not null)\l}"];
  "measuring_point_history" [label="{measuring_point_history|+ thing_id: INTEGER (not null)\lmeasuring_point_height: NUMERIC (not null)\lmeasuring_point_description: TEXT (nullable)\lstart_date: DATE (not null)\lend_date: DATE (nullable)\lreason: TEXT (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "monitoring_frequency_history" [label="{monitoring_frequency_history|+ thing_id: INTEGER (not null)\l+ monitoring_frequency: VARCHAR(100) (not null)\lstart_date: DATE (not null)\lend_date: DATE (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "notes" [label="{notes|target_id: INTEGER (not null)\ltarget_table: VARCHAR (not null)\l+ note_type: VARCHAR(100) (not null)\lcontent: TEXT (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "observation" [label="{observation|nma_pk_waterlevels: VARCHAR (nullable)\l+ sample_id: INTEGER (not null)\l+ sensor_id: INTEGER (nullable)\l+ analysis_method_id: INTEGER (nullable)\l+ parameter_id: INTEGER (not null)\lobservation_datetime: DATETIME (not null)\lvalue: FLOAT (nullable)\l+ unit: VARCHAR(100) (not null)\lnotes: VARCHAR (nullable)\lmeasuring_point_height: FLOAT (nullable)\l+ groundwater_level_reason: VARCHAR(100) (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "observation_version" [label="{observation_version|nma_pk_waterlevels: VARCHAR (nullable)\lsample_id: INTEGER (nullable)\lsensor_id: INTEGER (nullable)\lanalysis_method_id: INTEGER (nullable)\lparameter_id: INTEGER (nullable)\lobservation_datetime: DATETIME (nullable)\lvalue: FLOAT (nullable)\lunit: VARCHAR(100) (nullable)\lnotes: VARCHAR (nullable)\lmeasuring_point_height: FLOAT (nullable)\lgroundwater_level_reason: VARCHAR(100) (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (nullable) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\lrelease_status: VARCHAR(100) (nullable)\l* transaction_id: BIGINT (not null)\lend_transaction_id: BIGINT (nullable)\loperation_type: SMALLINT (not null)\l}"];
  "parameter" [label="{parameter|+ parameter_name: VARCHAR(100) (not null)\l+ matrix: VARCHAR(100) (not null)\l+ parameter_type: VARCHAR(100) (nullable)\lcas_number: VARCHAR (nullable)\l+ default_unit: VARCHAR(100) (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "parameter_version" [label="{parameter_version|parameter_name: VARCHAR(100) (nullable)\lmatrix: VARCHAR(100) (nullable)\lparameter_type: VARCHAR(100) (nullable)\lcas_number: VARCHAR (nullable)\ldefault_unit: VARCHAR(100) (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (nullable) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\lrelease_status: VARCHAR(100) (nullable)\l* transaction_id: BIGINT (not null)\lend_transaction_id: BIGINT (nullable)\loperation_type: SMALLINT (not null)\l}"];
  "permission_history" [label="{permission_history|+ contact_id: INTEGER (not null)\l+ permission_type: VARCHAR(100) (not null)\lpermission_allowed: BOOLEAN (not null)\lstart_date: DATE (not null)\lend_date: DATE (nullable)\lnotes: VARCHAR (nullable)\ltarget_id: INTEGER (not null)\ltarget_table: VARCHAR(50) (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "phone" [label="{phone|+ contact_id: INTEGER (not null)\lphone_number: VARCHAR(20) (not null)\l+ phone_type: VARCHAR(100) (not null)\lsearch_vector: TSVECTOR (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "pub_author" [label="{pub_author|name: VARCHAR (not null)\laffiliation: VARCHAR (nullable)\lsearch_vector: TSVECTOR (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l}"];
  "pub_author_contact_association" [label="{pub_author_contact_association|* + author_id: INTEGER (not null)\l* + contact_id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l}"];
  "pub_author_publication_association" [label="{pub_author_publication_association|* + publication_id: INTEGER (not null)\l* + author_id: INTEGER (not null)\lauthor_order: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l}"];
  "publication" [label="{publication|title: TEXT (not null)\labstract: TEXT (nullable)\ldoi: VARCHAR (nullable)\lyear: INTEGER (nullable)\lpublisher: VARCHAR (nullable)\lurl: VARCHAR (nullable)\l+ publication_type: VARCHAR(100) (not null)\lsearch_vector: TSVECTOR (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l}"];
  "regulatory_limit" [label="{regulatory_limit|+ parameter_id: INTEGER (not null)\l+ limit_source: VARCHAR(100) (not null)\llimit_value: NUMERIC (not null)\l+ limit_unit: VARCHAR(100) (not null)\l+ limit_type: VARCHAR(100) (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "regulatory_limit_version" [label="{regulatory_limit_version|parameter_id: INTEGER (nullable)\llimit_source: VARCHAR(100) (nullable)\llimit_value: NUMERIC (nullable)\llimit_unit: VARCHAR(100) (nullable)\llimit_type: VARCHAR(100) (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (nullable) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\lrelease_status: VARCHAR(100) (nullable)\l* transaction_id: BIGINT (not null)\lend_transaction_id: BIGINT (nullable)\loperation_type: SMALLINT (not null)\l}"];
  "sample" [label="{sample|+ field_activity_id: INTEGER (not null)\l+ field_event_participant_id: INTEGER (nullable)\lsample_date: DATETIME (not null)\lsample_name: VARCHAR (not null)\l+ sample_matrix: VARCHAR(100) (not null)\l+ sample_method: VARCHAR(100) (not null)\lqc_type: VARCHAR (not null)\ldepth_top: FLOAT (nullable)\ldepth_bottom: FLOAT (nullable)\lnotes: VARCHAR (nullable)\lnma_pk_waterlevels: VARCHAR (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "sensor" [label="{sensor|nma_pk_equipment: VARCHAR(36) (nullable)\lname: VARCHAR(255) (not null)\l+ sensor_type: VARCHAR(100) (not null)\lmodel: VARCHAR(50) (nullable)\lserial_no: VARCHAR(50) (nullable)\lpcn_number: VARCHAR(50) (nullable)\l+ owner_agency: VARCHAR(100) (nullable)\l+ sensor_status: VARCHAR(100) (nullable)\lnotes: TEXT (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "status_history" [label="{status_history|+ status_type: VARCHAR(100) (not null)\l+ status_value: VARCHAR(100) (not null)\lstart_date: DATE (not null)\lend_date: DATE (nullable)\lreason: TEXT (nullable)\ltarget_id: INTEGER (not null)\ltarget_table: VARCHAR(50) (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "thing" [label="{thing|nma_pk_welldata: VARCHAR (nullable)\lname: VARCHAR (not null)\l+ thing_type: VARCHAR(100) (not null)\lfirst_visit_date: DATE (nullable)\lwell_depth: FLOAT (nullable)\lhole_depth: FLOAT (nullable)\lwell_casing_diameter: FLOAT (nullable)\lwell_casing_depth: FLOAT (nullable)\lwell_completion_date: DATE (nullable)\lwell_driller_name: VARCHAR(200) (nullable)\l+ well_construction_method: VARCHAR(100) (nullable)\l+ well_pump_type: VARCHAR(100) (nullable)\lwell_pump_depth: FLOAT (nullable)\l+ formation_completion_code: VARCHAR(100) (nullable)\lis_suitable_for_datalogger: BOOLEAN (nullable)\l+ spring_type: VARCHAR(100) (nullable)\lsearch_vector: TSVECTOR (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "thing_aquifer_association" [label="{thing_aquifer_association|+ thing_id: INTEGER (not null)\l+ aquifer_system_id: INTEGER (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "thing_contact_association" [label="{thing_contact_association|+ thing_id: INTEGER (not null)\l+ contact_id: INTEGER (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l}"];
  "thing_geologic_formation_association" [label="{thing_geologic_formation_association|+ thing_id: INTEGER (not null)\l+ geologic_formation_id: INTEGER (nullable)\ltop_depth: FLOAT (not null)\lbottom_depth: FLOAT (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "thing_id_link" [label="{thing_id_link|+ thing_id: INTEGER (not null)\l+ relation: VARCHAR(100) (not null)\lalternate_id: VARCHAR(100) (not null)\l+ alternate_organization: VARCHAR(100) (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "thing_version" [label="{thing_version|nma_pk_welldata: VARCHAR (nullable)\lname: VARCHAR (nullable)\lthing_type: VARCHAR(100) (nullable)\lfirst_visit_date: DATE (nullable)\lwell_depth: FLOAT (nullable)\lhole_depth: FLOAT (nullable)\lwell_casing_diameter: FLOAT (nullable)\lwell_casing_depth: FLOAT (nullable)\lwell_completion_date: DATE (nullable)\lwell_driller_name: VARCHAR(200) (nullable)\lwell_construction_method: VARCHAR(100) (nullable)\lwell_pump_type: VARCHAR(100) (nullable)\lwell_pump_depth: FLOAT (nullable)\lformation_completion_code: VARCHAR(100) (nullable)\lis_suitable_for_datalogger: BOOLEAN (nullable)\lspring_type: VARCHAR(100) (nullable)\lsearch_vector: TSVECTOR (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (nullable) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\lrelease_status: VARCHAR(100) (nullable)\l* transaction_id: BIGINT (not null)\lend_transaction_id: BIGINT (nullable)\loperation_type: SMALLINT (not null)\l}"];
  "transaction" [label="{transaction|* id: BIGINT (not null)\lremote_addr: VARCHAR(50) (nullable)\l+ user_id: INTEGER (nullable)\lissued_at: DATETIME (nullable)\l}"];
  "transducer_observation" [label="{transducer_observation|+ parameter_id: INTEGER (not null)\l+ deployment_id: INTEGER (not null)\lobservation_datetime: DATETIME (not null)\lvalue: FLOAT (not null)\lnma_waterlevelscontinuous_pressure_conddl_ms_cm: FLOAT (nullable)\lnma_waterlevelscontinuous_pressure_checked_by: VARCHAR(4) (nullable)\lnma_waterlevelscontinuous_pressure_created: DATETIME (nullable)\lnma_waterlevelscontinuous_pressure_data_source: VARCHAR(5) (nullable)\lnma_waterlevelscontinuous_pressure_global_id: VARCHAR(40) (nullable)\lnma_waterlevelscontinuous_pressure_measurement_method: VARCHAR(2) (nullable)\lnma_waterlevelscontinuous_pressure_measuring_agency: VARCHAR(50) (nullable)\lnma_waterlevelscontinuous_pressure_notes: VARCHAR(100) (nullable)\lnma_waterlevelscontinuous_pressure_processed_by: VARCHAR(4) (nullable)\lnma_waterlevelscontinuous_pressure_qced: BOOLEAN (nullable)\lnma_waterlevelscontinuous_pressure_temperature_water: FLOAT (nullable)\lnma_waterlevelscontinuous_pressure_updated: DATETIME (nullable)\lnma_waterlevelscontinuous_pressure_water_head: FLOAT (nullable)\lnma_waterlevelscontinuous_pressure_water_head_adjusted: FLOAT (nullable)\lnma_waterlevelscontinuous_acoustic_created: DATETIME (nullable)\lnma_waterlevelscontinuous_acoustic_data_source: VARCHAR(5) (nullable)\lnma_waterlevelscontinuous_acoustic_global_id: VARCHAR(40) (nullable)\lnma_waterlevelscontinuous_acoustic_measurement_method: VARCHAR(2) (nullable)\lnma_waterlevelscontinuous_acoustic_measuring_agency: VARCHAR(50) (nullable)\lnma_waterlevelscontinuous_acoustic_notes: VARCHAR(200) (nullable)\lnma_waterlevelscontinuous_acoustic_point_id: VARCHAR(50) (nullable)\lnma_waterlevelscontinuous_acoustic_pre_process_data_field: FLOAT (nullable)\lnma_waterlevelscontinuous_acoustic_public_release: BOOLEAN (nullable)\lnma_waterlevelscontinuous_acoustic_sensor_hgt_above_mp: FLOAT (nullable)\lnma_waterlevelscontinuous_acoustic_serial_no: VARCHAR(50) (nullable)\lnma_waterlevelscontinuous_acoustic_server_receipt_date: DATETIME (nullable)\lnma_waterlevelscontinuous_acoustic_speaker_to_mic_length: FLOAT (nullable)\lnma_waterlevelscontinuous_acoustic_temperature_air: FLOAT (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "transducer_observation_block" [label="{transducer_observation_block|+ thing_id: INTEGER (not null)\l+ parameter_id: INTEGER (not null)\l+ review_status: VARCHAR(100) (not null)\lstart_datetime: DATETIME (not null)\lend_datetime: DATETIME (not null)\lcomment: TEXT (nullable)\l+ reviewer_id: INTEGER (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "user" [label="{user|* id: INTEGER (not null)\lusername: VARCHAR(255) (not null)\l}"];
  "well_casing_material" [label="{well_casing_material|+ thing_id: INTEGER (not null)\l+ material: VARCHAR(100) (not null)\lsearch_vector: TSVECTOR (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "well_purpose" [label="{well_purpose|+ thing_id: INTEGER (not null)\l+ purpose: VARCHAR(100) (not null)\lsearch_vector: TSVECTOR (not null)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];
  "well_screen" [label="{well_screen|+ thing_id: INTEGER (not null)\l+ aquifer_system_id: INTEGER (nullable)\l+ geologic_formation_id: INTEGER (nullable)\lscreen_depth_top: FLOAT (nullable)\lscreen_depth_bottom: FLOAT (nullable)\l+ screen_type: VARCHAR(100) (nullable)\lscreen_description: VARCHAR(1000) (nullable)\lnma_pk_wellscreens: VARCHAR(100) (nullable)\l* id: INTEGER (not null)\lcreated_at: DATETIME (not null) default=timezone(:timezone_1, now())\lcreated_by_name: VARCHAR(255) (nullable)\lcreated_by_id: VARCHAR(255) (nullable)\lupdated_by_name: VARCHAR(255) (nullable)\lupdated_by_id: VARCHAR(255) (nullable)\l+ release_status: VARCHAR(100) (nullable)\l}"];

  "address" -> "contact" [xlabel="contact_id -> id"];
  "address" -> "lexicon_term" [xlabel="address_type -> term"];
  "address" -> "lexicon_term" [xlabel="release_status -> term"];
  "analysis_method" -> "lexicon_term" [xlabel="analysis_method_type -> term"];
  "analysis_method" -> "lexicon_term" [xlabel="source_organization -> term"];
  "analysis_method" -> "lexicon_term" [xlabel="release_status -> term"];
  "aquifer_system" -> "lexicon_term" [xlabel="primary_aquifer_type -> term"];
  "aquifer_system" -> "lexicon_term" [xlabel="geographic_scale -> term"];
  "aquifer_system" -> "lexicon_term" [xlabel="release_status -> term"];
  "aquifer_type" -> "thing_aquifer_association" [xlabel="thing_aquifer_association_id -> id"];
  "aquifer_type" -> "lexicon_term" [xlabel="aquifer_type -> term"];
  "aquifer_type" -> "lexicon_term" [xlabel="release_status -> term"];
  "asset" -> "lexicon_term" [xlabel="release_status -> term"];
  "asset_thing_association" -> "asset" [xlabel="asset_id -> id"];
  "asset_thing_association" -> "thing" [xlabel="thing_id -> id"];
  "collaborative_network_well" -> "thing" [xlabel="thing_id -> id"];
  "contact" -> "lexicon_term" [xlabel="organization -> term"];
  "contact" -> "lexicon_term" [xlabel="role -> term"];
  "contact" -> "lexicon_term" [xlabel="contact_type -> term"];
  "contact" -> "lexicon_term" [xlabel="release_status -> term"];
  "data_provenance" -> "lexicon_term" [xlabel="origin_type -> term"];
  "data_provenance" -> "lexicon_term" [xlabel="collection_method -> term"];
  "data_provenance" -> "lexicon_term" [xlabel="accuracy_unit -> term"];
  "data_provenance" -> "lexicon_term" [xlabel="release_status -> term"];
  "deployment" -> "thing" [xlabel="thing_id -> id"];
  "deployment" -> "sensor" [xlabel="sensor_id -> id"];
  "deployment" -> "lexicon_term" [xlabel="recording_interval_units -> term"];
  "deployment" -> "lexicon_term" [xlabel="release_status -> term"];
  "email" -> "contact" [xlabel="contact_id -> id"];
  "email" -> "lexicon_term" [xlabel="email_type -> term"];
  "email" -> "lexicon_term" [xlabel="release_status -> term"];
  "field_activity" -> "field_event" [xlabel="field_event_id -> id"];
  "field_activity" -> "lexicon_term" [xlabel="activity_type -> term"];
  "field_activity" -> "lexicon_term" [xlabel="release_status -> term"];
  "field_event" -> "thing" [xlabel="thing_id -> id"];
  "field_event" -> "lexicon_term" [xlabel="release_status -> term"];
  "field_event_participant" -> "field_event" [xlabel="field_event_id -> id"];
  "field_event_participant" -> "contact" [xlabel="contact_id -> id"];
  "field_event_participant" -> "lexicon_term" [xlabel="participant_role -> term"];
  "field_event_participant" -> "lexicon_term" [xlabel="release_status -> term"];
  "geochronology_age" -> "lexicon_term" [xlabel="method -> term"];
  "geologic_formation" -> "lexicon_term" [xlabel="formation_code -> term"];
  "geologic_formation" -> "lexicon_term" [xlabel="lithology -> term"];
  "geologic_formation" -> "lexicon_term" [xlabel="release_status -> term"];
  "group" -> "lexicon_term" [xlabel="group_type -> term"];
  "group" -> "group" [xlabel="parent_group_id -> id"];
  "group" -> "lexicon_term" [xlabel="release_status -> term"];
  "group_thing_association" -> "group" [xlabel="group_id -> id"];
  "group_thing_association" -> "thing" [xlabel="thing_id -> id"];
  "incomplete_nma_phone" -> "contact" [xlabel="contact_id -> id"];
  "lexicon_term_category_association" -> "lexicon_term" [xlabel="term_id -> id"];
  "lexicon_term_category_association" -> "lexicon_category" [xlabel="category_id -> id"];
  "lexicon_triple" -> "lexicon_term" [xlabel="subject -> term"];
  "lexicon_triple" -> "lexicon_term" [xlabel="object_ -> term"];
  "location" -> "lexicon_term" [xlabel="release_status -> term"];
  "location_thing_association" -> "location" [xlabel="location_id -> id"];
  "location_thing_association" -> "thing" [xlabel="thing_id -> id"];
  "measuring_point_history" -> "thing" [xlabel="thing_id -> id"];
  "measuring_point_history" -> "lexicon_term" [xlabel="release_status -> term"];
  "monitoring_frequency_history" -> "thing" [xlabel="thing_id -> id"];
  "monitoring_frequency_history" -> "lexicon_term" [xlabel="monitoring_frequency -> term"];
  "monitoring_frequency_history" -> "lexicon_term" [xlabel="release_status -> term"];
  "notes" -> "lexicon_term" [xlabel="note_type -> term"];
  "notes" -> "lexicon_term" [xlabel="release_status -> term"];
  "observation" -> "sample" [xlabel="sample_id -> id"];
  "observation" -> "sensor" [xlabel="sensor_id -> id"];
  "observation" -> "analysis_method" [xlabel="analysis_method_id -> id"];
  "observation" -> "parameter" [xlabel="parameter_id -> id"];
  "observation" -> "lexicon_term" [xlabel="unit -> term"];
  "observation" -> "lexicon_term" [xlabel="groundwater_level_reason -> term"];
  "observation" -> "lexicon_term" [xlabel="release_status -> term"];
  "parameter" -> "lexicon_term" [xlabel="parameter_name -> term"];
  "parameter" -> "lexicon_term" [xlabel="matrix -> term"];
  "parameter" -> "lexicon_term" [xlabel="parameter_type -> term"];
  "parameter" -> "lexicon_term" [xlabel="default_unit -> term"];
  "parameter" -> "lexicon_term" [xlabel="release_status -> term"];
  "permission_history" -> "contact" [xlabel="contact_id -> id"];
  "permission_history" -> "lexicon_term" [xlabel="permission_type -> term"];
  "permission_history" -> "lexicon_term" [xlabel="release_status -> term"];
  "phone" -> "contact" [xlabel="contact_id -> id"];
  "phone" -> "lexicon_term" [xlabel="phone_type -> term"];
  "phone" -> "lexicon_term" [xlabel="release_status -> term"];
  "pub_author_contact_association" -> "pub_author" [xlabel="author_id -> id"];
  "pub_author_contact_association" -> "contact" [xlabel="contact_id -> id"];
  "pub_author_publication_association" -> "publication" [xlabel="publication_id -> id"];
  "pub_author_publication_association" -> "pub_author" [xlabel="author_id -> id"];
  "publication" -> "lexicon_term" [xlabel="publication_type -> term"];
  "regulatory_limit" -> "parameter" [xlabel="parameter_id -> id"];
  "regulatory_limit" -> "lexicon_term" [xlabel="limit_source -> term"];
  "regulatory_limit" -> "lexicon_term" [xlabel="limit_unit -> term"];
  "regulatory_limit" -> "lexicon_term" [xlabel="limit_type -> term"];
  "regulatory_limit" -> "lexicon_term" [xlabel="release_status -> term"];
  "sample" -> "field_activity" [xlabel="field_activity_id -> id"];
  "sample" -> "field_event_participant" [xlabel="field_event_participant_id -> id"];
  "sample" -> "lexicon_term" [xlabel="sample_matrix -> term"];
  "sample" -> "lexicon_term" [xlabel="sample_method -> term"];
  "sample" -> "lexicon_term" [xlabel="release_status -> term"];
  "sensor" -> "lexicon_term" [xlabel="sensor_type -> term"];
  "sensor" -> "lexicon_term" [xlabel="owner_agency -> term"];
  "sensor" -> "lexicon_term" [xlabel="sensor_status -> term"];
  "sensor" -> "lexicon_term" [xlabel="release_status -> term"];
  "status_history" -> "lexicon_term" [xlabel="status_type -> term"];
  "status_history" -> "lexicon_term" [xlabel="status_value -> term"];
  "status_history" -> "lexicon_term" [xlabel="release_status -> term"];
  "thing" -> "lexicon_term" [xlabel="thing_type -> term"];
  "thing" -> "lexicon_term" [xlabel="well_construction_method -> term"];
  "thing" -> "lexicon_term" [xlabel="well_pump_type -> term"];
  "thing" -> "lexicon_term" [xlabel="formation_completion_code -> term"];
  "thing" -> "lexicon_term" [xlabel="spring_type -> term"];
  "thing" -> "lexicon_term" [xlabel="release_status -> term"];
  "thing_aquifer_association" -> "thing" [xlabel="thing_id -> id"];
  "thing_aquifer_association" -> "aquifer_system" [xlabel="aquifer_system_id -> id"];
  "thing_aquifer_association" -> "lexicon_term" [xlabel="release_status -> term"];
  "thing_contact_association" -> "thing" [xlabel="thing_id -> id"];
  "thing_contact_association" -> "contact" [xlabel="contact_id -> id"];
  "thing_geologic_formation_association" -> "thing" [xlabel="thing_id -> id"];
  "thing_geologic_formation_association" -> "geologic_formation" [xlabel="geologic_formation_id -> id"];
  "thing_geologic_formation_association" -> "lexicon_term" [xlabel="release_status -> term"];
  "thing_id_link" -> "thing" [xlabel="thing_id -> id"];
  "thing_id_link" -> "lexicon_term" [xlabel="relation -> term"];
  "thing_id_link" -> "lexicon_term" [xlabel="alternate_organization -> term"];
  "thing_id_link" -> "lexicon_term" [xlabel="release_status -> term"];
  "transaction" -> "user" [xlabel="user_id -> id"];
  "transducer_observation" -> "parameter" [xlabel="parameter_id -> id"];
  "transducer_observation" -> "deployment" [xlabel="deployment_id -> id"];
  "transducer_observation" -> "lexicon_term" [xlabel="release_status -> term"];
  "transducer_observation_block" -> "thing" [xlabel="thing_id -> id"];
  "transducer_observation_block" -> "parameter" [xlabel="parameter_id -> id"];
  "transducer_observation_block" -> "lexicon_term" [xlabel="review_status -> term"];
  "transducer_observation_block" -> "contact" [xlabel="reviewer_id -> id"];
  "transducer_observation_block" -> "lexicon_term" [xlabel="release_status -> term"];
  "well_casing_material" -> "thing" [xlabel="thing_id -> id"];
  "well_casing_material" -> "lexicon_term" [xlabel="material -> term"];
  "well_casing_material" -> "lexicon_term" [xlabel="release_status -> term"];
  "well_purpose" -> "thing" [xlabel="thing_id -> id"];
  "well_purpose" -> "lexicon_term" [xlabel="purpose -> term"];
  "well_purpose" -> "lexicon_term" [xlabel="release_status -> term"];
  "well_screen" -> "thing" [xlabel="thing_id -> id"];
  "well_screen" -> "aquifer_system" [xlabel="aquifer_system_id -> id"];
  "well_screen" -> "geologic_formation" [xlabel="geologic_formation_id -> id"];
  "well_screen" -> "lexicon_term" [xlabel="screen_type -> term"];
  "well_screen" -> "lexicon_term" [xlabel="release_status -> term"];
}