Laserfiche WebLink
<br />08u:];)6 <br /> <br />Task I - Design Database Structure for Administrative Databases <br /> <br />Responsibility: State <br /> <br />Objective: Design a relational database structure which allows storage of administrative <br />data for the Water Administration Tool. These tables will be designed to be a part of and <br />consistent with HydroBase to simplify maintenance. These tables will be the same on <br />both a workstation and Pc. <br /> <br />Approach: <br /> <br />Figure 1.1 presenls a conceptual design of the tables required for the Administration Tool <br />implementation. It connects to the existing HydroBase design at the structure rable. <br />Throughout this task, the name provided in parenthesis corresponds to a table namc in <br />Figure 1.1. if the name is the same. the parenthesis are empty. For example. Water <br />Information Sheet Data (WIS_Data), indicates water information sheet data is in table <br />WIS_Data of figure 1.1. Similarly, Diversions 0 indicates Priority Diversion data exists <br />in the Priority Diversion table in figure 1.\. <br /> <br />.1. \Vater Information Sheet Table(s) This task is expected to include the design of <br />live tables; the Water Information Sheet Data (WIS_Data), Water Information Sheet <br />Comments (WIS_Comments), Priority diversions 0, Exchange di\'ersions 0 and <br />Delivery diversions (). The Water Information Sheet table contains data obtained <br />from daily District Water Worksheets and Division Worksheets used in water <br />administration. These Key Structures are e:-;pected to number approximately 30 - 40 <br />structures per Water District, although the software will be designed to accommodate <br />as many structures as needed. Division Worksheets are expected to be a subset or <br />concatenation of District Water Worksheets in their division. Both worksheets are <br />expected to have similar types of data (river llows. diversions. reservoir readings). <br />The Water Information Sheet Comment. Priority diversions. E:-;change diversions and <br />Delivery diversions are self explanatory. <br /> <br />\ .2. Water Inform:ltion Sheet Format This task includes the design of t\\'o rabIes: the <br />Water Information Sheet Format (WIS Format) table and Water Informallon Sheet <br />Formula (WIS_Formula) table. The WIS format table contains the inlt)ffllation <br />required to present \\'ater information in a spreadsheet (matrix) format. This <br />information is e:-;pecled to define each entry as a string. a structure. a spot check. a <br />110w gage or a formula. They contain date information which will allow the Water <br />Administration Tool to track and present a District or Division Information <br />Worksheet which may change over time. The WIS Formula table contains the <br />information required to store user defined formulas. <br /> <br />1.3. Special Project Data Tables This task includes the design of two tables; the Special <br />Project data (Special_Data) and Special Project Formatted Data (Formatted_Special). <br />The Special Project data table will contain a monthly snapshot of a Special Project <br />sheet stored as a blob. The Special Project Formatted data table will contain daily <br />formatted data from District, Division, or Non-State Entity special project sheets <br />which can be imported into Water Information Sheets. <br /> <br />e: \ \VIe rdss\seope\ph III b\seope.doe <br /> <br />2/19/97-7 <br />