This table allows fulltext queries to retrieve regulations for a species when they may have been managed as part of a group and not just as a separate species.
| name | value |
|---|---|
| name | [dbo].[REG_ROCKFISH_MANAGEMENT_GROUPS] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 167 |
| Size of data | 16 kb |
| Size of indexes | 16 kb |
| Maximum size of a single row | 512 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| UID_pk | int identity (1,1) | 10 | 4 | no | yes | no | ||||
| Common_Name | varchar | 50 | 50 | no | no | |||||
| Year_Started | int | 10 | 4 | no | no | |||||
| Year_Ended | int | 10 | 4 | yes | no | |||||
| Location_ID | varchar | 200 | 200 | no | no | |||||
| Management_Group | varchar | 250 | 250 | yes | no |
| name | object type | level |
|---|