Database Structure

This table shows how the Water Resources Database (WRDB) works. The WRDB is a relational database system comprised of several related database tables as follows: 

Master (or Working) Table
Essential Data Fields				Location		Condition		Tools
Station_ID*	Date-Time	Param.Val.	PCode*	%LEW	Depth	RCode* LCode* SCode*	CCode* QCode*	Track ID* Owner	Validated Updated
Stations Table			PCodes Table	Criteria Table		CCodes Table		Tracking Table
Station ID			PCode	PCode		CCode		Track ID
Station Name			Param. Name	Month List		CCode Name		Temp. DB Name
Station Type*			Units	Priority		Description		Master DB Name
Data Freq.			Test Method	Station ID		Convert ID		Data Source
Latitude			Detect. Limit	Station Type*				Description
Longitude			Min. Limit	HUC		RCodes Table		Create Date
Elevation			Max. Limit	Branch ID*				Create Init.
River Mile			Min. Criteria	Reach_ID		RCode		Validate Date
Agency*			Max. Criteria	Agency*		Description		Validate Init.
Agency Ref. ID			Format	Remarks		Convert_RCode		Transfer Date
Remarks			Sig. Figures	Other		Calc_Stats		Transfer Init.
Other			Convert ID	Water Body Type*		NonDetect_PCode		Quality Info
Convert ID			Convert Units	Basin Name*		NonDetect_Result		QCode
Branch ID*			Convert Mult	County Name		Detect_Mult		Is Import?
Basin Name*			WQX Char Name	Eco Region*				Project Name
FIPS Code* County Name			WQX Sample Frac	Water Plan Region*		Agencies Table		Table Group
Eco Region*			WQX Units	Min. Criteria		Agency
Water Plan Region*			WQX Anal Method	Max. Criteria		Name
Water Body Type*			Updated	Violation Type		Description
HUC				Violation Freq
Reach_ID						FIPS Codes Table
Updated						FIPS Code
						County Name
						State
Branches Table		Station Grp Table	PCode Grp Table	Conv. Grp Table	Validation Table			QCodes Table
Branch ID		StationGroup	PCodeGroup	ConvGroup	Field Name			QCode
Branch Name		Station ID	PCode	ConvFrom	Valid Value			QCode Name
DS Branch ID				ConvTo	Description			Description
DS River Mile

*This field is linked to another support table with a similar name (some are grouped together in the Validate table) to provide a list of available values.