This table hold ages for fish collected during the current sample year - it is virtually never used
name | value |
---|---|
name | [dbo].[CURRENT_AGES] |
ansi nulls | on |
quoted identifier | on |
row count | |
Size of data | 0 kb |
Size of indexes | 0 kb |
Maximum size of a single row | 222 bytes |
column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
---|---|---|---|---|---|---|---|---|---|---|
sample_no | varchar | 9 | 9 | 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 | |||||
age4 | int | 10 | 4 | yes | no | |||||
ager4 | char | 20 | 20 | yes | no | |||||
method4 | char | 10 | 10 | yes | no | |||||
comments | char | 50 | 50 | yes | no | |||||
old_sample_no | varchar | 11 | 11 | yes | no | for internal use only |