Laserfiche WebLink
<br />,(\ (/; <br /> <br />South Platte Water Rights Management System <br /> <br />same sheet. In addition, each row may have several priority diversions. For this reason, the <br />elements of the Water Information Sheet are stored in several separate tables. <br /> <br />These tables are updated via the Water Information Sheet; however, the data in them are <br />also used elsewhere in the SPWRMS application. Both the diversions table and the <br />exchanges table fall into this category. Data for these tables are entered through the Water <br />Information Sheet. but can be displayed through other interface mechanisms, such as <br />Query Diversions and Query Exchange Chronology. <br /> <br />The table that receives one entry for each Water Information Sheet submitted is the <br />wis_comments table. It contains the following columns: <br /> <br />Column Description <br />wd ** Water district of Water Information Sheet <br />dat ** Date of Water Information Sheet <br />comment Main comment text <br />time_saved Date and time that sheet was submitted to the database <br /> <br />** indicates primary key <br /> <br />Database Table 12: wis_comments <br /> <br />Another table holds the rows of the Water Information Sheet, including the row comments <br />and all flow numbers which are not calculated or retrieved from other tables. . <br /> <br />Column Description <br />wd ** Water district of Water Information Sheet row <br />id ** ID of Water Information Sheet row <br />dat ** Date of Water Information Sheet <br />ty ** Type of Water Information Sheet row <br />nat flow Natural flow <br />res_trans Reservoir/transfer delivery flow <br />tot_flow Total flow <br />sub_supplies Substitute supplies flow <br />dexchange Direct exchange flow <br />sexchange Storage exchange flow <br />dtrans mtn Direct trans-mountain flow <br />strans_fitn Storage trans-mountain flow <br />dstor_rel Direct storage release <br />sstor_rel Storage storage release <br />res_change Change in storage <br />res storage Total storage <br />distrib_flag Flag indicating distribute function used on priority diversion entry <br />dry_river Flag indicating priority diversion dries river <br /> <br />Database Table 13: wis_data <br /> <br />8 <br /> <br />Database Manual <br />