D_RETURN_FLOW_ACTUAL - Table

WaDE [WaDE_Schema_0.25.xml]

Home Tables Schemas Diagrams Foreign Keys Indexes

Table: D_RETURN_FLOW_ACTUAL

Web Feature Service feature reference for the 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
	RETURN_FLOW_ID	Integer				Unique identifier for the return flow.
	ACTUAL_SEQ_NO	Integer
	AMOUNT_VOLUME	Float				Value reported, measured, calculated, or estimated.
	UNIT_VOLUME	Float
	VALUE_TYPE_VOLUME	Float				Indicator on how the actual amount was determined (i.e. calculated, measured, estimated, or reported).
	METHOD_ID_VOLUME	Float
	AMOUNT_RATE	Float
	UNIT_RATE	Float
	VALUE_TYPE_RATE	Float
	METHOD_ID_RATE	Float
	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_D_RETURN_FLOW_ACTUAL_DETAIL_RETURN_FLOW	DataValues.DETAIL_RETURN_FLOW	DataValues.D_RETURN_FLOW_ACTUAL	ORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, RETURN_FLOW_ID	ORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, RETURN_FLOW_ID

Triggers

(none)

Used in Diagrams