This table contains descriptions of the market categories (sort groups) used by CDFG and CALCOM.
| name | value |
|---|---|
| name | [dbo].[MARKET_CATEGORIES] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 428 |
| Size of data | 40 kb |
| Size of indexes | 16 kb |
| Maximum size of a single row | 590 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| mark_cat | int | 10 | 4 | no | yes | no | a market category is a sort group - not a species code | |||
| description | nvarchar | 100 | 400 | yes | no | |||||
| nominal_species | varchar | 4 | 4 | yes | no | used by expansions, if no samples and operator designates to use a nominal species, this value is used to expand the strata to species | ||||
| species_grp | nvarchar | 15 | 60 | yes | no | designated species group for ease in data retrieval, Flat=flatfish, Game=gamefish, HMIG=highly migratory, inv=invertebrate, oth=other, pel=coastal pelagics, rnd =roundfish (sablefish etc...), rock=rockfish, shrk=sharks and skates, slmn=salmon, unk=unknown, usmn=unspecified salmon | ||||
| block_summary | char | 1 | 1 | yes | no | is this used in the block_summary table Y or N | ||||
| trawl_block | char | 1 | 1 | yes | no | is this value used in the trawl _block_summary table Y or N | ||||
| comments | varchar | 120 | 120 | yes | no |
| name | object type | level |
|---|