The following section provides an overview of the design of the database structure for the CRIS, commonly referred to as a data model.
List and Description of Data Tables
Description of Fields in each Data Table
There are three key tables in the database:
Measurement Set - this table contains one record (or row) for each set of measurements in the database. A measurement set represents a unique combination of date, time and location, at which one or more variables were measured.
Reading - this table contains one record for each reading recorded in the database. There can be multiple readings associated with each measurement set - one for each variable measured. The actual measurement associated with a reading is stored in one of the Value tables, depending upon its data type.
Location - this table contains one record for each named location in the database. Each location is then georeferenced using point coordinates (see Point table).
Topics Steps System Manual Home CPACC Home
Questions or problems regarding this web
site should be directed to [email protected].
Last modified: July 13, 2001