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 |