MitOwnership Table

Many to one relationship with MitProject table via ProjID.

Field Name Field Description Data Type Field Size*
RecID Autonumber field. This field is necessary for the mitigation interface to function int 4
ProjID StreamNet project ID. Cross reference to MitProject table. int 4
OwnerName Name of owner of project site varchar 255
Percent Percentage of project site owned tinyint 1
ContactID Percentage of project site owned smallint 2
ParcelTypeID Code for the ownership category for the parcel smallint 2
OwnerTypeID Institutional status code for land owner 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