This table contains cluster data for all port samples except those from the current year.
| name | value |
|---|---|
| name | [dbo].[MASTER_CLUSTS] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 112,951 |
| Size of data | 5,816 kb |
| Size of indexes | 40 kb |
| Maximum size of a single row | 36 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 | ||||
| species | varchar | 4 | 4 | no | composite PK | no | ||||
| total | int | 10 | 4 | no | no | This is the total number of fish of the species in this cluster (sub-sample). | ||||
| weight | int | 10 | 4 | no | no | this is the weight of the species in this cluster. | ||||
| old_sample_no | varchar | 11 | 11 | yes | no | This is the final sample number used in the previous version of CALCOM. |
| name | object type | level |
|---|