Provides the link between fish distribution (FishDist) and barrier (Barrier, Dam, Hatchery) tables. It has a many to one relationship with each.
| Field Name | Field Description | Data Type | Field Size* | SpecieID | The species ID. Cross reference to the Specie table. | smallint | 2 | RunID | The run ID. Cross reference to Run table. | tinyint | 1 | StageID | The Stage identifier of the fish affected. Cross reference to Stage table. | tinyint | 1 | BarrierID | Links to specific barrier in Barrier table if BarrierID > 0. | int | 4 | BlockageExtentID | Code describing the extent of the blockage. | tinyint | 1 | BlockageDesc | Description of the blockage | text | 16 | DirectionID | Code for the direction of travel impeded by the barrier. | tinyint | 1 | PositionID | Location of barrier relative to fish distribution. | tinyint | 1 | UpdDate | The date and time the record was created or updated by agency compiler. | smalldatetime | 4 | LastModifiedBy | Network ID of regional staff or compiler that last updated record. | varchar | 50 | LastModifiedOn | Date regional staff or compiler last updated record | datetime | 8 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.