This table holds individual fish data for samples collected during the current year
name | value |
---|---|
name | [dbo].[CURRENT_FISH] |
ansi nulls | on |
quoted identifier | on |
row count | 41,370 |
Size of data | 2,432 kb |
Size of indexes | 16 kb |
Maximum size of a single row | 52 bytes |
column | datatype | length | bytes | default | nulls | PK | FK | UQ | 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 | |||||
sex | int | 10 | 4 | yes | no | 1=male, 2=female, 9=unknown | ||||
flength | int | 10 | 4 | yes | no | forklength (mm) | ||||
maturity | int | 10 | 4 | yes | no | maturity code - refer to documentation | ||||
weight | real | 7 | 4 | yes | no | |||||
age | int | 10 | 4 | yes | no | age in years, seldom recorded in this table - refer to MASTER_FISH table | ||||
old_sample_no | varchar | 11 | 11 | yes | no |
name | object type | level |
---|