MitProjXGoal Table

Cross reference to create the many-to-many relationship between the MitLocation (via WLID) and MitGoal (via GoalID) tables.

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 tinyint 1
GoalID StreamNet mitigation projects goal ID tinyint 1

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


Revised Wednesday September 28 2005