This table contains all regulations for federally managed groundfish.
| name | value |
|---|---|
| name | [dbo].[REG_commercial_regulations] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 4,606 |
| Size of data | 1,320 kb |
| Size of indexes | 16 kb |
| Maximum size of a single row | 8,816 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| UID_pk | int identity (1,1) | 10 | 4 | no | yes | no | ||||
| Regulation_date | datetime | 23 | 8 | yes | no | the date the regulation was implemented | ||||
| reg_year | int | 10 | 4 | yes | no | the year the regulation was implemented | ||||
| Location_id | nvarchar | 200 | 800 | yes | no | this column allows linkage to the REG_ALL_LOCATIONS table to allow searching by location | ||||
| Regulation | nvarchar | 2000 | 8000 | yes | no | the actual regulation |
| name | object type | level |
|---|