StreamNet

MitSpecies Table

Many to one relationship with MitProject table via ProjID.

Field Name Field Description Data Type Field Size*

ProjID StreamNet project ID. Cross reference to MitProject table int 4

SpecieID The species ID. Cross reference to the Specie table. smallint 2

RunID Run code for affected run tinyint 1

SubrunID The subrun ID, foreign key to table SubRun tinyint 1

ProdID Code describing the production type of the fish. Natural in this database applies to stocks and situations that cannot be explicitly linked to a hatchery stock. For example, redd counts are assumed to be Natural, though some may be of hatchery orgin tinyint 1

BenefitID Is species a primary or secondary beneficiary of project 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.

Field Name	Field Description	Data Type	Field Size*
ProjID	StreamNet project ID. Cross reference to MitProject table	int	4
SpecieID	The species ID. Cross reference to the Specie table.	smallint	2
RunID	Run code for affected run	tinyint	1
SubrunID	The subrun ID, foreign key to table SubRun	tinyint	1
ProdID	Code describing the production type of the fish. Natural in this database applies to stocks and situations that cannot be explicitly linked to a hatchery stock. For example, redd counts are assumed to be Natural, though some may be of hatchery orgin	tinyint	1
BenefitID	Is species a primary or secondary beneficiary of project	tinyint	1
Comments	Additional information or comments.	text	16

MitSpecies Table

Revised Wednesday September 28 2005