This table contains information about how borrowing was done to perform length expansions.
| name | value |
|---|---|
| name | [dbo].[LEN_EXPAND_DOCS] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 40,096 |
| Size of data | 2,328 kb |
| Size of indexes | 32 kb |
| Maximum size of a single row | 41 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| year | char | 4 | 4 | no | composite PK | no | ||||
| 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 | ||||
| port_complex | char | 3 | 3 | no | composite PK | no | ||||
| mark_cat | int | 10 | 4 | no | composite PK | no | Market Category for this strata | |||
| borrow | char | 1 | 1 | no | no | was borrowing used to expand this strata Y or N | ||||
| borrow_gear | char | 3 | 3 | yes | no | If borrowing was done, what gear was used | ||||
| borrow_port | char | 3 | 3 | yes | no | if borrowing was used, what port was used | ||||
| expanded | char | 1 | 1 | no | no | was this strata expanded Y or N | ||||
| fish_ct | varchar | 5 | 5 | yes | no | number of fish used in the expansion | ||||
| pounds | numeric | 18 | 9 | no | composite PK | no | total pounds used for the expansion |