This table contains recreational data from the catch reconstruction project. It includes only rockfish from 1928-1980.
| name | value |
|---|---|
| name | [dbo].[RECON_REC_LANDS] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 5,300 |
| Size of data | 192 kb |
| Size of indexes | 16 kb |
| Maximum size of a single row | 26 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| year | int | 10 | 4 | no | composite PK | no | ||||
| area | varchar | 10 | 10 | no | composite PK | no | North (of Pt Conception) and South (of Conception) | |||
| species | varchar | 4 | 4 | no | composite PK | no | ||||
| pounds | real | 7 | 4 | yes | no | |||||
| freq | real | 7 | 4 | yes | no | Frequency (number of fish) |