this table contains the maturity codes used in the port samples. Rockfish use different codes than sablefish. Flatfish maturity codes are no longer used (unreliable).
| name | value |
|---|---|
| name | [dbo].[MATURITY_CODES] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 33 |
| Size of data | 8 kb |
| Size of indexes | 8 kb |
| Maximum size of a single row | 159 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| species_group | varchar | 4 | 4 | no | composite PK | no | species group which codes apply to: flat=flatfish, rock=rockfish, ling=lingcod, sable=sablefish | |||
| sex | char | 1 | 1 | no | composite PK | no | 1=male, 2=female, 9=unknown | |||
| code | int | 10 | 4 | no | composite PK | no | ||||
| description | varchar | 150 | 150 | yes | no |