This table links to the Hatchery table via the HatchID field and holds the hatchery water source data. It has a many to one relationship with the Hatchery table.
| Field Name | Field Description | Data Type | Field Size* | HatchID | The ID number of the hatchery. Cross reference to Hatchery table | smallint | 2 | SourceNum | Sequential number indicating each unique water source | tinyint | 1 | LocationID | Unique identifier categorizing a line, point or polygon in either 1:100,000 or 1:24,000 scale GIS coverage. | varchar | 13 | BegFt | The distance in feet from the mouth of the stream | int | 4 | Comments | Additional information or comments. | text | 16 | UpdDate | The date and time the record was created or updated by agency compiler. | smalldatetime | 4 | NonStream | A non-stream water source (municipal, springs, wells, etc.) | varchar | 100 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.