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 |