calcom - [dbo].[FLATFISH_BIN

Description

This table contains header data for flatfish Bin samples (samples based on number of fish, not weight). These are rescued samples.

column	datatype	length	bytes	nulls	PK	computed	comment
sample_no	varchar	16	16	no	yes	no
port_complex	nvarchar	5	20	yes		no
sample_date	datetime	23	8	yes		no
vessel	int	10	4	yes		no
block	float	15	4	yes		no	CDFG block number - refer to documentation
depth	float	15	4	yes		no	fathoms
days	int	10	4	yes		no
drags	int	10	4	yes		no
minutes	int	10	4	yes		no
size	nvarchar	4	16	yes		no	CDFG size codes - no definitions available at this time
pink_ticket	nvarchar	10	40	yes		no
gear	nvarchar	5	20	yes		no
mark_cat	int	10	4	yes		no	Market Category - a sort group not a species code
total_wgt	float	15	4	yes		no	landed weight for this sample in pounds
species_grp	nvarchar	5	20	yes		no	a species identification method used by CDFG - no apparent value to our program
old_sample_no	nvarchar	16	64	yes		no
comments	nvarchar	255	1020	yes		no