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 |
---|