This table contains information on how age expansions were done
| name | value |
|---|---|
| name | [dbo].[AGE_EXPAND_DOCS] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 6,020 |
| Size of data | 424 kb |
| Size of indexes | 16 kb |
| Maximum size of a single row | 75 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| year | char | 4 | 4 | no | composite PK | no | This is the year the expansion was done for. | |||
| species | varchar | 4 | 4 | no | composite PK | no | ||||
| live_fish | char | 1 | 1 | no | composite PK | no | were the fish landed live, Y or N | |||
| gear_grp | char | 3 | 3 | no | composite PK | no | gear group the expansion was for (HKL, TWL, NET, POT) | |||
| port_complex | char | 3 | 3 | no | composite PK | no | port complex the expansion was for (CRS, ERK, BRG, BDG, OSF, MNT, MRO, OSB, OLA, OSD) | |||
| mark_cat | char | 3 | 3 | no | composite PK | no | Market Category - a sort group, not a species code. | |||
| borrow | char | 1 | 1 | no | composite PK | no | Was this record based on borrowing samples from a different strata (Y or N) | |||
| borrow_gear | char | 3 | 3 | no | composite PK | no | what gear (if different) was used used for the expansion | |||
| borrow_port | char | 3 | 3 | no | composite PK | no | If borrowed, what port complex used | |||
| expanded | char | 1 | 1 | no | composite PK | no | Was this strata expanded - Y or N | |||
| fish_ct | nvarchar | 10 | 40 | no | composite PK | no | Number of fish used in the expansion of this strata | |||
| pounds | numeric | 18 | 9 | no | composite PK | no | Pounds used in this strata expansion. |