Laserfiche WebLink
<br />..., ,J' <br /> <br />l1UO()S7 <br /> <br />Water information sheet <br />overlay tables <br /> <br />South Platte Water Rights Management System <br /> <br />Column <br /> <br />Description <br />Row comment text <br /> <br />comment <br /> <br />** indicates primary key <br /> <br />Database Table 13: wis_data (Continued) <br /> <br />Another table holds the record of all priority diversions. The entries in this table are all <br />associated with decreed structures. <br /> <br />Column Description <br />wd ** Water district of structure <br />id ** State ID of structure <br />dat ** Date of diversion <br />adminno ** Administration number water diverted under <br />amt How amount of diversion, in cfs <br />why Diversion to direct or storage use <br /> <br />** indicates primary key <br /> <br />Database Table 14: diversions <br /> <br />And, a separate table holds exchange information for structures at which exchange water <br />is diverted. As many similar exchanges may be in place at a given structure, this table has <br />no primary key. <br /> <br />Column Description <br />seCdate Date of exchange. <br />to_wd Water district of to (diverting) structure. <br />to_id ID of to (diverting) structure. <br />from wd Water district of from structure. <br />from id ID of from structure. <br />from_name Name of from structure. <br />amount Amount of exchange. <br />adminno Administration number under which exchange is made. <br />why Exchange for direct or storage use. <br />comments Exchange comment text. <br /> <br />Database Table 15: exchanges <br /> <br />Overlay information for water information sheets is temporarily stored in four tables (each <br />table mimicking the corresponding water information sheet table). Information is stored in <br />these table when an overlay is submitted. When a water information sheet is committed <br />(stored in the water information sheet tables) the data related to that water information <br />sheet is removed from the overlay tables. This prevents the collection of old overlay data. <br /> <br />Database Manual <br /> <br />9 <br />