This table contains trawl effort by month and CDFG block from 1930-1952. It is part of the Catch Recon program.
| name | value |
|---|---|
| name | [dbo].[CR_TRAWL_EFFORT] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 8,741 |
| Size of data | 256 kb |
| Size of indexes | 16 kb |
| Maximum size of a single row | 20 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| year | int | 10 | 4 | no | composite PK | no | ||||
| month | int | 10 | 4 | no | composite PK | no | ||||
| block | int | 10 | 4 | no | composite PK | no | CDFG block number | |||
| no_drags | int | 10 | 4 | yes | no | number of trawls | ||||
| minutes_fished | int | 10 | 4 | yes | no | Number of minutes fished - if known |