This table contains expanded length compositions for commercial species.
| name | value |
|---|---|
| name | [dbo].[COM_LEN_COMPS] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 242,706 |
| Size of data | 14,336 kb |
| Size of indexes | 160 kb |
| Maximum size of a single row | 43 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| species | varchar | 4 | 4 | no | composite PK | no | ||||
| year | varchar | 4 | 4 | no | composite PK | no | ||||
| port_complex | char | 3 | 3 | no | composite PK | no | refer to port_codes table for ports included in each port_complex | |||
| gear_grp | char | 3 | 3 | no | composite PK | no | refer to gear_codes table for all included gears | |||
| live | char | 1 | 1 | no | composite PK | no | Were the fish landed live - Y or N | |||
| mark_cat | int | 10 | 4 | no | composite PK | no | Market Category (sort group) the fish were landed in | |||
| sex | char | 1 | 1 | no | composite PK | no | 1=Male, 2=Female, 9=Unknown | |||
| flength | int | 10 | 4 | no | composite PK | no | Forklength in Cm, (total length for elasmobranchs) | |||
| total | numeric | 17 | 9 | yes | no | This is the total number of fish for the expansion but does not include all fish from the landings since some strata can not be expanded. | ||||
| source | varchar | 10 | 10 | no | composite PK | no | Was this record based on actual samples or were samples borrowed - refer to documentation |
| name | object type | level |
|---|