D_IRRIGATION - Table

WaDE [WaDE_Schema_0.25.xml]

Home Tables Schemas Diagrams Foreign Keys Indexes

Table: D_IRRIGATION

Additional Metadata for irrigation water supply uses

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
	BENEFICIAL_USE_ID	Integer
	DETAIL_SEQ_NO	Integer
	IRRIGATION_METHOD	VarChar(20)				Name of the method used to irrigate (i.e. sprinkler, flood, microirrigation, etc.)
	ACRES_IRRIGATED	VarChar(20)				Number of acres irrigated using this method.
	CROP_TYPE	VarChar(20)

Indexes

(none)

Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_D_IRRIGATION_D_CONSUMPTIVE_USE	DataValues.D_CONSUMPTIVE_USE	DataValues.D_IRRIGATION	ORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_ID, BENEFICIAL_USE_ID	ORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_ID, BENEFICIAL_USE_ID

Triggers

(none)

Used in Diagrams