Laserfiche WebLink
<br />1\ It.; IA <br /> <br />South Platte Water Rights Management System <br /> <br />In all cases. the columns in the overlay table are identical to the columns of the corre- <br />sponding water infonnation sheet table: <br /> <br />Overlay Table Corresponding Water Infonnation Sheet Table <br />diversions_ovrly diversions <br />wis_comments_ovrly wis_comments <br />exchanges_ovrly exchanges <br />wis_data_ovrly wis data <br /> <br />Table I: The mapping of overlay table names to corresponding WIS rable names <br /> <br />Checksheet Unlike the Water Infonnation Sheet. the South Platte Checksheet is stored in a single <br />table. Rows of the checksheet are stored as rows in a table, as follows: <br /> <br />Column Description <br />id ** Checksheet row ID <br />dat ** Date of checksheet. Format indicates month and year <br />type * * Type of row <br />day 1 through day 31 Values for flow for each day of the month <br /> <br />** indicates primary key <br /> <br />Database Table 16: checksheet_data <br /> <br />River calls Historical and current calls are stored in the calls table. This table is updated ar run-time as <br />calls are set and released. Concurrently, the call structure in memory is updated to coin- <br />cide with the state of this table. <br /> <br />Column Description <br />wd ** Water district of structure at which call is placed <br />id ** State ID of structure at which call is placed <br />date_time_set ** Date and time call is set <br />date_time released ** Date and time call is released <br />adminno ** Administration number of call <br />set_comment Comment entered as call is set <br />rei_comment Comment entered as call is released <br /> <br />** indicates primary key <br /> <br />Database Table 17: calls <br /> <br />10 <br /> <br />Database Manual <br />