MitDetails Table

Many to one relationship with the MitLocation table, via WLID and ProjID.

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 tinyint 1
DetailsID Treatment type details smallint 2
Quantity Quantity or measure of treatment identified in the DetailID field real 4
Units Unit of measure in Quantity field varchar 20
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