This table contains expanded age compositions from commercial landings for aged species.
| name | value |
|---|---|
| name | [dbo].[COM_AGE_COMPS] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 48,713 |
| Size of data | 2,864 kb |
| Size of indexes | 40 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 | char | 4 | 4 | no | composite PK | no | ||||
| port_complex | char | 3 | 3 | no | composite PK | no | refer to port_complex codes table for a description | |||
| gear_grp | char | 3 | 3 | no | composite PK | no | refer to gear_codes table for a list of included gears | |||
| live | char | 1 | 1 | no | composite PK | no | Were the fish landed as live - Y or N | |||
| mark_cat | int | 10 | 4 | no | composite PK | no | What market category the fish were sorted into | |||
| sex | char | 1 | 1 | no | composite PK | no | 1=Male, 2=Female, 9=Unknown | |||
| age | int | 10 | 4 | no | composite PK | no | in years | |||
| total | numeric | 17 | 9 | yes | no | Total number of fish estimated, but not total from the fishery since many strata can not be expanded. | ||||
| source | char | 10 | 10 | no | composite PK | no | Was this record based on Actual samples from the strata or was Borrowing used. |
| name | object type | level |
|---|