Database reference - calcom

calcom -  tables -  [dbo].[CURRENT_FISH]

Description

This table holds individual fish data for samples collected during the current year
 

Table properties

namevalue
name[dbo].[CURRENT_FISH]
ansi nullson 
quoted identifieron 
row count41,370
Size of data2,432 kb
Size of indexes16 kb
Maximum size of a single row52 bytes

Columns

columndatatypelengthbytesdefaultnullsPKFKUQcomputedcomment
sample_novarchar99 no  composite PK    no   
clust_noint104 no  composite PK    no   
fish_noint104 no  composite PK    no   
speciesvarchar44 no      no   
sexint104 yes      no 
1=male, 2=female, 9=unknown
 
flengthint104 yes      no 
forklength (mm)
 
maturityint104 yes      no 
maturity code - refer to documentation
 
weightreal74 yes      no   
ageint104 yes      no 
age in years, seldom recorded in this table - refer to MASTER_FISH table
 
old_sample_novarchar1111 yes      no   

Dependency graph

Objects that depend on [dbo].[CURRENT_FISH]

nameobject typelevel



Documentation generated by SqlSpec