calcom - [dbo].[MASTER

Description

This table contains ages for fish often with multiple ages.  The Best_age is stored in the MASTER_FISH table.

column	datatype	length	bytes	nulls	PK	computed	comment
sample_no	varchar	9	9	no	composite PK	no
clust_no	int	10	4	no	composite PK	no
fish_no	int	10	4	no	composite PK	no
species	varchar	4	4	no		no
best_age	int	10	4	yes		no	our best guess at the age. This is stored in the Master_fish table.
age1	int	10	4	yes		no
ager1	char	20	20	yes		no
method1	char	10	10	yes		no
age2	int	10	4	yes		no
ager2	char	20	20	yes		no
method2	char	10	10	yes		no
age3	int	10	4	yes		no
ager3	char	20	20	yes		no
method3	char	10	10	yes		no
age4	int	10	4	yes		no
ager4	char	20	20	yes		no
method4	char	10	10	yes		no
old_sample_no	varchar	11	11	yes		no
comments	char	50	50	yes		no