Skip common site navigation and headers
United States Environmental Protection Agency
STORET
Begin Hierarchical Links EPA Home > Water > Wetlands, Oceans, & Watersheds > Monitoring and Assessing Water Quality > STORET > Data Owner's Corner > System Updates > Entity Relationship Diagram End Hierarchical Links

 

STORET logo STORET Entity Relationship Diagram v1.1

This graphical representation of the STORET Entity Relationship Diagram (ERD) is provided as an aid to understanding the complexity of the STORET v1.1 database, and to assist programmers who may wish to write queries directly against the database tables or views.

Included with it is a text file listing the table and column names for the entire STORET database, in a form matching the "structure" file distributed via the STORET v1.1 CD-ROM.

NOTE: It is extremely unsafe to UPDATE directly into database tables or views. Damage to your STORET database may be beyond repair.

 

 

Download ERD_1_1.EXE (137K) Now

Quit Without Downloading File

Exit EPA Web Site
Download Free Adobe Acrobat (tm) Reader Now

This download is in the form of a compressed, self-extracting 137K file named ERD_1_1.EXE. You should place it in a temporary folder, and double-click it to allow it to expand.

In its extracted form, it will consist of a two files, named

  • Tbl_defn.txt (101K)
  • erd_1_1.pdf (99K)

The table and column definition file can be opened with Wordpad, or with a standard word processor such as Microsoft Word ® , or Word Perfect ® .

The ERD is delivered in printable form, but due to its size, it is displayed across 16 pages of 11 x 8.5 inch paper, arranged in landscape form in a 4 x 4 array, with pages numbered as follows:

Page (1,1) Page (1,2) Page (1,3) Page (1,4)
Page (2,1) Page (2,2) Page (2,3) Page (2,4)
Page (3,1) Page (3,2) Page (3,3) Page (3,4)
Page (4,1) Page (4,2) Page (4,3) Page (4,4)

Use of a color printer is recommended, but not required.

This graphical ERD is in the form of an Adobe Acrobat ® PDF file. You will need the Acrobat reader to view or print this file. A copy of the Acrobat reader was distributed on the STORET v1.0 CD, or may be downloaded free of charge from the Adobe web site using the button at the left.

To download this file, click the "Download Now" button at your left. To quit without downloading, click the "CANCEL" button.

   
 

Need Help? If you have a question, or are uncertain about this download, please call STORET User Assistance at 1-800-424-9067, or send us an email at STORET@epa.gov.

 

 
Begin Site Footer

EPA Home | Privacy and Security Notice | Contact Us