S_USE_IRRIGATION - Table

WaDE [WaDE_Schema_0.25.xml]

Home Tables Schemas Diagrams Foreign Keys Indexes

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

Indexes

(none)

Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_S_USE_IRRIGATION_SUMMARY_USE	DataValues.SUMMARY_USE	DataValues.S_USE_IRRIGATION	ORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID, SUMMARY_SEQ	ORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID, SUMMARY_SEQ

Triggers

(none)

Used in Diagrams