WaDE Foreign Keys
HomeTablesSchemasDiagramsForeign KeysIndexes

Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_D_ALLOCATION_ACTUAL_D_ALLOCATION_FLOWDataValues.D_ALLOCATION_FLOWDataValues.D_ALLOCATION_ACTUALORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, DETAIL_SEQ_NOORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, DETAIL_SEQ_NO
fk_D_ALLOCATION_FLOW_DETAIL_ALLOCATIONDataValues.DETAIL_ALLOCATIONDataValues.D_ALLOCATION_FLOWORGANIZATION_ID, REPORT_ID, ALLOCATION_IDORGANIZATION_ID, REPORT_ID, ALLOCATION_ID
fk_D_ALLOCATION_USE_D_ALLOCATION_FLOWDataValues.D_ALLOCATION_FLOWDataValues.D_ALLOCATION_USEORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, DETAIL_SEQ_NOORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, DETAIL_SEQ_NO
fk_D_COMMUNITY_WATER_SUPPLY_D_CONSUMPTIVE_USEDataValues.D_CONSUMPTIVE_USEDataValues.D_COMMUNITY_WATER_SUPPLYORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_ID, BENEFICIAL_USE_IDORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_ID, BENEFICIAL_USE_ID
fk_D_CONSUMPTIVE_USE_DETAIL_USEDataValues.DETAIL_USEDataValues.D_CONSUMPTIVE_USEORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_IDORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_ID
fk_D_DIVERSION_ACTUAL_D_DIVERSION_FLOWDataValues.D_DIVERSION_FLOWDataValues.D_DIVERSION_ACTUALORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, DIVERSION_ID, DETAIL_SEQ_NOORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, DIVERSION_ID, DETAIL_SEQ_NO
fk_D_DIVERSION_FLOW_DETAIL_DIVERSIONDataValues.DETAIL_DIVERSIONDataValues.D_DIVERSION_FLOWORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, DIVERSION_IDORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, DIVERSION_ID
fk_D_DIVERSION_USE_D_DIVERSION_FLOWDataValues.D_DIVERSION_FLOWDataValues.D_DIVERSION_USEORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, DIVERSION_ID, DETAIL_SEQ_NOORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, DIVERSION_ID, DETAIL_SEQ_NO
fk_D_IRRIGATION_D_CONSUMPTIVE_USEDataValues.D_CONSUMPTIVE_USEDataValues.D_IRRIGATIONORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_ID, BENEFICIAL_USE_IDORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_ID, BENEFICIAL_USE_ID
fk_D_RETURN_FLOW_ACTUAL_DETAIL_RETURN_FLOWDataValues.DETAIL_RETURN_FLOWDataValues.D_RETURN_FLOW_ACTUALORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, RETURN_FLOW_IDORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, RETURN_FLOW_ID
fk_D_THERMOELECTRIC_D_CONSUMPTIVE_USEDataValues.D_CONSUMPTIVE_USEDataValues.D_THERMOELECTRICORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_ID, BENEFICIAL_USE_IDORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_ID, BENEFICIAL_USE_ID
fk_D_USE_AMOUNT_D_CONSUMPTIVE_USEDataValues.D_CONSUMPTIVE_USEDataValues.D_USE_AMOUNTORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_ID, BENEFICIAL_USE_IDORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_ID, BENEFICIAL_USE_ID
fk_D_USE_LOCATION_DETAIL_USEDataValues.DETAIL_USEDataValues.D_USE_LOCATIONORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_IDORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_ID
fk_DETAIL_ALLOCATION_REPORTMetadata.REPORTDataValues.DETAIL_ALLOCATIONORGANIZATION_ID, REPORT_IDORGANIZATION_ID, REPORT_ID
fk_DETAIL_DIVERSION_DETAIL_ALLOCATIONDataValues.DETAIL_ALLOCATIONDataValues.DETAIL_DIVERSIONORGANIZATION_ID, REPORT_ID, ALLOCATION_IDORGANIZATION_ID, REPORT_ID, ALLOCATION_ID
fk_DETAIL_RETURN_FLOW_DETAIL_ALLOCATIONDataValues.DETAIL_ALLOCATIONDataValues.DETAIL_RETURN_FLOWORGANIZATION_ID, REPORT_ID, ALLOCATION_IDORGANIZATION_ID, REPORT_ID, ALLOCATION_ID
fk_DETAIL_USE_DETAIL_ALLOCATIONDataValues.DETAIL_ALLOCATIONDataValues.DETAIL_USEORGANIZATION_ID, REPORT_ID, ALLOCATION_IDORGANIZATION_ID, REPORT_ID, ALLOCATION_ID
fk_REPORTING_UNIT_REPORTMetadata.REPORTDataValues.REPORTING_UNITORGANIZATION_ID, REPORT_IDORGANIZATION_ID, REPORT_ID
fk_S_ALLOCATION_IRRIGATION_SUMMARY_ALLOCATIONDataValues.SUMMARY_ALLOCATIONDataValues.S_ALLOCATION_IRRIGATIONORGANIZATION_ID, REPORT_UNIT_ID, REPORT_ID, SUMMARY_SEQORGANIZATION_ID, REPORT_UNIT_ID, REPORT_ID, SUMMARY_SEQ
fk_S_SUMMARY_AMOUNT_SUMMARY_AVAILABILITYDataValues.SUMMARY_AVAILABILITYDataValues.S_AVAILABILITY_AMOUNTORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID, SUMMARY_SEQORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID, SUMMARY_SEQ
fk_S_AVAILABILITY_METRIC_METRICSMetadata.METRICSDataValues.S_AVAILABILITY_METRICMETRIC_IDMETRIC_ID
fk_S_AVAILABILITY_METRIC_SUMMARY_AVAILABILITYDataValues.SUMMARY_AVAILABILITYDataValues.S_AVAILABILITY_METRICORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID, SUMMARY_SEQORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID, SUMMARY_SEQ
fk_S_USE_AMOUNT_SUMMARY_USEDataValues.SUMMARY_USEDataValues.S_USE_AMOUNTORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID, BENEFICIAL_USE_ID, SUMMARY_SEQORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID, BENEFICIAL_USE_ID, SUMMARY_SEQ
fk_S_USE_IRRIGATION_SUMMARY_USEDataValues.SUMMARY_USEDataValues.S_USE_IRRIGATIONORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID, SUMMARY_SEQORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID, SUMMARY_SEQ
fk_S_WATER_SUPPLY_AMOUNT_SUMMARY_WATER_SUPPLYDataValues.SUMMARY_WATER_SUPPLYDataValues.S_WATER_SUPPLY_AMOUNTORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID, SUMMARY_SEQORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID, SUMMARY_SEQ
fk_SUMMARY_ALLOCATION_REPORTING_UNITDataValues.REPORTING_UNITDataValues.SUMMARY_ALLOCATIONORGANIZATION_ID, REPORT_ID, REPORT_UNIT_IDORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID
fk_SUMMARY_AVAILABILITY_REPORTING_UNITDataValues.REPORTING_UNITDataValues.SUMMARY_AVAILABILITYORGANIZATION_ID, REPORT_ID, REPORT_UNIT_IDORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID
fk_SUMMARY_REGULATORY_REPORTING_UNITDataValues.REPORTING_UNITDataValues.SUMMARY_REGULATORYORGANIZATION_ID, REPORT_ID, REPORT_UNIT_IDORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID
fk_SUMMARY_USE_REPORTING_UNITDataValues.REPORTING_UNITDataValues.SUMMARY_USEORGANIZATION_ID, REPORT_ID, REPORT_UNIT_IDORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID
fk_SUMMARY_WATER_SUPPLY_REPORTING_UNITDataValues.REPORTING_UNITDataValues.SUMMARY_WATER_SUPPLYORGANIZATION_ID, REPORT_ID, REPORT_UNIT_IDORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID
fk_GEOSPATIAL_REF_REPORTMetadata.REPORTMetadata.GEOSPATIAL_REFORGANIZATION_ID, REPORT_IDORGANIZATION_ID, REPORT_ID
fk_METHODS_DATA_SOURCESMetadata.DATA_SOURCESMetadata.METHODSSOURCE_IDSOURCE_ID
fk_REPORT_ORGANIZATIONMetadata.ORGANIZATIONMetadata.REPORTORGANIZATION_IDORGANIZATION_ID