MitMonData Table

Many to one relationship with the MitMonType table via ProjID, WLID, and MonitoringID

Field Name Field Description Data Type Field Size*
ProjID StreamNet project ID. Cross reference to MitProject table. int 4
WLID ID code unique to each work type by location, within a project. Cross reference to MitMonType table. tinyint 1
MonitoringID Classification for general monitoring type tinyint 1
DataTypeID Code for more detailed data type collected tinyint 1
Comments Additional information or comments. text 16

*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.


Revised Wednesday September 28 2005