S_USE_AMOUNT - Table

WaDE [WaDE_Schema_0.25.xml]

Home Tables Schemas Diagrams Foreign Keys Indexes

Table: S_USE_AMOUNT

Amount of water used

Columns

PK	Name	Data Type	NULL	Auto	Default	Comment	FK
	ORGANIZATION_ID	Integer
	REPORT_ID	Integer				A unique identifier assigned to the report by the reporting organization.
	REPORT_UNIT_ID	Integer
	BENEFICIAL_USE_ID	Integer
	SUMMARY_SEQ	Integer
	ROW_SEQ	Integer
	AMOUNT	VarChar(50)				Value reported, measured, calculated, or estimated.
	CONSUMPTIVE_INDICATOR	VarChar(20)				An indication of whether the reported amount represents a consumptive amount or a withdrawn amount
	METHOD_ID	Integer				Method used to determine the metric, calculation or estimate.
	START_DATE	DateTime				Starting date for the availability estimate, allocation, diversion, or use. Report as MM/DD.
	END_DATE	DateTime				Ending date for the availability estimate, allocation, diversion, or use. Report as MM/DD.

Indexes

(none)

Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_S_USE_AMOUNT_SUMMARY_USE	DataValues.SUMMARY_USE	DataValues.S_USE_AMOUNT	ORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID, BENEFICIAL_USE_ID, SUMMARY_SEQ	ORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID, BENEFICIAL_USE_ID, SUMMARY_SEQ

Triggers

(none)

Used in Diagrams