Database reference - calcom

calcom -  tables -  [dbo].[MARKET_CATEGORIES]

Description

This table contains descriptions of the market categories (sort groups) used by CDFG and CALCOM.
 

Table properties

namevalue
name[dbo].[MARKET_CATEGORIES]
ansi nullson 
quoted identifieron 
row count428
Size of data40 kb
Size of indexes16 kb
Maximum size of a single row590 bytes

Columns

columndatatypelengthbytesdefaultnullsPKFKUQcomputedcomment
mark_catint104 no  yes    no 
a market category is a sort group - not a species code
 
descriptionnvarchar100400 yes      no   
nominal_speciesvarchar44 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_grpnvarchar1560 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_summarychar11 yes      no 
is this used in the block_summary table Y or N
 
trawl_blockchar11 yes      no 
is this value used in the trawl _block_summary table Y or N
 
commentsvarchar120120 yes      no   

Dependency graph

Objects that depend on [dbo].[MARKET_CATEGORIES]

nameobject typelevel



Documentation generated by SqlSpec