This table contains individual fish data for BIN samples (samples based on number of fish not weight)
| name | value |
|---|---|
| name | [dbo].[FLATFISH_BIN_FISH] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 197,985 |
| Size of data | 13,344 kb |
| Size of indexes | 8 kb |
| Maximum size of a single row | 468 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| sample_no | nvarchar | 100 | 400 | no | no | |||||
| species | varchar | 4 | 4 | no | no | |||||
| sex | tinyint | 3 | 1 | no | no | 1=male, 2=female, 9=unknown | ||||
| fish_no | tinyint | 3 | 1 | no | no | |||||
| tlength | int | 10 | 4 | yes | no | total length in mm | ||||
| age | int | 10 | 4 | yes | no | |||||
| envelope_no | int | 10 | 4 | yes | no | envelope number in which age structure (otolith or opercle) is stored in | ||||
| old_sample_no | varchar | 50 | 50 | yes | no |