this table contains individual fish data for all port samples except those caught in the current year.
| name | value |
|---|---|
| name | [dbo].[MASTER_FISH] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 1,231,434 |
| Size of data | 83,816 kb |
| Size of indexes | 328 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 in mm, total length for elasmobranchs | ||||
| maturity | int | 10 | 4 | yes | no | maturity code, refer to maturity_codes table for descriptions | ||||
| weight | real | 7 | 4 | yes | no | weight in pounds, seldom used | ||||
| age | int | 10 | 4 | yes | no | |||||
| old_sample_no | varchar | 11 | 11 | yes | no | sample number used in previous version of CALCOM |
| name | object type | level |
|---|