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 |