This table contains the rough boundaries, year of implementation, gear type, and area description of Rockfish Conservation Areas as part of the commercial regulations component of the database
| name | value |
|---|---|
| name | [dbo].[REG_RCAS] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 1,298 |
| Size of data | 232 kb |
| Size of indexes | 8 kb |
| Maximum size of a single row | 3,624 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| Year | int | 10 | 4 | yes | no | |||||
| Month | nvarchar | 5 | 20 | yes | no | |||||
| Area | nvarchar | 100 | 400 | yes | no | the general location of the RCA | ||||
| Location_Id | nvarchar | 200 | 800 | yes | no | |||||
| Depths | nvarchar | 50 | 200 | yes | no | |||||
| Gear_type | nvarchar | 50 | 200 | yes | no | gear which the Conservation area applies to | ||||
| Comments | nvarchar | 500 | 2000 | yes | no |