This table contains age data for flatfish Bin samples (samples based on number of fish, not weight). These are rescued samples.
name | value |
---|---|
name | [dbo].[FLATFISH_BIN_AGES] |
ansi nulls | on |
quoted identifier | on |
row count | 35,318 |
Size of data | 7,752 kb |
Size of indexes | 8 kb |
Maximum size of a single row | 618 bytes |
column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
---|---|---|---|---|---|---|---|---|---|---|
sample_no | nvarchar | 100 | 400 | no | no | |||||
clust_no | int | 10 | 4 | no | no | |||||
fish_no | int | 10 | 4 | no | no | |||||
species | varchar | 4 | 4 | no | no | |||||
best_age | int | 10 | 4 | yes | no | |||||
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 | |||||
comments | char | 50 | 50 | yes | no | |||||
old_sample_no | varchar | 50 | 50 | yes | no |