D_USE_LOCATION - Table

WaDE [WaDE_Schema_0.25.xml]

Home Tables Schemas Diagrams Foreign Keys Indexes

Table: D_USE_LOCATION

The location of the detailed allocation, diversion, use, or return flow

Columns

PK	Name	Data Type	NULL	Auto	Default	Comment	FK
	ORGANIZATION_ID	Integer				A unique identifier assigned to the organization. Identifiers would be managed centrally by ????
	REPORT_ID	Integer				A unique identifier assigned to the report by the reporting organization.
	ALLOCATION_ID	Integer				Unique identifier for the allocation
	WATER_USER_ID	Integer				A unique identifier for the water user
	LOCATION_SEQ	Integer
	STATE	VarChar(50)				Code representing the two-digit abbreviation for the state.
	REPORTING_UINT_ID	Integer				A unique identifier assigned to the reporting unit by the reporting organization.
	COUNTY_FIPS	VarChar(20)				County FIPS code (including the state FIPS code) representing the county.
	HUC	VarChar(20)				Code representing the USGS Hydrologic Unit (or HUC) at the most detailed level that the assignment can be made (6-digit being the lowest level of resolution allowed). Leading 0's should be included.
	WFS_FEATURE_REF	VarChar(20)				Web Feature Service feature reference for the place of use

Indexes

(none)

Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_D_USE_LOCATION_DETAIL_USE	DataValues.DETAIL_USE	DataValues.D_USE_LOCATION	ORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_ID	ORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_ID

Triggers

(none)

Used in Diagrams