Laserfiche WebLink
<br />11J ). <br /> <br />" <br /> <br />0001156 <br /> <br />South Platte Water Rights Management System <br /> <br />Column Description <br />code ** Use type code stored in database <br />name ** Text description of code <br /> <br />** indicates primary key <br /> <br />Database Table 9: user_codes <br /> <br />System Write Permissions <br /> <br />SPWRMS determines the water districts to which a user has write permissions by <br />accessing the user_auth table. This table maps users to permission codes corresponding to <br />water districts. <br /> <br />Column Description <br />login ** The user's UNIX login name <br />permission_code ** The code describing the area for data, on 'write' to the database. <br /> These codes are described in the table permission_codes <br />name The full name of the user <br /> <br />** indicates primary key <br /> <br />Database Table 10: user_auth <br /> <br />For a discussion on the manipulation of the user_auth table, please see Section 1.4 <br />"Informix User Authorization." the of the UNIX Administrator's Guide. <br /> <br />Column Description <br />permission_code Integer permission code <br />description Description of rhe area in SPWRMS designated by the code <br /> <br />Database Table 11: permission_codes <br /> <br />Dynamic Tables <br /> <br />Dynamic tables manage data input or updated by the user or. in the case of streamflow <br />data, by an automatic satellite telemetry system. In most cases, these tables contain time <br />series data (e.g.. daily or real-time flows). <br /> <br />Water information sheet There are several tables associated with the storage of data from the Water Information <br />Sheet. Data were separated into these tables to coincide with the number of occurrences <br />for different items within the Water Information Sheet. For example, there is one main <br />comment for each information sheet; however, there are many rows associated with the <br /> <br />Database Manual 7 <br />