This table is used when a fish was used but the sample data was incomplete. The age may be okay; however, some key information is missing.
| name | value |
|---|---|
| name | [dbo].[MISSING_DATA_FISH] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 1,699 |
| Size of data | 128 kb |
| Size of indexes | 8 kb |
| Maximum size of a single row | 112 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| sample_no | char | 11 | 11 | yes | no | |||||
| clust_no | int | 10 | 4 | yes | no | |||||
| bag_no | int | 10 | 4 | yes | no | |||||
| fish_no | int | 10 | 4 | yes | no | |||||
| fishery | varchar | 15 | 15 | yes | no | Commercial, Recreational, Research | ||||
| tlength | int | 10 | 4 | yes | no | |||||
| sex | char | 1 | 1 | yes | no | |||||
| age | int | 10 | 4 | yes | no | |||||
| species | varchar | 4 | 4 | yes | no | |||||
| cal_port | char | 3 | 3 | yes | no | |||||
| samp_date | datetime | 23 | 8 | yes | no | |||||
| comments | varchar | 50 | 50 | yes | no |